untyped datatable

[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

 

[Teemu Keiski]

Hi,

DataTable.Rows.Find method is probably the closest, if you mean searching
with primary key value?

 

[Guest]

how do i create or designate the primary key field in my untyped datatable?

DataTable dt;
dt=da.GetDataTable()
dt.Find ???

 

[Teemu Keiski]

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

 

[Guest]

thank you very much for the help, it is greatly appreciated. rod.