datarow.find

[sethindeed]

From what I have read so far, it seems that we can only perform search with datarow using the primary key of a table.
How can I locate the pointer to the specific column I want to seek ?

thx


( Or suppose I proceed with a query that returns only one row, is there a possibility to set the datarow to the active / current row ? )

 

[wyrd]

You can use DataRow.ItemArray property to retrieve an array of values that are in the DataRow, or just DataRow["column"] or DataRow[#] to specify the column you want.

Have a look at the object browser.. go under the system.data assembly -> System.Data namespace -> DataRow class. It will tell you everything the DataRow is capable of doing.