Datatable.Select Method with multiple conditions

Select method of DataTable is used to select rows from datatable (see this post). We can have multiple Boolean conditions in select method just like we do in SQL. It some situations it can save many round trips to database.

DataRow[] SelectedRow= MyDataTable.Select("Id = 5 Or RegistrationNo=72);

3 thoughts on “Datatable.Select Method with multiple conditions

Leave a Reply to girish Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s