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

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

Answers (2)