private void btn_Ok_Click(object sender, EventArgs e) { Canteen c = new Canteen(); addEmployee(); c.Refreshwindow(); }
public void addEmployee() { Canteen c = new Canteen(); try { conn = new MySqlConnection(strConn); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; string nall = null; //MessageBox.Show(id); //string getIDCateg = cbStatus.Text.Split(' ')[0]; cmd.CommandText = "insert into tbl_employee_stat values(" + this.txt_ID_NUMBER.Text + ",'" + this.txt_NAME.Text + "'," + cbStatus.Text.Split(' ')[0] + ")"; //cmd.CommandText = "Insert into tbl_employee_status values("+ nall +","+ nall +","+ cbStatus.Text.Split(' ')[0] + ")"; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Employee Successfully Added"); clear(); c.Refreshwindow(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message + ex.StackTrace); } }