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.

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