Questions on UI for ASP.NET AJAX Forum

1 answer

102 views

ExcelML export all columns from datasource

Hi,

What is the way to go when I want to export all columns from a database table with ExcelML.
In the RadGrid I only show some of the columns from the DB.
In the export I want to see them all.
In my current configuration I see only the columns exported which are actually in the Grid.

Thanks.
Marc

Grid

answered on 04 Jan 2011

1 answer

208 views

Ambiguous match exception when AjaxControlToolkit controls used with ASP.Net AJAX Telerik controls

I have a web application (framework 3.5) that uses AjaxControlToolkit v 3.5.40412.2 along with Telerik.Web.UI.dll v 2010.3.1215.35

In the master page I use have AjaxControlToolkit ScriptManager with all the script references as below.

<ajaxToolKit:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true" EnablePartialRendering="true">

<Services>

<asp:ServiceReference Path="~/Services/PopulateUnitsWebServices.asmx" />

</Services>

<Services>

<asp:ServiceReference Path="~/Services/VolunteerDataService.asmx"/>

</Services>

<Scripts>

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

</Scripts>

</ajaxToolKit:ToolkitScriptManager>

<telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel" runat="server" Transparency="30" CssClass="LoadingPanel_Hay"></telerik:RadAjaxLoadingPanel>

<telerik:RadSkinManager ID="RadSkinManager1" Runat="server" Skin="Windows7">

</telerik:RadSkinManager>

In my webpage where i use controls from both Telerik.Web.UI and AjaxControlToolkit I use the RadAjaxManager as below.

<telerik:RadAjaxManager runat="server" ID="radAjax" DefaultLoadingPanelID="RadAjaxLoadingPanel">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="AvailableDonors">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="AvailableDonors" />

<telerik:AjaxUpdatedControl ControlID="SelectedDonors" />

<telerik:AjaxUpdatedControl ControlID="hdnRatingAndCommentSpace" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="SelectedDonors">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="AvailableDonors" />

<telerik:AjaxUpdatedControl ControlID="SelectedDonors" />

<telerik:AjaxUpdatedControl ControlID="hdnRatingAndCommentSpace" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

When I debug the application locally the code runs perfectly. However when I publish this site on IIS (v7 or v6) on application server I get the following Ambiguous match exception. I get the same exception when I publish the site on my local machine and run the Precompiled code.

• Ambiguous match found.

(System.Reflection.AmbiguousMatchException)

at System.RuntimeType.GetField(String name, BindingFlags bindingAttr)

at System.Web.UI.Util.GetNonPrivateFieldType(Type classType, String fieldName)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildFieldDeclaration(ControlBuilder builder)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.BaseTemplateCodeDomTreeGenerator.BuildSourceDataTreeFromBuilder(ControlBuilder builder, Boolean fInTemplate, Boolean topLevelControlInTemplate, PropertyEntry pse)

at System.Web.Compilation.TemplateControlCodeDomTreeGenerator.BuildMiscClassMembers()

at System.Web.Compilation.PageCodeDomTreeGenerator.BuildMiscClassMembers()

at System.Web.Compilation.BaseCodeDomTreeGenerator.BuildSourceDataTree()

at System.Web.Compilation.BaseCodeDomTreeGenerator.GetCodeDomTree(CodeDomProvider codeDomProvider, StringResourceBuilder stringResourceBuilder, VirtualPath virtualPath)

at System.Web.Compilation.BaseTemplateBuildProvider.GenerateCode(AssemblyBuilder assemblyBuilder)

at System.Web.Compilation.AssemblyBuilder.AddBuildProvider(BuildProvider buildProvider)

• Ambiguous match found.

(System.Web.HttpParseException)

at System.Web.Compilation.AssemblyBuilder.AddBuildProvider(BuildProvider buildProvider)

at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders()

at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()

at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)

at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert)

at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert)

at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)

at System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)

at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)

at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I have also tried using the RadScriptManager instead of AjaxToolkitScriptManager but with the same exception. I also installed Telerik assembly to the GAC but again with the same results. I also removed the RadAjaxManager from my webpage but got the same exception.

Thanks for all your help.
Pulak

ScriptManager and StyleSheetManager

answered on 04 Jan 2011

3 answers

86 views

GridDateTimeColumn not work for filter

Hi all,

My grid need filter by date, When I click calendar button at filter Calendar not showing.
Please see my code ...

<telerik:GridDateTimeColumn DataField="ETD" DataType="System.DateTime"

