1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| string cmdQuery = "select ID_ch, nom_ch date_debut, date_fin from calendrier, chambre where chambre.ID_ch=calendrier.ID_ch";
OracleCommand cmd = new OracleCommand(cmdQuery);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TableRow tRow = new TableRow();
tb.Rows.Add(tRow);
TableCell tCell = new TableCell();
TableCell tCel2 = new TableCell();
if (Convert.ToDateTime(TextBox1.Text)>reader[1] || Convert.ToDateTime(TextBox1.Text)<reader[2] || Convert.ToDateTime(TextBox2.Text)>reader[1] || Convert.ToDateTime(TextBox2.Text)>reader[2])
{
tCell.Text = reader[0];
tRow.Cells.Add(tCell);
tCel2.BackColor = Color.Green;
tRow.Cells.Add(tCel2);
}
else
{
tCell.Text = reader[0];
tRow.Cells.Add(tCell);
tCel2.BackColor = Color.Red;
tRow.Cells.Add(tCel2);
}
} |
Partager