DataTable Select method

[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

 

[David Young]

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

I want to know what kind of queries can i execute on datatable select

method. The one i am interested in is between query