trouble with DataReader

[Bernie V]

Hi group,

I'm trying to use a DataReader but I get an error.

This is my code:

private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection oCon = new SqlConnection("server=server;uid=id;" +
"pwd=pwd;database=database");
SqlCommand oCmd = new SqlCommand("SELECT nieuwsid, datum, titel FROM news
WHERE datum <= { fn CURDATE() })ORDER BY datum DESC",oCon);
oCon.Open();
oCmd.Connection=oCon;
SqlDataReader dr = oCmd.ExecuteReader();
oCmd.Dispose ();
oCon.Close();
oCon.Dispose();
}

I have an error at runtime on the line SqlDataReader dr =
oCmd.ExecuteReader();
The error is: Incorrect syntax near ')'.

With I simply delete the line with the error then I don't get an error, so I
think the error is in the line SqlDataReader dr = oCmd.ExecuteReader();

Can someone say what I do wrong ?

grz

Bernie V

 

[Marina]

I think you query syntax is off. Try running it in query analyzer and fix
it.

 

[Bernie V]

I think you query syntax is off. Try running it in query analyzer and fix
it.

Hi Marina,

This was also my first opinion. But I changed the query to a simple select
query and I had the same problem.
The query like I use works in the query analyser.

grz

Bernie V

 

[Kevin Spencer]

The error message indicates a syntax problem with the query. I would suggest
either putting a breakpoint in, or recording the generated query somewhere
so that you can copy the generated query string and run it in Query Analyzer
to find out the problem with it.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Bernie V]

I think you query syntax is off. Try running it in query analyzer and fix
it.

Marina,

I double cheked and you 're right !
There where to many ')' .

Thx !

grz

Bernie V

 

[Dilip Krishnan]

Looks like you dont have a corresponding '('

Hi group,

I'm trying to use a DataReader but I get an error.

This is my code:

private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection oCon = new SqlConnection("server=server;uid=id;" +
"pwd=pwd;database=database");
SqlCommand oCmd = new SqlCommand("SELECT nieuwsid, datum, titel FROM news
WHERE datum <= { fn CURDATE() })ORDER BY datum DESC",oCon);
oCon.Open();
oCmd.Connection=oCon;
SqlDataReader dr = oCmd.ExecuteReader();
oCmd.Dispose ();
oCon.Close();
oCon.Dispose();
}

I have an error at runtime on the line SqlDataReader dr =
oCmd.ExecuteReader();
The error is: Incorrect syntax near ')'.

With I simply delete the line with the error then I don't get an error, so I
think the error is in the line SqlDataReader dr = oCmd.ExecuteReader();

Can someone say what I do wrong ?

grz

Bernie V