Answer Posted / bhuvana

We can use DataTable.Select method to fetch rows. see the
following example:
In this
customerTable.Select( strExpr, strSort,
DataViewRowState.Added ) fetches the records which is
greater then 5.

Private Sub GetRowsByFilter()

Dim customerTable As DataTable
customerTable = new DataTable( "Customers" )

' Add columns
customerTable.Columns.Add( "id", GetType(Integer) )
customerTable.Columns.Add( "name", GetType(String) )

' Set PrimaryKey
customerTable.Columns("id").Unique = true
customerTable.PrimaryKey = new DataColumn() {
customerTable.Columns("id") }

' add ten rows
Dim id As Integer
For id = 1 To 10
customerTable.Rows.Add( _
new object() { id, string.Format("customer{0}",
id) } )
Next id
customerTable.AcceptChanges()

' add another ten rows
For id = 11 To 20
customerTable.Rows.Add( _
new object() { id, string.Format("customer{0}",
id) } )
Next id

Dim strExpr As String
Dim strSort As String

strExpr = "id > 5"
' Sort descending by CompanyName column.
strSort = "name DESC"
' Use the Select method to find all rows matching the
filter.
Dim foundRows As DataRow() = _
customerTable.Select( strExpr, strSort,
DataViewRowState.Added )

PrintRows( foundRows, "filtered rows")

foundRows = customerTable.Select()
PrintRows( foundRows, "all rows")
End Sub

Private Sub PrintRows( rows() As DataRow, label As String)
Console.WriteLine( "\n{0}", label )
If rows.Length <= 0 Then
Console.WriteLine( "no rows found" )
Exit Sub
End If
Dim r As DataRow
Dim c As DataColumn
For Each r In rows
For Each c In r.Table.Columns
Console.Write( "\t {0}", r(c) )
Next c
Console.WriteLine()
Next r
End Sub

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

1083

---

What are the different layers of ado.net?

1123

---

Explain sqlconnection object?

1066

---

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

1021

---

What is the difference between statement and preparedstatement interface?

1053

---

How do you update a dataset in ado.net?

1064

---

Explain the two fundamental objects in ado.net?

1069

---

What are the advantages of ado.net?

958

---

How to retrieve the user id which is provided while windows authentication?

1147

---

How can you add or remove rows from the datatable object of dataset?

1073

---

What is openrowset?

1035

---

What is data reader in ado.net?

1051

---

Why do we serialize data?

1009

---

What is difference between datatable and dataset?

1128

---

Which provider is used to connect ms access, oracle, etc…?

1056

---