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 is full form of ado?

1059

---

Describe the command object and its method.

996

---

Is it possible to edit data in Repeater control?

955

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1064

---

What is ado.net connection?

956

---

What is the difference between Datareader and Dataset?

1079

---

What is method to get XML and schema from Dataset? getXML() and get Schema ()

967

---

How would you connect to database using .NET?

1029

---

How would you connect to a database by using .NET?

935

---

Which object needs to be closed?

2256

---

What is ado and dao?

956

---

What is the default Timeout for SqlCommand.CommandTimeout property?

1008

---

Describe ado.net object model in detail.

990

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

966

---

Explain how to create dynamic gridview?

969

---