Exemple #1
0
        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);
        }