HELP: Custom DataReader Function - Tricky issue

[VB Programmer]

I have a function that returns a datareader. The problem is that in the
function's FINALLY I close the datareader and set it to nothing. But,
BEFORE the Finally I "Return" the datareader (in the Try).

The problem is, by the time it's "returned" it says I already closed it. Any
ideas how I can overcome this? How can I clean up the objects nicely WHILE
returning it back to the caller????

Example:

Private Sub x
Dim dr as SqlDataReader
....
....
dr = GetDr(...) ' FAILS BECAUSE THE DATAREADER IS CLOSED BY NOW!
....
End Sub

Private Function GetDr(...) as SqlDataReader
Dim MyDataReader as SqlDataReader
Try
.....
....
Return MyDataReader
Catch
Finally
MyDataReader.Close
MyDataReader = Nothing
End Function

[Marina]

You can't. That's why you don't want to be returning datareaders. Because
then you are relying on the client to close the datareader and the
underlying connection.

Use a datatable or dataset instead.

"VB Programmer" <growNO-SPAM@go-intech.com> wrote in message
news:uiF0PTQYDHA.2620@TK2MSFTNGP09.phx.gbl...

> I have a function that returns a datareader. The problem is that in the
> function's FINALLY I close the datareader and set it to nothing. But,
> BEFORE the Finally I "Return" the datareader (in the Try).
>
> The problem is, by the time it's "returned" it says I already closed it.

Any

> ideas how I can overcome this? How can I clean up the objects nicely

WHILE

> returning it back to the caller????
>
> Example:
>
> Private Sub x
> Dim dr as SqlDataReader
> ....
> ....
> dr = GetDr(...) ' FAILS BECAUSE THE DATAREADER IS CLOSED BY NOW!
> ....
> End Sub
>
> Private Function GetDr(...) as SqlDataReader
> Dim MyDataReader as SqlDataReader
> Try
> .....
> ....
> Return MyDataReader
> Catch
> Finally
> MyDataReader.Close
> MyDataReader = Nothing
> End Function
>
>
>