C#嵌套循环查询语句

//从applyrights表中获取信息contentid, rid以及优先级别priority
                sqlstring = "SELECT * FROM applyright WHERE username='" + username + "'";
                cmd.CommandText = sqlstring;
                OleDbDataReader sdr2 = cmd.ExecuteReader();
                // 获取对应的参数
               while(sdr2.Read())
                {
                    CID = sdr2.GetString(1);
                    RID = (int)sdr2.GetInt16(2);
                    priority = (int)sdr2.GetInt32(3);
                    sqlstring = "";
                    //sdr2.Close();
                    //利用contentid从数据库contents表中提取kid
                    sqlstring = "select * from contents where contentid='" + CID + "'";
                    cmd.CommandText = sqlstring;
 因为同一个username有好几个CID和RID或者priority 的值，要根据CID的值来从数据库conten