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 0.
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 0.
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
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
DataRow[] dr = new DataRow[10];
for(int i = 10 to 19)
dr[i] = DataSet1.Tables[<TableIndex>].Rows[i];
DataRow array dr contains Records between 10 and 20.
DataSet ds = new DataSet();
ds.Load(cmd.ExecuteReader(),
LoadOption.OverwriteChanges, "sample");
DataRow[] dr = ds.Tables[0].Select("id>1 and id<10");
for (int i = 0; i < dr.Length; i++)
{
Response.Write(dr[i][0].ToString()+"<br>");
}
We have the option of the fetching the starting record and
the maximum record options.
_dataadapter.Fill(_dset,"Test",11,10);
It will retrieve the record from 11 to next 10 records.
i have two textboxes one for user name and another for
password . i have a table name compare(which contains
name,passwod etc.,)my doubt is how compare username
textbox with name column and how compare password textbox
with passwod column. i want the code