If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?

If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Question Posted / guest

14 Answers
35379 Views
Ksb, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / 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

Is This Answer Correct ?

2 Yes

3 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / krishnareddy

USE EXECUTEPAGEREADER()

Is This Answer Correct ?

1 Yes

2 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / ramesh

Dataset consists of DataTable collection which consists of
DataRows. Create Dataset object, then create DataRow object

Dim objRow as New DataRow

objRow(9) to objTow(19) woud give the rows between 10 and
20, as first row is stored with index

Is This Answer Correct ?

4 Yes

6 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / anu

objRow(9) to objTow(19)

mentioned above would return the column index and would not
return the loop.

Corrrect me if I am wrong

Is This Answer Correct ?

3 Yes

5 No