I am trying to sort a column 'mem_id 'in already generated gridview. I dont get the result. Hereunder are my codes:
<asp:GridView ID="GridView2" runat="server" HorizontalAlign="Center" AutoGenerateColumns="False" allowpaging="True" AllowSorting="True"
OnSorting="GridView2_Sorting" PageSize="12" onpageindexchanging="GridView2_PageIndexChanging" onselectedindexchanged="GridView2_SelectedIndexChanged"
style="border-color: #808000; font-size:small; top: 176px; left: 27px; position: absolute; height: 75px; width:1350px" >
<RowStyle HorizontalAlign="Center" />
<Columns >
<asp:BoundField DataField="mem_id" HeaderText="Mem_ID" sortexpression="Mem_id"/>
<asp:BoundField DataField="mem_name" HeaderText="Mem Name"/>
<asp:BoundField DataField="mobile" HeaderText="Cell No:"/>
code behind:
protected void GridView2_Sorting(object sender, GridViewSortEventArgs e)
{
GridView Gridview2 = (GridView)sender;
SqlDataSource ds = (SqlDataSource)Gridview2.DataSource;
ds.SelectCommand = ds.SelectCommand + " order by "
+ e.SortExpression;
Gridview2.DataSource = ds;
Gridview2.DataBind();
Can anyone guide me?