I'm having problem when I read more then one datareaders in row. The second one always get exception. I know this is one of the favourite topics of ADO.NET, but could not solve my problem no matter what I do. I use a class to prepare my datareader. If only one reading no problem so far. But with two readings it does not work. I even tried the first reading without using a DAL class, instead just did it on the main line it works but when I use the DAL class for the second reading I get exception.
I appreciate any help,