Interested to Buy Any Domain ? << Click Here >> for more details...
How do you sort the data in datagrid?
- 4 Answers
- 9178 Views
- Choice Solutions, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the uses of Stored Procedure?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
How do you update database through dataset?
Do you use stored procedure in ado.net?
How to check if the Dataset has records ?
What is microsoft ado.net?
What is shadow copy?
What is the default provider in ado.net?
What is microsoft ado?
Explian About DataAdapters
What is two way data binding android?
What is ado.net components?
Why is ADO.NET serialization slower than ADO ?
How can we save all data from dataset?
Which is faster dataset or datareader?
