Hi,
You can specify multiple criteria in single statement.For example:
DataRow[] foundRows;
DataTable myTable;
myTable = ds.Tables["Orders"];
// Setup Filter and Sort Criteria
strExpr = "OrderDate >= '01.03.1998' AND OrderDate <= '31.03.1998'";
strSort = "OrderDate DESC";
// Use the Select method to find all rows matching the filter.
foundRows = myTable.Select(strExpr, strSort);

Signature
Hope this helps.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.
> ..NET 2.0
>
[quoted text clipped - 24 lines]
>
> Any suggetions?
Jeff - 20 Jul 2007 12:00 GMT
> Hi,
> You can specify multiple criteria in single statement.For example:
[quoted text clipped - 42 lines]
>>
>> Any suggetions?
Jeff - 20 Jul 2007 12:02 GMT
Thanks, but can I specify sub-selects in the DataTable.Select ?
> Hi,
> You can specify multiple criteria in single statement.For example:
[quoted text clipped - 42 lines]
>>
>> Any suggetions?
Nicholas Paldino [.NET/C# MVP] - 20 Jul 2007 20:16 GMT
Jeff,
No, you can not. What I am curious about is why you don't do this in a
stored procedure. You said you aren't using it in this project, but this
seems like a compelling reason to me.

Signature
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com
> Thanks, but can I specify sub-selects in the DataTable.Select ?
>
[quoted text clipped - 45 lines]
>>>
>>> Any suggetions?