private void button9_Click(object sender, EventArgs e) { con.Open(); string Query = "INSERT INTO `staff`(`Sid`, `name`, `Login_id`, `phone`, `DoB`, `Address`) VALUES ('" + Convert.ToInt32(this.textBox12.Text) + "','" + this.textBox19.Text + "','" + this.textBox14.Text + "','" + this.textBox16.Text + "','" + this.dateTimePicker3.Text + "','" + this.textBox15.Text + "')"; MySqlCommand MyCommand = new MySqlCommand(Query, con); MySqlDataReader MyReader = MyCommand.ExecuteReader(); con.Close(); signup sup = new signup(textBox14.Text, "Staff"); sup.Show(); }
private void button6_Click(object sender, EventArgs e) { con.Open(); String gender = null; if (radioButton4.Checked) { gender = radioButton4.Text; radioButton3.Checked = false; } if (radioButton4.Checked) { gender = radioButton4.Text; radioButton3.Checked = false; } string Query = "INSERT INTO `doctorreg`(`Did`, `Name`, `Login_id`, `Gender`, `Department`, `DoB`, `Email`, `Mno`, `Qualification`) VALUES ('" + Convert.ToInt32(this.textBox12.Text) + "','" + this.textBox11.Text + "','" + this.textBox13.Text + "','" + gender + "','" + this.textBox10.Text + "','" + this.dateTimePicker2.Text + "','" + this.textBox9.Text + "','" + this.textBox8.Text + "','" + this.textBox7.Text + "')"; MySqlCommand MyCommand = new MySqlCommand(Query, con); MySqlDataReader MyReader = MyCommand.ExecuteReader(); con.Close(); signup sup = new signup(textBox13.Text, "Doctor"); sup.Show(); }