DataTable Select method

  • Thread starter Thread starter Mandar Patankar via .NET 247
  • Start date Start date
M

Mandar Patankar via .NET 247

I want to know what kind of queries can i execute on datatable select method. The one i am interested in is between query

for eg:- this is my sample query

Select max(resultan) from TblseasResult Where SeasId='15.3.13.3302005' And Countno between 4801 and 4806


where Countno is numerical field

now this is what i want to do

DataTable1.select("Countno between 4801 and 4806")

so it should return all the rows as Datarow array

Thanks
 
Mandar,
"BETWEEN" is not one of the recognized keywords when it comes to sorting and
filtering DataTables. You'll need to use:

DataTable1.select("Countno >= 4801 and <= 4806")

David

Mandar Patankar via .NET 247 said:
I want to know what kind of queries can i execute on datatable select
Click to expand...
method. The one i am interested in is between query
 
Back
Top