showing information from database automatically...

Mfwamba Tshimanga

Hi!

I have two forms ("entry" and "reservation").
I have one database with have two columns ("datereservation" and "names").
In opening the "entry" form if there is any reservation date today, the "reservation" form should open automatically. In other case its couldnot.
Please have a look on my codes:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel\hotel\\app_data\reservation.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from reservation where datereservation ='" + DateTime.Now + "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

{

MessageBox.Show("There is no reservation " + DateTime.Now + " encontrada(s)");

}

read.Close();

sqlCon.Close();

RptReservation reserv = new RptReservation ();

reserv.ShowDialog();

3 Replies

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

Vulpes11y ago
I'd overlooked previously that you were using MS Access which uses hashes rather than single quotes to delimit date literals.

See if this will work:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel\hotel\\app_data\reservation.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from reservation where datereservation = #" + DateTime.Today.ToString("yyyy-MM-dd") + "#";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if(!read.HasRows)
{
MessageBox.Show("There is no reservation " + DateTime.Today + " encontrada(s)");
}
else
{
while(read.Read())
{
// code to read reservations
}
}

read.Close();
sqlCon.Close();
Mfwamba Tshimanga11y ago
@Vulpes
See what I do and its gives this error "Type of datas incorrect in expression query". But I went in msaccess database and I put my column data as date/hour and dd-mm-yyyy

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel\hotel\\app_data\reservation.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from reservation where datereservation ='" + DateTime.Today+ "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

{

MessageBox.Show("There is no reservation " + DateTime.Today + " encontrada(s)");

}

read.Close();

sqlCon.Close();
Vulpes11y ago
Well, if you're not getting any matches just now it may be because you're using DateTime.Now which gives the time to the nearest second.

If only the date of the reservation is stored in the database and you want to get all reservations for today then I'd use DateTime.Today instead.

You might also have a problem with the formatting of the date. If you are, then I'd try:

DateTime.Today.ToString("yyyy-MM-dd")