private void UpdateReservationContent(DateTime startDate) { string startDate_string = startDate.ToShortDateString(); DateTime endDate = startDate.AddDays(6); string endDate_string = endDate.ToShortDateString(); OleDbConnection cn = new OleDbConnection(); //Connection OleDbCommand cmd = new OleDbCommand(); //Command OleDbDataReader dr; String path = Assembly.GetExecutingAssembly().Location; path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb"); String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path); cn.ConnectionString = @connectionString; cmd.Connection = cn; try { cmd.CommandText = "SELECT * FROM Reservation WHERE ResDate BETWEEN startDate AND endDate"; cmd.Parameters.AddWithValue("startDate", startDate_string); cmd.Parameters.AddWithValue("endDate", endDate_string); cn.Open(); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Reservation_Weekly reservation = new Reservation_Weekly(dr[7].ToString(), dr[8].ToString()); reservation_weekly.Add(reservation); } } cn.Close(); } catch { // empty } UpdateAgendaButtons(startDate); }