My grid displays fine with all the valid data but once I click on one of the columns to sort, it crashes with the following call stack
I have double checked SortExpression and DataField and they are same (pl. see below). I do have bunch of nulls for data, but it seems to handle them in displaying. Any help would be greatly appreciated. Thanks
My aspx portion is here
<telerik:RadGrid ID="ExcelGrid" AutoGenerateColumns="false" EnableViewState="true"
Skin="Office2007"
AllowSorting="True"
AllowMultiRowSelection="false" runat="server" GridLines="None"
OnItemDataBound="ExcelGrid_ItemDataBound"
onneeddatasource="ExcelGrid_NeedDataSource">
<MasterTableView Width="100%" BorderWidth="0" TableLayout="Auto" DataKeyNames="FILE_NAME">
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Row#">
<ItemStyle HorizontalAlign="left"/>
<ItemTemplate>
<asp:Label ID="numberLabel" runat="server"/>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="FILE_NAME" HeaderText="File Name"
SortExpression="FILE_NAME" UniqueName="FILE_NAME">
<ItemStyle HorizontalAlign="left" Width="35" />
<ItemTemplate>
<a href='download.aspx?docID=<%# DataBinder.Eval(Container.DataItem, "FILE_NAME").ToString() %>'>
<%# DataBinder.Eval(Container.DataItem, "FILE_NAME").ToString()%></a>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="Agreemt_Date" HeaderText="Agreement Date" DataFormatString="{0:dd/MM/yyyy}"
SortExpression="Agreemt_Date" UniqueName="Agreemt_Date">
<ItemStyle HorizontalAlign="left" Width="25" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Orig_Agmt_Type" HeaderText="Original Agreement Type"
SortExpression="Orig_Agmt_Type" UniqueName="Orig_Agmt_Type">
<ItemStyle HorizontalAlign="left" Width="35" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Mod_Agreemt_Type" HeaderText="Model Agreement Type"
SortExpression="Mod_Agreemt_Type" UniqueName="Mod_Agreemt_Type">
<ItemStyle HorizontalAlign="left" Width="35" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Parties" HeaderText="Parties"
SortExpression="Parties" UniqueName="Parties">
<ItemStyle HorizontalAlign="left" Width="50" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Basin" HeaderText="Basin"
SortExpression="Basin" UniqueName="Basin">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Municipality" HeaderText="Municipality"
SortExpression="Municipality" UniqueName="Municipality">
<ItemStyle HorizontalAlign="left" Width="75" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sewershed_Area" HeaderText="Sewershed / Area"
SortExpression="Sewershed_Area" UniqueName="Sewershed_Area">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Source" HeaderText="Source"
SortExpression="Source" UniqueName="Source">
<ItemStyle HorizontalAlign="left" Width="122" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Status" HeaderText="Status"
SortExpression="Status" UniqueName="Status">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Notes" HeaderText="Notes"
SortExpression="Notes" UniqueName="Notes">
<ItemStyle HorizontalAlign="left" Width="50" />
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
</telerik:RadGrid>
I have double checked SortExpression and DataField and they are same (pl. see below). I do have bunch of nulls for data, but it seems to handle them in displaying. Any help would be greatly appreciated. Thanks
[IndexOutOfRangeException: Cannot find column FILE_NAME.] System.Data.DataTable.ParseSortString(String sortString) +4826462 System.Data.DataView.CheckSort(String sort) +32 System.Data.DataView.set_Sort(String value) +128 Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation() +4873 Telerik.Web.UI.GridEnumerableFromDataView.TransformEnumerable() +41 Telerik.Web.UI.GridTableView.GetEnumerator(Boolean useDataSource, GridEnumerableBase resolvedDataSource, ArrayList dataKeysArray) +171 Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +356 Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +713 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() +28 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 Telerik.Web.UI.GridTableView.DataBind() +368 Telerik.Web.UI.GridSortCommandEventArgs.ExecuteCommand(Object source) +326 Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +191 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +61 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +165 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 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
My aspx portion is here
<telerik:RadGrid ID="ExcelGrid" AutoGenerateColumns="false" EnableViewState="true"
Skin="Office2007"
AllowSorting="True"
AllowMultiRowSelection="false" runat="server" GridLines="None"
OnItemDataBound="ExcelGrid_ItemDataBound"
onneeddatasource="ExcelGrid_NeedDataSource">
<MasterTableView Width="100%" BorderWidth="0" TableLayout="Auto" DataKeyNames="FILE_NAME">
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Row#">
<ItemStyle HorizontalAlign="left"/>
<ItemTemplate>
<asp:Label ID="numberLabel" runat="server"/>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="FILE_NAME" HeaderText="File Name"
SortExpression="FILE_NAME" UniqueName="FILE_NAME">
<ItemStyle HorizontalAlign="left" Width="35" />
<ItemTemplate>
<a href='download.aspx?docID=<%# DataBinder.Eval(Container.DataItem, "FILE_NAME").ToString() %>'>
<%# DataBinder.Eval(Container.DataItem, "FILE_NAME").ToString()%></a>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="Agreemt_Date" HeaderText="Agreement Date" DataFormatString="{0:dd/MM/yyyy}"
SortExpression="Agreemt_Date" UniqueName="Agreemt_Date">
<ItemStyle HorizontalAlign="left" Width="25" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Orig_Agmt_Type" HeaderText="Original Agreement Type"
SortExpression="Orig_Agmt_Type" UniqueName="Orig_Agmt_Type">
<ItemStyle HorizontalAlign="left" Width="35" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Mod_Agreemt_Type" HeaderText="Model Agreement Type"
SortExpression="Mod_Agreemt_Type" UniqueName="Mod_Agreemt_Type">
<ItemStyle HorizontalAlign="left" Width="35" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Parties" HeaderText="Parties"
SortExpression="Parties" UniqueName="Parties">
<ItemStyle HorizontalAlign="left" Width="50" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Basin" HeaderText="Basin"
SortExpression="Basin" UniqueName="Basin">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Municipality" HeaderText="Municipality"
SortExpression="Municipality" UniqueName="Municipality">
<ItemStyle HorizontalAlign="left" Width="75" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sewershed_Area" HeaderText="Sewershed / Area"
SortExpression="Sewershed_Area" UniqueName="Sewershed_Area">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Source" HeaderText="Source"
SortExpression="Source" UniqueName="Source">
<ItemStyle HorizontalAlign="left" Width="122" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Status" HeaderText="Status"
SortExpression="Status" UniqueName="Status">
<ItemStyle HorizontalAlign="left" Width="30" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Notes" HeaderText="Notes"
SortExpression="Notes" UniqueName="Notes">
<ItemStyle HorizontalAlign="left" Width="50" />
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
</telerik:RadGrid>