Hi,

i have a dataset (ds), with a table (T1).

T1 has a number of columns.

2 of which are Id and Code.

I get passed a Code.

How do i search T1 Code column and return the corresponding Id to a variable?

similar to a sql search with a where clause.

(Select T1.ID from T1 where T1.Code = 'code')

Thanks.

Hi,

You can use the Select() method of the Table class to select rows from the table that match a certain criteria, it's very similar to a select statement. The method returns an array of DataRows that you can iterate over. Just like a select statement you need to use [ ] around column names and ' ' around strings. Here's a basic example...

Dim rows() as DataRow

rows = myTable.Select("[Code] = '" & myCode & "'")

For each row as DataRow in rows

Hi,

You can use the Select() method of the Table class to select rows from the table that match a certain criteria, it's very similar to a select statement. The method returns an array of DataRows that you can iterate over. Just like a select statement you need to use [ ] around column names and ' ' around strings. Here's a basic example...

Dim rows() as DataRow

rows = myTable.Select("[Code] = '" & myCode & "'")

For each row as DataRow in rows