How to sort record in GridView with header in ASP.NET

Hi Legolas,



Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>





   
   


   

   

 
   
           
           
   
   
   

   
   

   

Default.aspx.vb code

Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim sqlda As SqlDataAdapter
    Dim com As SqlCommand
    Dim ds As DataSet
    Dim str As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            bindgrid("sname")
        End If
    End Sub
    Sub bindgrid(ByVal s As String)

        Try
            con.Open()
            str = "select * from student order by " & s
            com = New SqlCommand(str, con)
            Dim reader As SqlDataReader = com.ExecuteReader
            DataGrid1.DataSource = reader
            DataGrid1.DataBind()
            con.Close()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

    End Sub

    Protected Sub DataGrid1_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles DataGrid1.SortCommand
        bindgrid(e.SortExpression)
    End Sub
End Class




Thanks
If this post helps you mark it as answer