cshuhh wrote:
can we two different readers in two nested while loops
That wouldn't be possible according to the documentation;
While the SqlDataReader is being used, the associated SqlConnection is busy serving the SqlDataReader, and no other operations can be performed on the SqlConnection other than closing it. This is the case until the Close method of the SqlDataReader is called.
.
The alternative would be to replace one of the readers with a
DataSet, or to open a second connection.