Sort and export datagridview

Question

User-960441985 posted

Hi,

I need to sort using header and also export to MS Excel. 

Dim sQuery As String = GetSearchQuery

' My query is select SAMPLE_NO_1, SAMPLE_NO_2 , SAMPLE_NO_3 , SAMPLE_NO_4, SAMPLE_NO_5 from Sample_Table (it has 50 fields)

Dim cmd As New OracleCommand
cmd.Connection = OraConn
cmd.CommandText = sQuery
cmd.CommandType = CommandType.Text

cmd.ExecuteNonQuery()

'Create and fill data adaptor
Dim da As OracleDataAdapter
da = New OracleDataAdapter(cmd)

'Create and fill data set
Dim dt As New DataTable
da.Fill(dt)

dgvSearchResults.Visible = True
dgvSearchResults.DataSource = dt
dgvSearchResults.DataBind()
OraConn.Close()
OraConn.Dispose()

Thanks a lot.

Answer 1

User36583972 posted

Hi Ramjee,

I need to sort using header

If you are using a standard ASP.NET System.Web.UI.WebControls.GridView. The GridView control provides built-in sorting without coding, you can simply "Enable Sorting" by setting "AllowSorting" to true. You can further customize the sort function of the GridView control by setting the custom SortExpression attribute values for the column and using the Sorting and Sorted events.

Paging and Sorting in ASP.Net GridView example
https://www.aspsnippets.com/Articles/Paging-and-Sorting-in-ASPNet-GridView-example.aspx

export to MS Excel. 

Please refer the following sample.

Export GridView to Excel in ASP.Net with Formatting using C# and VB.Net:
https://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx

Best Regards,

Yong Lu