1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SqlCommand MyCommande = new SqlCommand("SELECT * FROM Beds WHERE BedNumber = @BedNumber", Connection);
SqlParameter Myparam = new SqlParameter(); Myparam.ParameterName = "@BedNumber"; Myparam.Value = txtNumeroLit.Text; MyCommande.Parameters.Add(Myparam);
Connection.Open();
SqlDataReader MyReader = MyCommande.ExecuteReader();
if (MyReader.HasRows)
{
MessageBox.Show("Ce lit est occupé, Veuillez en choisir un autre", "Lit Occupé", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
Connection.Close(); |