Comparing date in access database
- by Simon
How can i compare the day in the access database to a given day in c#?
The date column in the database is an general date(day/month/year)
try
{
database = new OleDbConnection(connectionString);
database.Open();
date = DateTime.Now.ToShortDateString();
string queryString = "SELECT user_name,zivila.naziv "
+ "FROM (users LEFT JOIN obroki_save ON obroki_save.ID_uporabnika=users.ID)"
+ " LEFT JOIN zivila ON zivila.ID=obroki_save.ID_zivila "
+ " WHERE users.ID= " + a.ToString() + " AND obroki_save.datum=# " + date;
loadDataGrid(queryString);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
