private void _UserBindingNavigatorSaveItem_Click(object sender, EventArgs e) { this.Validate(); this._UserBindingSource.EndEdit(); this.tableAdapterManager.UpdateAll(this.dataSet1); MDIParent1 my = Application.OpenForms.OfType <MDIParent1>().Single(); my.UserRegistered(); }
private void button1_Click(object sender, EventArgs e) { try { if (textBox1.Text != null && textBox2.Text != null && textBox3.Text != null && comboBox1.SelectedIndex != -1) { int role = comboBox1.SelectedIndex; string str = ""; switch (role) { case 0: str = "db_owner"; break; case 1: str = "DecanatRole"; break; case 2: str = "TeacherRole"; break; case 3: str = "StarostaRole"; break; case 4: str = "StudentRole"; break; } role++; String quertString = @"insert into _User (login, password, id_role) values ('" + textBox2.Text + "','" + textBox3.Text + "','" + role.ToString() + "');"; SqlCommand insert = new SqlCommand(quertString, con); con.Open(); insert.ExecuteNonQuery(); con.Close(); //СОЗДАНИЕ String quertString2 = @"EXEC sp_addlogin " + textBox2.Text + "," + textBox3.Text + ",UniverConnect"; SqlCommand create2 = new SqlCommand(quertString2, con); con.Open(); create2.ExecuteNonQuery(); con.Close(); String quertString3 = @"EXEC sp_adduser " + textBox2.Text + "," + textBox1.Text + ""; SqlCommand create3 = new SqlCommand(quertString3, con); con.Open(); create3.ExecuteNonQuery(); con.Close(); String quertString4 = @"EXEC sp_addrolemember " + str + "," + textBox1.Text + " "; SqlCommand create4 = new SqlCommand(quertString4, con); con.Open(); create4.ExecuteNonQuery(); con.Close(); MDIParent1 my = Application.OpenForms.OfType <MDIParent1>().Single(); my.UserRegistered(); } else { MessageBox.Show("Заполнены не все поля", "Ошибка"); } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "У вас недостаточно прав!"); } }