Using Rows.Find In ADO.NET
Join the DZone community and get the full member experience.Join For Free
When using a DataTable in ADO.NET, you may want to search your table given a key. The Find method requires the index of the primary key to find the row that you're looking for. However, before you do this you must set the primary key of the Datatable. Setting the primary key in your database is not enough. To set the primary key, create a new column and then set the primary key field on the Datatable like so:
// Create the DataColumn list for holding the columns of the primary keys. In this case, we are using only one primary key DataColumn primaryKeyColumns = new DataColumn; // Set the first primary key to the column 'id' in the datatable primaryKeyColumns = myDataTable.Columns["id"]; // Now apply the primary key to the datatable myDataTable.PrimaryKey = primaryKeyColumns;
Opinions expressed by DZone contributors are their own.