private void UsersAdd_FormClosed(object sender, FormClosedEventArgs e) { if (this.edit == true) { UserView vv = new UserView(); vv.Show(); vv.TopMost = true; } }
private void button1_Click(object sender, EventArgs e) { if (txtUser.Text == "" || txtPass.Text == "" || cmbPerm.Text == "") { MessageBox.Show("Fill up all forms!"); } else { if (txtPass.Text != txtRePass.Text) { MessageBox.Show("Password Mismatched!"); } else { connect.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM security WHERE username = '******'", connect); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); connect.Close(); if (dt.Rows.Count > 0) { MessageBox.Show("User exist!"); } else { try { SqlDataAdapter sda = new SqlDataAdapter(); sda.InsertCommand = new SqlCommand("INSERT INTO security (fullname, username, password, type) VALUES (@fullname, @user, @pass, @type)", connect); sda.InsertCommand.Parameters.Add("@fullname", SqlDbType.VarChar).Value = txtFullName.Text; sda.InsertCommand.Parameters.Add("@user", SqlDbType.VarChar).Value = txtUser.Text; sda.InsertCommand.Parameters.Add("@pass", SqlDbType.VarChar).Value = txtPass.Text; sda.InsertCommand.Parameters.Add("@type", SqlDbType.VarChar).Value = cmbPerm.Text; connect.Open(); sda.InsertCommand.ExecuteNonQuery(); connect.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } this.Close(); UserView cv = new UserView(); cv.Show(); MessageBox.Show("New user added!"); } } } }
private void viewToolStripMenuItem_Click(object sender, EventArgs e) { UserView user = new UserView(); user.Show(); }