The DataView
Dim
dv As DataView
dv =
objDs.Tables("Can").DefaultView()
'You can
sort by any field....
dv.Sort = "ssn"
'... Or
you can filter the view down to 1 field...
dv.RowFilter = "ssn = '-00000014'"
DataGrid1.DataSource = dv
DataGrid1.DataBind()
'This
will return just the amount of rows in the DataView...
txtCount.Text = objDs.Tables("Can").DefaultView.Count
'This
will return all the rows in the table...
txtTotal.Text = objDs.Tables("Can").Rows.Count
How To
Reference A Field In A DataView…
Dim dv As DataView = objDs.Tables("Can").DefaultView
dv.RowFilter = "Lname =
'SisCo'"
MsgBox(dv(0).Item("LName"))
'How to loop through
records in a DataView...
dv =
objDs.Tables("Check").DefaultView
dv.RowFilter = "SeminarLocation='
Dim J As Integer
For J =
0 To dv.Count - 1
'Do
Something...
Next J