I have attempted to add basic sorting to my grid. The grid loads fine, but when I attempt to sort a column the grid is just gray, no data. Here's my code.
| <telerik:RadGrid ID="grdRepl" runat="server" EnableEmbeddedSkins="False" GridLines="None" Skin="WebBlue" AutoGenerateColumns="False" Width="100%" Height="388px" AllowSorting="True" AllowMultiRowSelection="True"> |
| <PagerStyle FirstPageImageUrl="Images/Grid/PagingFirst.gif" LastPageImageUrl="Images/Grid/PagingLast.gif" |
| NextPageImageUrl="Images/Grid/PagingNext.gif" PrevPageImageUrl="Images/Grid/PagingPrev.gif" /> |
| <MasterTableView ClientDataKeyNames="QTY" AllowNaturalSort="False" > |
| <CommandItemSettings AddNewRecordImageUrl="Images/Grid/AddRecord.gif" RefreshImageUrl="Images/Grid/Refresh.gif" /> |
| <RowIndicatorColumn FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn CollapseImageUrl="SingleMinus.gif" ExpandImageUrl="SinglePlus.gif" |
| FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridClientSelectColumn UniqueName="chkSelected" FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"></telerik:GridClientSelectColumn> |
| <telerik:GridBoundColumn DataField="STOR_CDE" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store #" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="STORE_NAME" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column1"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="QTY" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Units" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column2"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="COST" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Cost" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column3"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="RETAIL" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Retail" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column4"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <EditFormSettings> |
| <EditColumn CancelImageUrl="Cancel.gif" EditImageUrl="Edit.gif" FilterImageUrl="Images/Grid/Filter.gif" |
| InsertImageUrl="Update.gif" SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" |
| UpdateImageUrl="Update.gif"> |
| </EditColumn> |
| </EditFormSettings> |
| <PagerStyle FirstPageImageUrl="Images/Grid/PagingFirst.gif" LastPageImageUrl="Images/Grid/PagingLast.gif" |
| NextPageImageUrl="Images/Grid/PagingNext.gif" PrevPageImageUrl="Images/Grid/PagingPrev.gif" /> |
| <GroupByExpressions> |
| <telerik:GridGroupByExpression> |
| <SelectFields> |
| <telerik:GridGroupByField |
| HeaderText="<BR/>                                                                                                                     Units" |
| FieldName="QTY" |
| Aggregate="Sum" FieldAlias="QTY" FormatString="" /> |
| <telerik:GridGroupByField |
| HeaderText="                   Cost" |
| FieldName="COST" |
| Aggregate="Sum" FieldAlias="COST" FormatString="" /> |
| <telerik:GridGroupByField |
| HeaderText="             Retail" |
| FieldName="RETAIL" |
| Aggregate="Sum" FieldAlias="RETAIL" FormatString="" /> |
| </SelectFields> |
| <GroupByFields> |
| <telerik:GridGroupByField |
| FieldName="column1" FieldAlias="column1" FormatString="" HeaderText="" /> |
| </GroupByFields> |
| </telerik:GridGroupByExpression> |
| </GroupByExpressions> |
| </MasterTableView> |
| <ClientSettings> |
| <Scrolling AllowScroll="True" UseStaticHeaders="True" /> |
| <Selecting AllowRowSelect="True" /> |
| <ClientEvents OnRowSelected="ReplRowSelected" OnRowDeselected="ReplRowDelected" /> |
| </ClientSettings> |
| <SelectedItemStyle BackColor="PaleGoldenrod" /> |
| </telerik:RadGrid> |
| Protected Sub grdRepl_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles grdRepl.NeedDataSource |
| Select Case Master.pbOR.SelectedItem.Index |
| Case 0 |
| PopulateReplenishmentGrid(False) |
| End Select |
| End Sub |
| Private Sub PopulateReplenishmentGrid(ByVal Process As Boolean) |
| Dim Dept As String = "" |
| Dim Vend As String = "" |
| Dim Cls As String = "" |
| Dim bll As New BARS.BLL.OrderReview(Environment.Selected) |
| 'Determine which level of tree was selected |
| If Not Master.tvRepl.SelectedNode Is Nothing Then |
| If CurrentNodeRepl <> Master.tvRepl.SelectedNode.ValuePath Or Process Then |
| LastNodeRepl = CurrentNodeRepl |
| CurrentNodeRepl = Master.tvRepl.SelectedNode.ValuePath |
| If LastNodeRepl <> CurrentNodeRepl Or Process Then |
| Dim dt As DataTable = bll.SelectPO(Convert.ToInt32(Master.tvRepl.SelectedNode.Text)) |
| If dt.Rows.Count > 0 Then |
| grdRepl.DataSource = dt |
| Dim Units As Integer = 0 |
| For Each row As DataRow In dt.Rows |
| Units += Convert.ToInt32(row("QTY")) |
| Next |
| hfTotalUnits.Value = Units |
| Else |
| grdRepl.DataSource = Nothing |
| End If |
| 'grdRepl.DataBind() |
| grdRepl.Visible = True |
| hfLastRetrieve.Value = "TREE" |
| End If |
| End If |
| End If |
| End Sub |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| Select Case Master.pbOR.SelectedItem.Index |
| Case 0 |
| PopulateReplenishmentGrid(False) |
| Case 1 |
| PopulateOrderReviewGrid() |
| End Select |
| End Sub |
3 Answers, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 28 Oct 2008, 04:50 AM
Hi Dudeman,
You have not set the SortExpression property. Try setting it for the Grid columns and see whether Sorting is working.
ASPX:
Thanks
Shinu.
You have not set the SortExpression property. Try setting it for the Grid columns and see whether Sorting is working.
ASPX:
| <Columns> |
| <telerik:GridClientSelectColumn UniqueName="chkSelected" FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"></telerik:GridClientSelectColumn> |
| <telerik:GridBoundColumn DataField="STOR_CDE" SortExpression="STOR_CDE" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store #" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="STORE_NAME" SortExpression="STORE_NAME" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column1"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="QTY" SortExpression="QTY" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Units" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column2"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="COST" SortExpression="COST" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Cost" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column3"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="RETAIL" SortExpression="RETAIL" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Retail" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column4"> |
| </telerik:GridBoundColumn> |
| </Columns> |
Thanks
Shinu.
0
Rob
Top achievements
Rank 1
Rank 1
answered on 28 Oct 2008, 01:44 PM
Shinu,
Thank you for your reply.
I have added a sort expression for the first databound column, but still get the same blank, gray grid after attempting to sort. I have a very simple grid in a prototype project that seems to work fine without sort expressions, which leads me to believe that I have done something else wrong with this grid. Here is the updated grid w/ a sort expression:
Thank you for your reply.
I have added a sort expression for the first databound column, but still get the same blank, gray grid after attempting to sort. I have a very simple grid in a prototype project that seems to work fine without sort expressions, which leads me to believe that I have done something else wrong with this grid. Here is the updated grid w/ a sort expression:
| <telerik:RadGrid ID="grdRepl" runat="server" EnableEmbeddedSkins="False" GridLines="None" Skin="WebBlue" AutoGenerateColumns="False" Width="100%" Height="388px" AllowSorting="True" AllowMultiRowSelection="True"> |
| <PagerStyle FirstPageImageUrl="Images/Grid/PagingFirst.gif" LastPageImageUrl="Images/Grid/PagingLast.gif" |
| NextPageImageUrl="Images/Grid/PagingNext.gif" PrevPageImageUrl="Images/Grid/PagingPrev.gif" /> |
| <MasterTableView ClientDataKeyNames="QTY" AllowNaturalSort="False" > |
| <CommandItemSettings AddNewRecordImageUrl="Images/Grid/AddRecord.gif" RefreshImageUrl="Images/Grid/Refresh.gif" /> |
| <RowIndicatorColumn FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn CollapseImageUrl="SingleMinus.gif" ExpandImageUrl="SinglePlus.gif" |
| FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridClientSelectColumn UniqueName="chkSelected" FilterImageUrl="Filter.gif" SortAscImageUrl="SortAsc.gif" SortDescImageUrl="SortDesc.gif"></telerik:GridClientSelectColumn> |
| <telerik:GridBoundColumn DataField="STOR_CDE" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store #" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="STORE_NAME" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Store" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column1"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="QTY" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Units" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column2"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="COST" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Cost" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column3"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="RETAIL" FilterImageUrl="Images/Grid/Filter.gif" HeaderText="Retail" |
| SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" UniqueName="column4"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <EditFormSettings> |
| <EditColumn CancelImageUrl="Cancel.gif" EditImageUrl="Edit.gif" FilterImageUrl="Images/Grid/Filter.gif" |
| InsertImageUrl="Update.gif" SortAscImageUrl="Images/Grid/SortAsc.gif" SortDescImageUrl="Images/Grid/SortDesc.gif" |
| UpdateImageUrl="Update.gif"> |
| </EditColumn> |
| </EditFormSettings> |
| <PagerStyle FirstPageImageUrl="Images/Grid/PagingFirst.gif" LastPageImageUrl="Images/Grid/PagingLast.gif" |
| NextPageImageUrl="Images/Grid/PagingNext.gif" PrevPageImageUrl="Images/Grid/PagingPrev.gif" /> |
| <GroupByExpressions> |
| <telerik:GridGroupByExpression> |
| <SelectFields> |
| <telerik:GridGroupByField |
| HeaderText="<BR/>                                                                                                                     Units" |
| FieldName="QTY" |
| Aggregate="Sum" FieldAlias="QTY" FormatString="" /> |
| <telerik:GridGroupByField |
| HeaderText="                   Cost" |
| FieldName="COST" |
| Aggregate="Sum" FieldAlias="COST" FormatString="" /> |
| <telerik:GridGroupByField |
| HeaderText="             Retail" |
| FieldName="RETAIL" |
| Aggregate="Sum" FieldAlias="RETAIL" FormatString="" /> |
| </SelectFields> |
| <GroupByFields> |
| <telerik:GridGroupByField |
| FieldName="column1" FieldAlias="column1" FormatString="" HeaderText="" /> |
| </GroupByFields> |
| </telerik:GridGroupByExpression> |
| </GroupByExpressions> |
| <SortExpressions> |
| <telerik:GridSortExpression FieldName="STOR_CDE" SortOrder="Ascending" /> |
| </SortExpressions> |
| </MasterTableView> |
| <ClientSettings> |
| <Scrolling AllowScroll="True" UseStaticHeaders="True" /> |
| <Selecting AllowRowSelect="True" /> |
| <ClientEvents OnRowSelected="ReplRowSelected" OnRowDeselected="ReplRowDelected" /> |
| </ClientSettings> |
| <SelectedItemStyle BackColor="PaleGoldenrod" /> |
| </telerik:RadGrid> |
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 29 Oct 2008, 07:49 AM
Hi Dudeman,
In your aspx you have not set the NeedDataSource event handler. I am not sure whether you have set the event handler in the code behind. Automatic sorting will work only with AdvanceDataBinding techniques.
Shinu
In your aspx you have not set the NeedDataSource event handler. I am not sure whether you have set the event handler in the code behind. Automatic sorting will work only with AdvanceDataBinding techniques.
Shinu