Articles → ASP .NET GRIDVIEW → Sorting In Asp.Net Gridview

Sorting In Asp.Net Gridview

In this article, I will explain how to add sorting functionality in asp.net gridview. First of all create a table. See the following image for data.

Picture showing the sample database table with data

Click to Enlarge

Bind Gridview With Data

For binding the gridview, we will use SQLDataSource. See the following code

<asp:GridView ID="gvTest" runat="server" DataSourceID="dsTest" ></asp:GridView>
<asp:SqlDataSource ConnectionString="conn_string" ID="dsTest" 
            SelectCommand="Select * from Member" runat="server"  />

Add Property For Sorting

Add AllowSorting property in gridview and set its value to true. So the preceding code will be changed to

<asp:GridView ID=”gvTest” runat=”server” DataSourceID=”dsTest" AllowSorting="true"></asp:GridView>
<asp:SqlDataSource ConnectionString="conn_string" ID="dsTest" 
            SelectCommand="Select * from Member" runat="server"  />

Output

Now run the application.

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, May 29, 2015

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**