Questions on UI for ASP.NET AJAX Forum

4 answers

5.4K+ views

[Column Name] is neither a DataColumn nor a DataRelation for table DefaultView

Hi,

I have a telerik RadGrid on a form with filters. My project is configured for .net 3.5 and everything works great including filters.

When I deploy to the test server, all the functionality except the following works as expected.

One of my columns which is boolean throws an exception whenever I try to filter on it.
Suprisingly there is another boolean column in the grid which filters perfectly.

The tags are
TAG Working Working fine on filter is
<telerik:GridCheckBoxColumn DataField="IsTrial" DataType="System.Boolean" FilterControlAltText="Filter IsTrial column"
HeaderText="IsTrial" SortExpression="IsTrial" UniqueName="IsTrial"></telerik:GridCheckBoxColumn>
TAG Failing on Filter is
<telerik:GridCheckBoxColumn DataField="IsBilled" DataType="System.Boolean" FilterControlAltText="Filter IsBilled column" HeaderText="IsBilled" SortExpression="IsBilled" UniqueName="IsBilled" ></telerik:GridCheckBoxColumn>

I see on the following error in the browser when I select filter "equal to" on the IsBilled column

Server Error in '/' Application.

IsBilled is neither a DataColumn nor a DataRelation for table DefaultView.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: IsBilled is neither a DataColumn nor a DataRelation for table DefaultView.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            [ArgumentException: IsBilled is neither a DataColumn nor a DataRelation for table DefaultView.]
   System.Data.DataRowView.get_Item(String property) +1742474
   lambda_method(ExecutionScope , DataRowView ) +211
   System.Linq.WhereEnumerableIterator`1.MoveNext() +161
   System.Linq.Enumerable.Count(IEnumerable`1 source) +189
   lambda_method(ExecutionScope ) +117
   System.Linq.EnumerableExecutor`1.Execute() +103
   System.Linq.EnumerableExecutor`1.ExecuteBoxed() +23
   System.Linq.EnumerableQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +83
   Telerik.Web.UI.GridDynamicQueryable.Count(IQueryable source) +143
   Telerik.Web.UI.GridDataTableFromEnumerable.FillData35() +3353
   Telerik.Web.UI.GridDataTableFromEnumerable.FillData() +628
   Telerik.Web.UI.GridResolveEnumerable.Initialize() +32
   Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized() +20
   Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, DataView dataView, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText) +163
   Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText) +71
   Telerik.Web.UI.GridDataSourceHelper.GetResolvedDataSource(GridTableView owner, Object dataSource, String dataMember, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText) +398
   Telerik.Web.UI.GridTableView.get_ResolvedDataSource() +158
   Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +316
   Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +545
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +31
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
   Telerik.Web.UI.GridTableView.PerformSelect() +16
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   Telerik.Web.UI.GridTableView.DataBind() +229
   Telerik.Web.UI.GridTableView.Rebind() +48
   Telerik.Web.UI.GridFilterCommandEventArgs.ExecuteCommand(Object source) +524
   Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +134
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +38
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +87
   Telerik.Web.UI.GridItem.FireCommandEvent(String commandName, Object commandArgument) +46
   Telerik.Web.UI.RadGrid.RaisePostBackEvent(String eventArgument) +8017
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3625; ASP.NET Version:2.0.50727.3634
----

Grid

answered on 14 Feb 2018

0 answers

48 views

Demo for Custom appointment edit?

Where can I find a demo and documentation regarding creating a custom appointment edit form?

Scheduler

asked on 14 Feb 2018

3 answers

80 views

GridDropDownColumn GroupByExpression error

I want to use a "GridDropDownColumn" column as shown in the example:

<form id="form1" runat="server">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<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>

</telerik:RadScriptManager>

<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AllowPaging="True" DataSourceID="LinqDataSource1"

AutoGenerateColumns="False" ShowGroupPanel="True" EnableHeaderContextMenu="True">

