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

What does executereader return?

896

---

Which object holds only data and does not interact with data source?

908

---

What is an orm, and why would you use one instead of plain old ado.net?

995

---

What is the difference between linq and ado.net?

941

---

What are the namespaces used in ado.net for data access?

922

---

What are the important features of ado.net 2.0?

1017

---

What is dataset object? Explain the various objects in dataset.

979

---

What is a non query?

885

---

Explain the different row versions available in table?

974

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

972

---

How can we load multiple tables in to dataset?

1029

---

How to store data in memory?

888

---

What is ado and rdo?

860

---

Does sqlclient and oledb class share the same functionality?

875

---

What is Serialization in .NET? what are the types of Serialization?

1023

---