private static void GetDBData(string TableName, string SelectSQL) { OracleDataAdapter DataAdapter = new OracleDataAdapter(new OracleCommand(SelectSQL, Database_Connector.GetConnection())); DataAdapter.Fill(DS, TableName); Database_Connector.CloseConnection(); }
private void Load(int Userid) { string select = "SELECT PERMISSION FROM USER_PERMISSIONS where USER_ID=:userid " + "UNION ALL SELECT PERMISSION FROM USER_GROUPS inner join GROUP_PERMISSIONS " + "on USER_GROUPS.GROUP_ID=GROUP_PERMISSIONS.GROUP_ID where USER_GROUPS.USER_ID=:userid"; OracleCommand cmd = new OracleCommand(select, Database_Connector.GetConnection()); OracleParameter uid = new OracleParameter("userid", OracleDbType.Int32); uid.Value = Userid; cmd.Parameters.Add(uid); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { UserPermissions.Add(dr["PERMISSION"].ToString().ToLower()); } Database_Connector.CloseConnection(); }
private void Main_Menu_FormClosed(object sender, FormClosedEventArgs e) { Database_Connector.CloseConnection(); }