<pagerstyle mode="NextPrevAndNumeric" />

<ClientSettings AllowDragToGroup="True"/>

<mastertableview commanditemdisplay="Top" datakeynames="ProductID" datasourceid="LinqDataSource1" editmode="InPlace">

<Columns>

<telerik:GridBoundColumn DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" UniqueName="ProductName"/>

<telerik:GridDropDownColumn DataField="CategoryID" DataType="System.Int32" HeaderText="Category"

UniqueName="CategoryID" DataSourceID="LinqDataSource2" ListValueField="CategoryID" ListTextField="CategoryName"

SortExpression="Categories.CategoryName" GroupByExpression="Categories.CategoryName [Category] Group By Categories.CategoryName"/>

<telerik:GridBoundColumn DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" UniqueName="UnitPrice"/>

<telerik:GridBoundColumn DataField="UnitsInStock" HeaderText="UnitsInStock" SortExpression="UnitsInStock" UniqueName="UnitsInStock"/>

<telerik:GridCheckBoxColumn DataField="Discontinued" HeaderText="Discontinued" SortExpression="Discontinued" UniqueName="Discontinued"/>

</Columns>

</mastertableview>

</telerik:RadGrid>

<asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="TelerikWebSample.DataClasses1DataContext"

EntityTypeName="" TableName="Products"/>

<asp:LinqDataSource ID="LinqDataSource2" runat="server" ContextTypeName="TelerikWebSample.DataClasses1DataContext"

EntityTypeName="" TableName="Categories" Select="new (CategoryID, CategoryName)"/>

</form>

When grouped by that column I get the following error:

"Field Categories.CategoryName not found in the source table. Please check the expression syntax."

However, when you add a new column that is not visible with the "Categories.CategoryName" field, everything works perfectly.

<telerik:GridBoundColumn DataField="Categories.CategoryName" UniqueName="CategoryName" Visible="False"/>

What is this about?.

Is there a solution to avoid unnecessarily using this non-visible column?

Thanks for the help.

Delvis

Grid

answered on 14 Feb 2018

3 answers

591 views

Error while exporting data to Excel from RadGrid

When I try to export data to Excel from RadGrid in localhost it works fine, but if I publish my page in the server it stops working.

I have the next code:

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
radGridAlerts.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;
radGridAlerts.ExportSettings.FileName = "Alerts Data";
radGridAlerts.ExportSettings.IgnorePaging = true;
radGridAlerts.MasterTableView.ExportToExcel();
}

Do you know why happens?

General Discussions

answered on 14 Feb 2018

0 answers

52 views

Expand Collapse child grid row - Double Icon

Hi,

Does telerik support expand/collapse child views?

I tried to add one, but it either shows no icon for expand/collapse all rows, or double icon. see attached.

Below is the code I am using

<telerik:RadGrid ID="grdMain" runat="server" GridLines="None" EnableAJAX="true" EnableAJAXLoadingTemplate="true"
PageSize="50" AllowMultiRowSelection="true">
<ExportSettings>
<Pdf PageBottomMargin="" PageFooterMargin="" PageHeaderMargin="" PageHeight="11in"
PageLeftMargin="" PageRightMargin="" PageTopMargin="" PageWidth="8.5in" />
</ExportSettings>
<ClientSettings Selecting-AllowRowSelect="true" />
<MasterTableView AllowPaging="True" DataMember="Master" AutoGenerateColumns="False"
AllowSorting="True" HierarchyLoadMode="Client" Name="MainTable" EnableHierarchyExpandAll="true">
<ItemStyle BackColor="White" />
<AlternatingItemStyle BackColor="#F2F2F2" />
<Columns>
<telerik:GridExpandColumn />

......Rest of the columns code

Please suggest if there is a way to hide the additional expand/collapse icon

thank you

Grid

asked on 14 Feb 2018

11 answers

262 views

Control Panel Issues

