public GARITS() { InitializeComponent(); permissions = new Permissions(); try { settingsFile = new SettingsFile(); db = new Database(settingsFile.getSetting("dbserver"), settingsFile.getSetting("dbname"), settingsFile.getSetting("dbuser"), settingsFile.getSetting("dbpassword")); db.Connect(); permissions.readPermissions(db); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Environment.Exit(1); } permissions.AddComponent(administrationToolStripMenuItem, "Administration Menu Item"); }
public Administration(Database db) { InitializeComponent(); database = db; MySqlDataAdapter MyDA = new MySqlDataAdapter(); string sqlDept = "SELECT users.userID as 'ID', users.username as 'Username', roles.rolename as 'Role', users.firstname as 'Firstname', users.surname as 'Surname', users.active as 'Active' FROM USERS, ROLES WHERE users.roleid = roles.roleid AND users.deleted <> 1 AND users.username <> 'root'"; MyDA.SelectCommand = new MySqlCommand(sqlDept, db.sqlConn); DataTable table = new DataTable(); MyDA.Fill(table); BindingSource bSource = new BindingSource(); bSource.DataSource = table; //DataGridView dgView = new DataGridView(); dataGridView1.DataSource = bSource; for (int i = 1; i < dataGridView1.Columns.Count; i++) dataGridView1.Columns[i].ReadOnly = true; selectionCombo.SelectedIndex = 0; }