C# DataSet Index

Question

Hello,

I need to find records in a dataset that have certain values from more than 1 column. I cannot use the Find or Contains method since they require a primary key and my search values can be non-unique. Do DataSets have indexes (Much like a SQL table) that I can use to speed up my search? Right now I'm looping through the dataSet doing compares for each column but this method is very very slow (my data set has 600k rows).

Thanks

Answer 1

You can use the DataTable Select method which lets you search according to a search criteria

DataRow[] myRows = ds.Tables[0].Select("intCol=0 OR stringCol='yourSearch'");