SqlConnection con = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=LocalDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); SqlCommand cmd = new SqlCommand("SELECT seatNumber FROM CustomersInfo WHERE seatNumber=@seatNumber",con); cmd.Parameters.AddWithValue("@seatNumber", textBox1.Text.ToLower()); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { //if the seatNumber already exists. button2.Enabled = false; button2.BackColor = Color.Red; } else { //else }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)