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 |