Can we execute a query on DataTable

Then you can convert the DataRow Array returned by the Select method to a new DataTable using the CopyToDataTable extension method. Please check this post on forum about this method.