<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
DataSourceID="sqlCategories" GridLines="None">
<
MasterTableView DataKeyNames="Main_Category_ID,Sub_Category_ID"
DataSourceID="sqlCategories">
<
RowIndicatorColumn>
<
HeaderStyle Width="20px"></HeaderStyle>
</
RowIndicatorColumn>
<
ExpandCollapseColumn>
<
HeaderStyle Width="20px"></HeaderStyle>
</
ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="Main_Category"
SortExpression="Main_Category" UniqueName="Main_Category" Visible="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category" HeaderText="Sub_Category"
SortExpression="Sub_Category" UniqueName="Sub_Category">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category_Desc"
HeaderText="Sub_Category_Desc" SortExpression="Sub_Category_Desc"
UniqueName="Sub_Category_Desc">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Main_Category_ID" DataType="System.Int32"
HeaderText="Main_Category_ID" ReadOnly="True" SortExpression="Main_Category_ID"
UniqueName="Main_Category_ID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category_ID" DataType="System.Int32"
HeaderText="Sub_Category_ID" ReadOnly="True" SortExpression="Sub_Category_ID"
UniqueName="Sub_Category_ID">
</telerik:GridBoundColumn>
</Columns>
<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldAlias="Main_Category" FieldName="Main_Category" FormatString="{0}"></telerik:GridGroupByField>
</SelectFields>
<GroupByFields>
<telerik:GridGroupByField FieldName="Main_Category" SortOrder="Descending"></telerik:GridGroupByField>
</GroupByFields>
</telerik:GridGroupByExpression>
</GroupByExpressions>
</
MasterTableView>
</telerik:RadGrid>