private void button4_Click(object sender, EventArgs e) { dataGridView1.Update(); dataGridView1.DataSource = null; dataGridView1.DataBindings.Clear(); bs.DataSource = null; dataGridView1.Update();; dataGridView1.Refresh(); abc = true; con.Close(); dataGridView1.Dispose(); this.Dispose(); gridview f3 = new gridview(); f3.Show(); LoadData(); }
private void button1_Click(object sender, EventArgs e) { MySqlConnection con = null; MySqlDataReader reader = null; MySqlDataReader reader2 = null; string MyconnectionString = "Server=localhost;Database=mysql;username=adil1;password=adilrocks;"; con = new MySqlConnection(MyconnectionString); con.Open(); // this.Text = Globals.iniVar.sResult1; string abc; abc = this.Text; //MessageBox.Show("Result:askteacher" + abc); String inc = "1"; if (radioButton1.Checked) { inc = "1"; Globals.iniVar.inc_cr = inc; } if (radioButton2.Checked) { inc = "2"; Globals.iniVar.inc_cr = inc; } String cmdText = "UPDATE teacher SET totalcr = totalcr + " + inc + " where name = '" + Globals.iniVar.teacher_name + "'"; MySqlCommand cmd = new MySqlCommand(cmdText, con); String cmdText1 = "SELECT subject FROM teacher WHERE name = '" + Globals.iniVar.teacher_name + "'"; MySqlCommand cmd1 = new MySqlCommand(cmdText1, con); reader = cmd1.ExecuteReader(); if (reader.Read()) { Globals.iniVar.teacher_subject = reader.GetString(0); //MessageBox.Show(subject1); } string selectbagde = "not slected"; if (radioButton3.Checked) { selectbagde = "electrical2k11"; // MessageBox.Show(selectbagde); /* String cmdText1 = "SELECT name,reg no,attandance status FROM electrical 2k11 WHERE rfid = '" +teacher + "'"; * MySqlCommand cmd1 = new MySqlCommand(cmdText1, con); * * //MessageBox.Show("After Read"); * reader = cmd1.ExecuteReader(); */ } if (radioButton4.Checked) { selectbagde = "electrical2k12"; MessageBox.Show(selectbagde); } if (radioButton5.Checked) { selectbagde = "electrical2k13"; MessageBox.Show(selectbagde); } if (radioButton6.Checked) { selectbagde = "electrical2k14"; } if (radioButton7.Checked) { selectbagde = "mechanical2k11"; } if (radioButton8.Checked) { selectbagde = "mechanical2k12"; } if (radioButton9.Checked) { selectbagde = "mechanical2k13"; } if (radioButton10.Checked) { selectbagde = "mechanical2k14"; } if (radioButton11.Checked) { selectbagde = "cs2k12"; } if (radioButton12.Checked) { selectbagde = "cs2k13"; } if (radioButton13.Checked) { selectbagde = "cs2k14"; } reader.Close(); /* * String cmdText2 = "SELECT `rfid`FROM `electrical 2k11` WHERE name='adil'"; * MySqlCommand cmd2 = new MySqlCommand(cmdText2, con); * //string reader1; * * // reader.NextResult(); * * reader2 = cmd2.ExecuteReader(); * * if (reader2.Read()) * { * * string rfid1 = reader2.GetString(0); * MessageBox.Show(rfid1); * //MessageBox.Show(rfid1); * } * */ gridview f2 = new gridview(); f2.Show(); this.Hide(); }