DataTable Select method

30 Mar 2005 10:34 PM

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
--------------------------------
From: Mandar Patankar

MCP

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>yuriN1lzc0ydMcoRYJ+RYw==</Id>

30 Mar 2005 10:47 PM

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

"Mandar Patankar via .NET 247" <anonym***@dotnet247.com> wrote in message
news:eMnVYiXNFHA.1308@TK2MSFTNGP15.phx.gbl...
> 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
Show quote

>
>
> 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
> --------------------------------
> From: Mandar Patankar
>
> MCP
>
> -----------------------
> Posted by a user from .NET 247 (http://www.dotnet247.com/)
>
> <Id>yuriN1lzc0ydMcoRYJ+RYw==</Id>