DataTable.Select filterexpression

[Kevin Attard]

Hi

Is it possible to use multiple conditions in the filterexpression of the
DataTable's Select method?

eg:
ds.Tables["TableName"].Select("Type = 1 AND Name = "Joseph");

 

[Chris Fulstow]

Yes, the same rules apply as DataColumn.Expression:

"Concatenation is allowed using Boolean AND, OR, and NOT operators. You
can use parentheses to group clauses and force precedence. The AND
operator has precedence over other operators."

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

 

[Kevin Attard]

Thanks a lot Chris

Yes, the same rules apply as DataColumn.Expression:

"Concatenation is allowed using Boolean AND, OR, and NOT operators. You
can use parentheses to group clauses and force precedence. The AND
operator has precedence over other operators."

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

Hi

Is it possible to use multiple conditions in the filterexpression of the
DataTable's Select method?

eg:
ds.Tables["TableName"].Select("Type = 1 AND Name = "Joseph");