none
datareader error RRS feed

  • Question

  • i am trying to access three combobox from database source with sqlserver but i am getting error in second combobox that data reader is already open when i close data reader it give error cant read data when datareader close.
    Wednesday, May 18, 2011 11:19 PM

All replies

  • Hi,

    This forum is about Windows Workflow Fundation. Let me move the thread to correct forum which should be more appropriate for you to get suggsetions.

    Thanks,


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, May 23, 2011 9:51 AM
  • Hi,

    If you use multiple result set in your query then you may use the NextResult method to get data from the others. Eg:

    SELECT Col1 FROM TableA;

    SELECT Col1 FROM TableB;

    The code above uses 2 result sets. You can find a pretty good example for this scenario at here: http://msdn.microsoft.com/en-us/library/haa3afyz(VS.80).aspx

    I hope it helps

    J.


    There are 10 type of people. Those who understand binary and those who do not.
    Monday, May 23, 2011 10:50 AM