The DataTable class exposes two methods that you can use to locate data based on search criteria. One method, Find, lets you locate a row based on its primary key values. The other, Select, acts as more of a filter, returning multiple rows of data based on more flexible search criteria.
When you’re querying your database for information, you’ll often want to retrieve a specific row of data based on the values of its primary key columns, using a query such as this one:
SELECT CustomerID, CompanyName, ContactName, Phone FROM Customers WHERE CustomerID = 'ALFKI'
You can also locate a DataRow in a DataTable based on the row’s primary key values. You might ...