First a suggestion for Control Panel - it might be a good idea to create a forum for it. It's not a product, but could require support, and it's difficult to know which forum messages might be posted in to research issues...

So I'm having a couple issues with Telerik Control Panel I'd like to get help with:

I have a license for the DevCraft Complete suite, which includes the Kendo line of products. However, since I downloaded the trial versions before licensing was worked out, I assume, the trial version are still showing in my control panel (see attached image). So I keep getting reminders to renew my license, even though I HAVE, and the Kendo products show both as PURCHASED, and as TRIAL. So how do I remove the trial ones? It doesn't look like it's possible to do it in the control panel, but I'm hoping it is possible somewhere??
Also, it would be nice to be able to enable reminders for updates to licensed products, but not for subscription renewals, or even trial renewals. It's annoying to get reminders for trials I have no intention of purchasing, but I do want reminders to update existing products I have already purchased...

Hope that makes sense.

Thanks!
Eddie

Installer and VS Extensions

answered on 14 Feb 2018

1 answer

542 views

What is the sort expression for dynamic columns that come from a collection?

Some columns in my grid are being added dynamically; their count and names come from a collection. All items in the grid have the same dynamic columns.
My data object looks like this:

class MyDataObject

{

int ID;

string Name;

List<DynamicColumn> DynamicColumns;

}

/// <summary>

/// Holds a value for a single dynamic column cell

/// </summary>

class DynamicColumn

{

int DynamicColumnDefinitionId; // points to an item in a global collection that defines the dynamic columns for the whole grid.

int Value;

}

My question:
How can I sort by one of the dynamic columns? Can I use a sort expression like "DynamicColumn[i]" ?

Grid

answered on 14 Feb 2018

0 answers

149 views

unrecognized tag prefix telerik

Hello,

I'am using Visual Studio 2012. framework 4.0

Telerik Dll Version 2016.2.607.40

i'am getting error as "unrecognized tag prefix telerik"

same solution working on another machine

i'm attaching the screen shot for same

thanks

General Discussions

asked on 14 Feb 2018

6 answers

65 views

Telerik RadEditor error while formating big selection

Hello.

If i have a simple table, and i select the table and some other stuff and click BOLD, all element tags get wrapped by a tag, not only text (for instance tfoot, thead etc are all wrapped with . Is there any configuration to this ?

Would apreciate any help.

Best regards.

Editor

answered on 13 Feb 2018

3 answers

770 views

IFrame uses page with radwindow (modal popup)

Hi,

I have 2 web pages

Page A -> contains an image button.
Page B -> contains an IFrame referring to Page A (I do not manage this page)

When I press the image button a modal popup window opens.
Only problem is the window (modal popup) should be opened on top of page B.
It should be centered on page B and everything else on page B should be grayed out.

Is this possible?

Page A:

<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <link rel="stylesheet" type="text/css" href="App_Themes/EriksBlue.css" /> <title>Catalogs</title> <telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" /> </head> <body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <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> </telerik:RadScriptManager> <script type="text/javascript"> //Put your JavaScript code here. function openPopUp(url) { window.radopen(url, "CatalogWindow", window.innerWidth * 0.8, window.innerHeight * 0.8); } </script> <telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableShadow="true" Animation="FlyIn"> <Windows> <telerik:RadWindow RenderMode="Lightweight" VisibleStatusbar="false" VisibleTitlebar="true" ID="CatalogWindow" runat="server" Modal="true" Behaviors="Close"> </telerik:RadWindow> </Windows> </telerik:RadWindowManager> <telerik:RadPanelBar RenderMode="Auto" runat="server" ID="rpbCatalogs" Width="100%"> </telerik:RadPanelBar> </form> </body> </html>

Page B:

<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <iframe src="http://localhost:7688/" style="border:none;" width="600" height="800"> </iframe> </body> </html>

Window

answered on 13 Feb 2018