Good day, I want to check the expire date in my database. I have a code but note work for me.
<code>DateTime date = DateTime.Now;
MySqlCommand cmd1 = new MySqlCommand("SELECT * FROM db_maintenance_schedule WHERE schedule < NOW())", DBConnection.con);
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
MessageBox.Show("expire");
}
</code>
<code>DateTime date = DateTime.Now;
MySqlCommand cmd1 = new MySqlCommand("SELECT * FROM db_maintenance_schedule WHERE schedule < NOW())", DBConnection.con);
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
MessageBox.Show("expire");
}
</code>
DateTime date = DateTime.Now;
MySqlCommand cmd1 = new MySqlCommand("SELECT * FROM db_maintenance_schedule WHERE schedule < NOW())", DBConnection.con);
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
MessageBox.Show("expire");
}
Please help me to fix my problem.