Mike,

Thank you for replying.  I tried your suggestion and sure enough, that was it!  I really appreciate it.

Thanks again!

mbanavige

you'd want to remove the while reader.Read() bit entirely.  The databinding operation is what's going to read through the reader.  If you call read() yourself and then dont do anything with the data that was read, you're essentially throwing it away.

i think you'd end up with code something like this:

connection.Open();
            reader = populateList.ExecuteReader();
 
            pcategory.DataSource = reader;
            pcategory.DataValueField = "Category";
            pcategory.DataBind();
          
            reader.NextResult();
          
            psubcategory.DataSource = reader;
            psubcategory.DataValueField = "SubCategory";
            psubcategory.DataBind();
             
            reader.NextResult();
             
            user.DataSource = reader;
            user.DataValueField = "LName";
            user.DataBind();
             
            reader.Close();