>>>No, it will work, I think, but you will need to close the reader in your code and also do try/catch in your code. What Michel was showing earlier with USING syntax I don't see how to apply for your scenario if you create reader in one method and work with it in another.
>>
>>I am sure Michel know this very well. It is just that he knows VB.NET very well and I don't know neither VB.NET no C# <g>. I am looking at the code that John Baird wrote. Thank you.
>
>My question to you is - why do you need to return reader object back to another method? I looked at what John wrote and it's great, but I don't think you need to separate creating DataReader object and working with it into 2 different methods. That's my point.
I see.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham