private void SubmitBtn_Click(object sender, EventArgs e) { con = new SqlConnection(@"data source= rafi\SqlExpress;" + "database= Course;" + "integrated security= SSPI"); con.Open(); int a = 0; if (checkBox1.Checked) { cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con); cmd.Parameters.AddWithValue("@name", i); cmd.Parameters.AddWithValue("@gen", "Maths101"); cmd.ExecuteNonQuery(); a = 1; } if (checkBox2.Checked) { cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con); cmd.Parameters.AddWithValue("@name", i); cmd.Parameters.AddWithValue("@gen", "Maths102"); cmd.ExecuteNonQuery(); a = 1; } if (checkBox2.Checked) { cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con); cmd.Parameters.AddWithValue("@name", i); cmd.Parameters.AddWithValue("@gen", "Maths103"); cmd.ExecuteNonQuery(); a = 1; } if (a == 1) { MessageBox.Show("Submitted!"); this.Hide(); AvailableForT2 add = new AvailableForT2(id); add.Show(); } }
public AvailableForT(string uid) { InitializeComponent(); id = uid; i = Convert.ToInt32(id); try { con1 = new SqlConnection(@"data source= rafi\SqlExpress;" + "database= Course;" + "integrated security= SSPI"); cmd = new SqlCommand("SELECT cid from courses where SUBSTRING (cid,1,3) like (Select CASE WHEN " + "Education= 1 THEN 'Mat' WHEN Education= 3 THEN 'Mat' END AS Education " + "from Teacher where tid=(@data))", con1); cmd.Parameters.AddWithValue("@data", i); con1.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { ch1 = 1; } } if (ch1 != 99) { this.Hide(); AvailableForT2 a = new AvailableForT2(id); a.Show(); } } finally { } }