FilterControlWidth="120px" HeaderText="ETD"

ShowFilterIcon="False" SortExpression="ETD" UniqueName="ETD"

PickerType="DatePicker" DataFormatString="{0:D}">

<HeaderStyle Width="160px"/>

</telerik:GridDateTimeColumn>

Thanks and Best Regards.

Grid

answered on 04 Jan 2011

3 answers

141 views

RadEditor Tab order?

Hey folks,

How do i make my tab order from one control to the radeditor to only tab into the editor box where you type, and then if they press tab again, it doesnt tab within the editor, it tabs out to the next control?

I noticed even the RadEditor i'm currently typing in even tabs through the bold, italic, etc controls before goin to the editor textbox.

Editor

answered on 04 Jan 2011

3 answers

82 views

RadAjaxPanel and XmlFormView

Dear Telerik Team
Does XmlFormView Control work inside RadAjaxPanel? As You know it doesn't work inside asp.net updatepanel.

Thanks In Advance

Ajax

answered on 04 Jan 2011

4 answers

100 views

Error:- Tree view : Sys.UI.DomEvent.addHandler method, for Licensed version 2010.3.1215.40

Hello Telerik Team,

Its urgent... Today We have installed the Latest Telerik Licensed version No: 2010.3.1215.40.
But we have got the below error when click on Tree view OR Multipe TABS.

Problem is as Follows:
1) Click on any Tree view Node OR on Multiple Tabs, the Ajax control keeps on Loading and generates below javascript error:

"Sys.InvalidOperationException: Handler was not added through the Sys.UI.DomEvent.addHandler method."

Previously this was working correctly at all places with the version 2010.2.929.40

Let us know the possible solution for the same ASAP.

Regards
Sudhakar

Ajax

answered on 04 Jan 2011

11 answers

334 views

RadGrid1.SelectedValue

Is this fixed yet? because selectedvalue will still give me a null no matter what I do.

Grid

answered on 04 Jan 2011

2 answers

328 views

RadMaskedTextBox setting the mask client side

Hello,
I do have a litte Problem setting the Mask of a RadMaskedTextBox via Javascript. Actually the mask gets set correct and I'd say my code works. However, the mask only gets displayed if I start typing in the Textbox. If I set the value to something that satisfied the mask, the value isn't displayed either.
I've already found the previous Thread on this topic, but neither setting the value nor setting the length worked for me.
Here's the code I use:

<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

<script type="text/javascript">

function valueChanged(sender, eventArgs) {

var db1TextBox = $find("<%= txtFoo.ClientID %>");

var db1value = db1TextBox.get_value();

var db2TextBox = $find("<%= txtBar.ClientID %>");

var masks = [

new Telerik.Web.UI.RadLiteralMaskPart(db1value[0]),

new Telerik.Web.UI.RadLiteralMaskPart(db1value[1]),

new Telerik.Web.UI.RadLiteralMaskPart(db1value[2]),

new Telerik.Web.UI.RadLiteralMaskPart(db1value[3]),

new Telerik.Web.UI.RadLiteralMaskPart(db1value[4]),

new Telerik.Web.UI.RadLiteralMaskPart(db1value[5]),

new Telerik.Web.UI.RadNumericRangeMaskPart(0, 9, false, true),

new Telerik.Web.UI.RadNumericRangeMaskPart(0, 9, false, true)

];

db2TextBox._length = 0;

db2TextBox._setMask(masks);

db2Textbox._setValue('');

}

</script>

</telerik:RadScriptBlock>

<div>

<telerik:RadMaskedTextBox ID="txtFoo" Mask="<0..9><0..9><0..9><0..9><0..9><0..9>" runat="server" ClientEvents-OnValueChanged="valueChanged"/>

<telerik:RadMaskedTextBox ID="txtBar" runat="server"></telerik:RadMaskedTextBox>

</div>

Thanks in advance

General Discussions

answered on 04 Jan 2011

3 answers

137 views

Hide Detail table headers on Excel export when there are no data

Hi,

Is there a way to hide a detail table's headers during Excel export when there is no data for that detail table? I've set the setting

ShowHeadersWhenNoRecords="false"

on the detail tables. This works fantastic on the PDF export, but for some reason, the headers still display on the Excel export. The layout of the our grid is a master table with two detail tables underneath, to show different properties of the parent item. I bind all the tables dynamically, using OnNeedDatasource for the main table and OnDetailTableBind on the detail tables. The detail tables are not shown in the page, and only appear during the grid export.

Any help would be appreciated.
Ernest

Grid