Hi, I got it working. I am now able to access the second resultset too. If anybody is interested this was the problem I had and I found some info on net on how to solve that. I have a stored procedure returning more than one result set. So initially I was unable to access the second result set using C#. Then I found info on msdn. 1. Use datareader and execute the stored procedure. 2. run the while(datareader.Read()) method and get the results of first result set. 3. Then dataReader.NextResult(); 4. run the dataReader.Read() again to get the results of the second result set. And so on if you have more result sets coming from stored procedure. Then close the reader and connection. That's all. Thankyou. Raj.
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/saFolB/TM ---------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
