untyped datatable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
if i have an untyped datatable in my code how can i make it where when i
reference the datatable variable i can say dt.FindByFieldKeyID(value as
integer)?

thanks,
rodchar
 
Hi,

DataTable.Rows.Find method is probably the closest, if you mean searching
with primary key value?
 
how do i create or designate the primary key field in my untyped datatable?

DataTable dt;
dt=da.GetDataTable()
dt.Find ???
 
You need to first specify the PK in the datatable.

'This way to say that first column is the PK
dt.PrimaryKey = New DataColumn() {dt.Columns(0)}

'This way to say that more than one columns together are the PK
dt.PrimaryKey = New DataColumn() {dt.Columns(0), dt.Columns(1)}

'You can also use colun name
dt.PrimaryKey = New DataColumn() {dt.Columns("IDOne"),
dt.Columns("IDTwo")}

Then you can look for a specific row with a PK value

Dim row As DataRow = dt.Rows.Find(15)

If Not row Is Nothing Then
Dim thevalue As String = row("OtherColumn").ToString()
End If
 
Back
Top