I
Ian
I wish to use a datareader to loop through the result set of a stored
procedure. (Several resultsets actually.)
It's for rendering HTML, so I don't need to ever keep this data, just
stream through it.
If I create a dataset, I can create a queryadapter, and then add
sprocs. It will only let me create that sproc as a return a value
(which I guess is the old RETURN_VALUE param) or return nothing.
It won't let me return a datareader.
If I create a sproc as the select statement as a table adapter, it
won't let me return anything other than a table, or a filltable. I
can't get at the datareader there either.
Further, if I add to the class via the partial class mechanism, I can't
see the _commandcollection object.
Any ideas?
procedure. (Several resultsets actually.)
It's for rendering HTML, so I don't need to ever keep this data, just
stream through it.
If I create a dataset, I can create a queryadapter, and then add
sprocs. It will only let me create that sproc as a return a value
(which I guess is the old RETURN_VALUE param) or return nothing.
It won't let me return a datareader.
If I create a sproc as the select statement as a table adapter, it
won't let me return anything other than a table, or a filltable. I
can't get at the datareader there either.
Further, if I add to the class via the partial class mechanism, I can't
see the _commandcollection object.
Any ideas?