Problem with retrieving data - C#&MS Access

Neven

Hello,

I have minor problem with retrieving data from MS ACCESS database with SELECT - WHERE statement. I want to get certain rows based on date.

Here is the code:

 	    OleDbConnection con = new OleDbConnection(conn.ConnString.ToString());
            con.Open();
            OleDbCommand cmd = new OleDbCommand("SELECT Price FROM Warehouse WHERE Date = #"+date,con);
            OleDbDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                txtProba.AppendText(reader.GetValue(0).ToString() + "\n");
            }


            con.Close();

This part of code works but only without WHERE clause. With WHERE clause i get this error:

Syntax error in date in query expression 'Datum = #3.4.2010.'

3.4.2010 is value of date variable above in code. I don't know what to anymore i tried without #, but this doesn't work too...

Please give me a hand....

Thanks in advance.... Neven

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

mamoon qasim16y ago
Accepted answer
hi
would you please try this

where Date=#" + date + "#"
becouse access uses to "#" for date

please if it help notify me
Neven16y ago
Qasim thank you for answer...
But I solved problem in other way. The problem was due to localization.
In my country the normal date format is "dd.mm.yyyy" and in that format, dispite HR (Croatia) local settings on my computer that query didn't work for given format.
However i found out in some tutorial that "universal" date format for MS Access is "yyyy-mm-dd". I simply added 2 lines of code to my program and voila, it worked.

string date="21.12.2012";
DateTime dateX = Convert.ToDateTime(date);
//Transforms to "universal" form
date = dateX.Year + "-" + dateX.Month + "-" + dateX.Day;