Can you use DataTable.Contains(object key) if your datatable's primary key is two columns?

Question

if so how?

Answer 1

'Contains' does not seem to be a member of the DataRow class (maybe this is a typed data set?)

In any case, you can always use (DataTable.Select(....).Length > 0) as a substitute

Answer 2

To select by a primary key you should use one of:

• DataTable.Rows.Find(Object) in case your PK is one column
• DataTable.Rows.Find(Object[]) in case you have more then 1 column as a primary key

In case of a typed DataSet, the method MyDataTable.Rows.Find(...) will be generated for you with the proper signature. Basically it is a method on DataRowCollection class

Answer 3

I assume you're referring to the DataRowCollection.Contains method ? There is an overload that takes an array of objects, you should use this one