Ox40

        
-------------------- DATA ACCESS --------------------------
        public List<int> GetResourcesByUser(int iUserID)
        {
            //string sql = "SELECT RESOURCE.RES_NAME, USER_RESC_MAP.RES_ID FROM RESOURCE INNER JOIN USER_RESC_MAP ON RESOURCE.RES_ID = USER_RESC_MAP.RES_ID WHERE USER_RESC_MAP.USER_ID = @userID;";
            string sql = "SELECT RES_ID FROM USER_RESC_MAP WHERE USER_ID = @userID";
            DataTable dt = new DataTable();
            OleDbParameter[] paramArray = new OleDbParameter[1];

            paramArray[0] = new OleDbParameter("@userID", OleDbType.Integer);
            paramArray[0].Value = iUserID;

            dt = _db.Execute(sql, paramArray);
            List<int> userResources = new List<int>();

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow i in dt.Rows)
                {
                    userResources.Add(Convert.ToInt32(i["RES_ID"]));
                    //userResources.Add("A" + i["USER_RESC_MAP.RES_ID"] + "~" + i["RESOURCE.RES_NAME"]);
                }
                return userResources;
            }
            else
            {
                throw new Exception("ASDF");
            }
        }







------------------------------Default.ASPX.CS---------------------------------
        #region Define Page Editor Selection
        List<int> userResources = _da.GetResourcesByUser(userID);
        //char[] splitChars = new char[1];
        //splitChars[0] = '~';
        foreach (int a in userResources)
        {
            if ((a != 0)) //&&(a.Contains("~")))
            {
                resourceSelect.Items.Add(a.ToString());
                //resourceSelect.Items.Add(new ListItem(a.Split(splitChars)[1] + "A", a.Split(splitChars)[0] + "B"));
            }
        }
        #endregion