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 ole word?

951

---

What is difference between sqldatareader and sqldataadapter?

931

---

Define bubbled event?

933

---

What are the different execute methods of Ado.Net?

1027

---

Explain how to find the given query is optimised one or not?

1034

---

What is the difference in an abstract class and an interface?

1009

---

Explain the difference between data reader and data set?

928

---

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1032

---

What are two types of transaction supported by ado.net?

996

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2142

---

Do we use stored procedure in ADO.Net?

992

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1023

---

What are the different methods by which we can populate a dataset?

1237

---

What is execute scalar in ado.net?

965

---

What are the different ado.net namespaces are available in .net?

1010

---