[Solved] Rad Grid Sorting

[sriki]

Hi,
    I am using RadGrid control for grouping but i dont want the sorting to be done.I want to display as it is in collection i am getting the data but unfortunately it is getting sorted on "PacName". I dont know where to change the code as i am psating the code here. So please can you suggest me how to remove sorting for this code as i want only grouping with the "PacName" not the sorting with the "PacName".Just i want to display the data as it is in collection which i am binding to grid.Waiting for your reply

ASPX  Page:
-------------------------------------------------------------------------------------------------------<radg:radgrid id="gridManagerItems" runat="server" CellSpacing="0" GroupingEnabled="True" ShowGroupPanel="False" CellPadding="3" AutoGenerateColumns="False" ToolTip="Reconciliation Statement List" Skin="None">

<MasterTableView AllowCustomPaging="False" AllowSorting="True" GroupsDefaultExpanded="False" AllowMultiColumnSorting="True" AllowPaging="False" GridLines="Both">

<HeaderStyle CssClass="Table_Header_Row_Blue"></HeaderStyle>

<GroupHeaderItemStyle CssClass="PACGroupRow ReceiptsGroupHeader"></GroupHeaderItemStyle>

<Columns>

<radg:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="">

<ItemStyle HorizontalAlign="Center"></ItemStyle>

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="1%"></HeaderStyle>

<ItemTemplate>

<asp:ImageButton id="imgEditbtn" CommandName="EditStatementItem" ToolTip="Edit" AlternateText="Edit"

Runat="server" ImageUrl="/_WebControlsResources/Images/edit.gif"></asp:ImageButton>

</ItemTemplate>

</radg:GridTemplateColumn>

<radg:GridTemplateColumn UniqueName="TemplateColumn">

<ItemStyle HorizontalAlign="Center"></ItemStyle>

<ItemTemplate>

<asp:ImageButton id="imgDeletebtn" CommandName="DeleteStatementItem" ToolTip="Delete" AlternateText="Delete"

Runat="server" ImageUrl="/_WebControlsResources/Images/delete.gif"></asp:ImageButton>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="1%"></HeaderStyle>

</radg:GridTemplateColumn>

<radg:GridBoundColumn UniqueName="startDate" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Begin Date" DataField="startDate">

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="70px"></HeaderStyle>

<ItemStyle HorizontalAlign="Left" Wrap="false"></ItemStyle>

</radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="endDate" DataFormatString="{0:MM/dd/yyyy}" HeaderText="End Date" DataField="endDate">

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="70px"></HeaderStyle>

<ItemStyle HorizontalAlign="Left" Wrap="false"></ItemStyle>

</radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="startingBalance" DataFormatString="{0:$#,###.00}" HeaderText="Starting Balance"

DataField="StartingBalance">

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="100px"></HeaderStyle>

<ItemStyle HorizontalAlign="Right" Wrap="false"></ItemStyle>

</radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="EndingBalance" DataFormatString="{0:$#,###.00}" HeaderText="Ending Balance"

DataField="EndingBalance">

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="100px"></HeaderStyle>

<ItemStyle HorizontalAlign="Right" Wrap="false"></ItemStyle>

</radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="Status" HeaderText="Status" DataField="Status">

<HeaderStyle HorizontalAlign="Left" Wrap="false" Width="1%"></HeaderStyle>

<ItemStyle HorizontalAlign="Left"></ItemStyle>

</radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="ReconciliationStatementID" HeaderText="ReconciliationStatementID" Visible="False" DataField="ReconciliationStatementID"></radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="BankAccountID" HeaderText="Bank AccountID" Visible="False" DataField="BankAccountID"></radg:GridBoundColumn>

<radg:GridBoundColumn UniqueName="BankAccountName" HeaderText="Bank Account Name" Visible="False" DataField="BankAccountName"></radg:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn"></EditColumn>

</EditFormSettings>

<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">

<HeaderStyle Wrap="False" HorizontalAlign="Left" Width="19px" VerticalAlign="Middle" BackColor="#D3D3F1"></HeaderStyle>

</ExpandCollapseColumn>

</MasterTableView>

<GroupPanel Visible="False"></GroupPanel>

<ClientSettings AllowGroupExpandCollapse="True" ReorderColumnsOnClient="False" AllowDragToGroup="False" AllowColumnsReorder="False">

</ClientSettings>
</radg:radgrid>

ASPX.CS File :
----------------------------------------------------------------------------

This is how i am grouping : -

private

void GroupAndSortFields()

{

gridManagerItems.MasterTableView.AllowSorting =

false;

gridManagerItems.AllowSorting =

false;

gridManagerItems.MasterTableView.SortExpressions.AllowMultiColumnSorting =

true;

//************** Group By Logic *******************

GridGroupByExpression expression = new GridGroupByExpression();

GridGroupByField gridGroupByField = new GridGroupByField();

//Add select fields (beforne the "Group By" clause)

//ADD PAC Name grouping

expression =

new GridGroupByExpression();

gridGroupByField =

new GridGroupByField();

gridGroupByField.FieldName =

"PACName";

gridGroupByField.HeaderText =

"";

gridGroupByField.HeaderValueSeparator =

"";

expression.SelectFields.Add( gridGroupByField );

expression.GroupByFields.Add( gridGroupByField );

gridGroupByField.SortOrder =

GridSortOrder.None;

gridManagerItems.MasterTableView.GroupByExpressions.Add( expression );

//ADD Bank Account grouping

expression =

new GridGroupByExpression();

gridGroupByField =

new GridGroupByField();

gridGroupByField.FieldName =

"BankAccountID";

gridGroupByField.HeaderText =

"";

gridGroupByField.HeaderValueSeparator =

"";

gridGroupByField.SortOrder =

GridSortOrder.None;

expression.GroupByFields.Add( gridGroupByField );

gridGroupByField =

new GridGroupByField();

gridGroupByField.FieldName =

"BankAccountName";

gridGroupByField.HeaderText =

"";

gridGroupByField.HeaderValueSeparator =

"";

gridGroupByField.SortOrder =

GridSortOrder.None;

expression.SelectFields.Add( gridGroupByField );

gridManagerItems.MasterTableView.GroupByExpressions.Add( expression );

//ADD Year grouping

expression =

new GridGroupByExpression();

gridGroupByField =

new GridGroupByField();

gridGroupByField.FieldName =

"Year";

gridGroupByField.HeaderText =

"Year";

gridGroupByField.HeaderValueSeparator =

": ";

gridGroupByField.SortOrder =

GridSortOrder.None;

expression.SelectFields.Add( gridGroupByField );

expression.GroupByFields.Add( gridGroupByField );

gridManagerItems.MasterTableView.GroupByExpressions.Add( expression );

}

The above method I am calling in Page_Load()

Regards,
Srikanth.

[Princy]

Hi Sriki,

Try setting the Sorting Property to false in the aspx.

ASPX:

<MasterTableView AllowCustomPaging="False" AllowSorting="False" GroupsDefaultExpanded="False" AllowMultiColumnSorting="False" AllowPaging="False" GridLines="Both">

Princy.

[sriki]

Hi Prince,

            I tried the way you said but its not working. By default the result set is sorting by PACName.

Regards,
Srikanth.

[Shinu]

Hi,

How are you binding the Grid? Try binding the Grid in the NeedDataSource event. Grid features like Sorting/Grouping etc work with AdvanceDataBinding techniques. Go through the following demo link to get details about AdvanceDataBinding technique.
Advanced data-binding

Shinu.