How to nest DataReader in .net?

lzqcandy

while (sdr.Read ())
        {

            storeid = sdr [0] .ToString ();
            Storepi = sdr [1] .ToString ();
            mobileinfoid = sdr [2] .ToString ();
            MobileModel = sdr [3] .ToString ();


            sdrAccessory = AccessoryStoreCmd.ExecuteReader ();
            while (sdrAccessory.Read ())
            {
                AccessoryName + = sdr [0];
                AccessoryName + = "";
                AccessoryName + = sdr [1];
                AccessoryName + = "";
            }

}

shubiao123

This will take two Connections, lz think twice

lzqcandy

I want to use code to dynamically output a table to the foreground. This line is a cell phone type message. Each phone model contains multiple accessories. I just want to traverse the database and add each accessory as a string and put it into a cell.

qwer000

Can't stored procedures work?

lb1514

Use dataset first