private void ChonRole_button_Click(object sender, EventArgs e) { tabControl2.TabPages.Remove(RoleTab); string role = role_comboBox.Text; is_user = false; this.username = role_comboBox.Text; NAME_label.Text = "ROLE " + role; // Select DataTable ret = Oracle.GetAllPriv(Login_Form.conn, role); Priv_Preprocessing(ret); Select_User_dataGridView1.DataSource = ret; }
private void ChonUser_button_Click(object sender, EventArgs e) { if (tabControl2.TabCount < 2) { tabControl2.TabPages.Add(RoleTab); } this.username = user_comboBox.Text; string username = user_comboBox.Text; is_user = true; NAME_label.Text = "USER " + username; // Select DataTable ret = Oracle.GetAllPriv(Login_Form.conn, username); //DataTable ret2 = Oracle.GetRemain_One_User(Login_Form.conn, username, "SELECT"); Priv_Preprocessing(ret); Select_User_dataGridView1.DataSource = ret; // ROLE ret = Oracle.GetRoleGrantedToUser(Login_Form.conn, username); RoleGrantedToUser_dataGridView.DataSource = ret; }