Datatable.select correct syntax

[sam]

Why the folowing code generates ans error in the select expression ?:
DataRow[] drRows = dsRevues.Tables[0].Select("year >= '2000' && year <=
'2007'");//

What is the correct syntax ?

Sam

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What error are you getting?

What type is the column "year" ?

If it's an integer just remove the ' around 2000 & 2007

 

[Henk Verhoeven]

Hi Sam
It should read
DataRow[] drRows = dsRevues.Tables[0].Select("year >= '2000' AND year <=
'2007'");

This is a more like SQL query, The MSDN for the select method has all the
allowed syntax you may need.

henk

 

[sam]

Year is a string. The problem was the &&. I have replace it with AND and it
works fine.
Thanks you for help.
sam

Hi,

What error are you getting?

What type is the column "year" ?

If it's an integer just remove the ' around 2000 & 2007

Why the folowing code generates ans error in the select expression ?:
DataRow[] drRows = dsRevues.Tables[0].Select("year >= '2000' && year <=
'2007'");//

What is the correct syntax ?

Sam

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Year is a string. The problem was the &&. I have replace it with AND and
it works fine.
Thanks you for help.
sam

Why are you keeping a column that represent year as a string?

 

[sam]

Why are you keeping a column that represent year as a string?

you are wright, but it is as is in the database I use.

sam