public void AddNew(UserType newUserType) { MyConnection newConnection = new MyConnection(); MySqlCommand comm = new MySqlCommand(); MySqlConnection conn = new MySqlConnection(newConnection.ConnectionString); try { conn.Open(); String strQuery = "INSERT INTO tblUserType(UserType) VALUES ('" + newUserType._UserType + "')"; comm.Connection = conn; comm.CommandText = strQuery; comm.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message, "PMIS", MessageBoxButtons.OK, MessageBoxIcon.Error); } conn.Close(); }
private void frmUserTypeEntry_Load(object sender, EventArgs e) { MyConnection newConnection = new MyConnection(); newConnection.OpenConnection(newConnection.ConnectionStringforSystem); }