select query on datatable

Question

Dears,

For my C# windows application I want to select data from a datatable based on certain condition.In other words I want to use query "select * from datatable where transationName = 'Sales' and transDate = #1/1/2011#" on a datable in visual studio 2005.





Thanks In Advance,
With Warm Regards,
Ashrafuddin.T