How do you sort the data in datagrid?
- 4 Answers
- 8597 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
Explain the different row versions available in table?
What is the maximum pool size in ado.net connection string?
What is data view and variable view?
What is isolation?
Define Execute Reader?
What is ado and dao?
Does sqlclient and oledb class share the same functionality?
What is connection pooling and what is the maximum pool size in ado.net connection string?
Explain what are the steps to connect to a database?
Which name space is used to get assembly details?
What is ado recordset?
What is difference between connected and disconnected architecture in ado.net?
What are the disadvantages of using datalist?
What are the Features and disadvantages of dataset
Can datareader hold data from multiple tables?
