Interested to Buy Any Domain ? << Click Here >> for more details...
How do you sort the data in datagrid?
- 4 Answers
- 9444 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
Does dapper use ado.net?
What are the benefits of using ado.net?
Is it possible to edit data in Repeater control?
Explain the various objects in dataset.
What is the difference between data grid and data repeater?
Explain why edit is not possible in repeater?
How do you connect to sql server database without using sqlclient?
Explain ado.net features?
How to store data in memory?
Why is it important to close an ado.net application?
What are the drawbacks of using ado.net?
What is adodb dll?
What are the several execute methods of ado.net?
How to read data with the sqldatareader ?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
