In my previous post i explained, how to Search string pattern using sql on SQL i had explained how to Add Image in between Rows of a GridView using C#.
Now in this article i will explain one of the useful feature i.e Gridview Sorting.
you need to set the AllowSorting property as a True. and SortExpression Property of columns to the specific field name from the database.
Lets look at the below sample gridview code.
you need to set the AllowSorting property as a True. and SortExpression Property of columns to the specific field name from the database.
Lets look at the below sample gridview code.
<asp:GridView ID="gvDetails" runat="server" onsorting="gvDetails_Sorting" AllowSorting="True">
<Columns>
<asp:TemplateField HeaderText="Your Name" SortExpression="FirstName">
<ItemTemplate>
<%#Eval("YourName")%>'/>
</ItemTemplate>
</asp:TemplateField>
</asp:GridView>
Now for sorting you need to create one public property which store the value of direction in the viewstate and base on that select query get fired.
public GetSortDir direction
{
get
{
if (ViewState["SortingDir"] == null)
{
ViewState["SortingDir"] = GetSortDir.Ascending;
}
return (GetSortDir)ViewState["SortingDir"];
}
set
{
ViewState["SortingDir"] = value;
}
}
Now check the gridview directon and base on viewstate it will get set the new direction.
protected void gvDetails_Sorting(object sender, GridViewSortEventArgs e)
{
string sortDirection = string.Empty;
if (direction == sortDirection.Ascending)
{
direction = sortDirection.Descending;
sortDirection = "Desc";
}
else
{
direction = sortDirection.Ascending;
sortDirection = "Asc";
}
DataView sortedView = new DataView(BindGridView());
sortedView.Sort = e.SortExpression + " " + sortDirection;
gvDetails.DataSource = sortedView;
gvDetails.DataBind();
}
Here BindGridView() is the function which returns the datatable & it contain the query result.
that's it now check the gridview and click on the header and see the sorting effects get added in your gridview.
You have shared interesting post about c# programming languages, keep it update. i will read your topic daily. Thanks a lot for sharing valuable post.
ReplyDeleteThanks!!
ReplyDelete