I am not sure how to use the Select-method in the class DataTable. Selecting rows where certain columns have specific values is pretty straightforward
myTable.Select("FirstName = 'John'");

What should i put in there to select all rows where FirstName is blank (empty cell)?

In addition to the answer to this question I would also greatly appreciate a link to a site that explains the syntax for this filter expression (i have tried the msdn-library, but i can read there for hours without finding the answer i'm looking for).

You could try "ISNULL(FirstName, '') = ''".

You can find a discussion on the syntax in the MDSN library under DataColumn.Expression property.

Or at Microsoft Developer Network.


Kep.

Yes, that worked kep. Thanks a lot!