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

Question

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

Satyapriya Nayak · Answer

Hi Legolas Default.aspx code Sort data in datagrid 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

Satyapriya Nayak · Answer

Hi legolas please visit Our recommended articles section. thanks