How do you sort the data in datagrid?
Answers were Sorted based on User's Feedback
Answer / murty
By setting "allow sorting" property of the datagrid to
true we can sort the records in the data grid
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / shiva
Protected Sub Sorting(ByVal sender As Object, ByVal e As
GridViewSortEventArgs)
Dim DESCENDING As String = "DESC"
Dim ASCENDING As String = "ASC"
Dim sortExpression As String = e.SortExpression
If GridViewSortDirection = SortDirection.Ascending
Then
GridViewSortDirection = SortDirection.Descending
SortGridView(sortExpression, DESCENDING)
Else
GridViewSortDirection = SortDirection.Ascending
SortGridView(sortExpression, ASCENDING)
End If
End Sub
(Call this onsorting in datagrdi)
2)
Public Property GridViewSortDirection() As SortDirection
Get
If ViewState("sortDirection") Is Nothing Then
ViewState("sortDirection") =
SortDirection.Ascending
End If
Return CType(ViewState("sortDirection"),
SortDirection)
End Get
Set(ByVal value As SortDirection)
ViewState("sortDirection") = value
End Set
End Property
3) Private Sub SortGridView(ByVal sortExpression As String,
ByVal direction As String)
Try
Dim dt As DataTable = BindData().Tables(0)
Dim dv As New DataView(dt)
dv.Sort = sortExpression + " " + direction
gdvCamp.DataSource = dv
gdvCamp.PageIndex = 0
gdvCamp.DataBind()
Catch ex As Exception
Response.Write(ex.Message)
End Try
End Sub 'SortGridView
Bing the data like fallows
Private Function BindData() As DataSet
Binding Goes here which should returns dataset to above
function
End FUnction
Is This Answer Correct ? | 1 Yes | 0 No |
datagrid has a property for sorting and paging
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sunil
In a simple method,
DataSet ds = new DataSet();
// you must populate the dataset
DataTable dt = ds.tables[0];
DataView dv = new DataView(dt);
dv.Sort = dt.Columns[0];
// This will sort first column in ascending
dv.Sort = dt.Columns[0] + " DESC";
// This will sort first column in descending
Is This Answer Correct ? | 1 Yes | 3 No |
What is the current version of entity framework?
Explain advantages of ado.net?
How to get oledb connection?
Difference between function and trigger?
What is data access pattern?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is linq and entity framework?
Command objects uses, purposes and their methods.
What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?
How to identify the updated rows in a dataset?
What is the difference between sqlcommand and sqldataadapter?
Difference between DataReader and DataAdapter / DataSet and DataAdapter?