Does DataBind close a datareader?

[Joel Reinford]

I am attempting to verify whether a datareader is closed by calling the
databind on a control.

for example (fake code)
Dim rdr as SqlDataReader
rdr = mycommand.execu teReader...

MyDataGrid.Data Source = rdr
MyDataGrid.Data Bind()

Is the DataReader closed at this point or do I still need to do rdr.Close()?

Best I can tell, it is closed but I'm not quite sure how to verify it.

[Ashish M Bhonkiya]

Hi Joel,
MyDataGrid.Data Bind() does not close your datareader, to test this.

try to retrieve the FieldCount property of the datareader after calling the
databind() method
now call the close method of datareader and then try to retrieve the
fieldcount property an exception will be thrown.

HTH
Regards
Ashish M Bhonkiya
"Joel Reinford" <jr********@ear thlink.net> wrote in message
news:WP******** ************@co mcast.com...

I am attempting to verify whether a datareader is closed by calling the
databind on a control.

for example (fake code)
Dim rdr as SqlDataReader
rdr = mycommand.execu teReader...

MyDataGrid.Data Source = rdr
MyDataGrid.Data Bind()

Is the DataReader closed at this point or do I still need to do rdr.Close()?
Best I can tell, it is closed but I'm not quite sure how to verify it.

[Trinath]

Hi Joel,

DataBind does close the datareader.

You can verify this:
Datareader uses connected model (i.e.) as long as the datareader is open you can't use the same connection object for other purposes.
This will result in an Exception.
But after doing a DataBind (without closing the datareader) if you try to use the connection object , it doesn't raise any exception.
Well this means that the data reader is closed and connection is free to be used for other things.

[Donald E. Hurley Jr.]

It should still be open.

To check test rdr.IsClosed

Hope this helps.
"Joel Reinford" <jr********@ear thlink.net> wrote in message
news:WP******** ************@co mcast.com...

I am attempting to verify whether a datareader is closed by calling the
databind on a control.

for example (fake code)
Dim rdr as SqlDataReader
rdr = mycommand.execu teReader...

MyDataGrid.Data Source = rdr
MyDataGrid.Data Bind()

Is the DataReader closed at this point or do I still need to do rdr.Close()?
Best I can tell, it is closed but I'm not quite sure how to verify it.

[Ashish M Bhonkiya]

Hi Trinath,

Can you check datareader's IsClosed property and confirm if the reader
object gets closed after the databind method on the datagrid.

I have tried this leme know if i am doing something wrong here.

// Code in the page load
SqlConnection myConnection = new
SqlConnection(" server=ISC1XR\\ EINSTIEN;integr ated
security=SSPI;d atabase=northwi nd");

SqlCommand mySelSqlCommand = new SqlCommand("Sel ect * from
Customers", myConnection);

try
{
myConnection.Op en();
SqlDataReader myReader = mySelSqlCommand .ExecuteReader( );
Response.Write( " Data Reader is Closed ?(after
Retrieveing)" + myReader.IsClos ed.ToString());
DataGrid1.DataS ource = myReader;
DataGrid1.DataB ind();
Response.Write( "Data Reader is Closed ?(after DataBind)" +
myReader.IsClos ed.ToString());
myReader.Close( );
Response.Write( ""Data Reader is Closed ?(after Closing)" +
myReader.IsClos ed.ToString());
}
catch(SqlExcept ion se)
{
Response.Write( "Error : " + se.ToString());
}
finally
{
myConnection.Cl ose();
}

// Code in the page load -Ends

Thanks
Ashish M Bhonkiya
"Trinath" <an*******@disc ussions.microso ft.com> wrote in message
news:FC******** *************** ***********@mic rosoft.com...

Hi Joel,

DataBind does close the datareader.

You can verify this:
Datareader uses connected model (i.e.) as long as the datareader is open you can't use the same connection object for other purposes. This will result in an Exception.
But after doing a DataBind (without closing the datareader) if you try to use the connection object , it doesn't raise any exception. Well this means that the data reader is closed and connection is free to

be used for other things.

[Trinath]

Hi Ashish

Here is what the MSDN documentation says
"Note that while a DataReader is open, the Connection is in use exclusively by that DataReader. You will not be able to execute any commands for the Connection, including creating another DataReader, until the original DataReader is closed.

So I tried this

Dim lcon As New OracleConnectio n("connection string"
Dim lcmd As New OracleCommand(" sql query", lcon
Dim ldr As OracleDataReade

lcon.Open(
ldr = lcmd.ExecuteRea der(
DataGrid1.DataS ource = ld
DataGrid1.DataB ind(

Dim lcmd2 As New OracleCommand(" sql query", lcon
Dim ldr2 As OracleDataReade
ldr2 = lcmd2.ExecuteRe ader(
DataGrid2.DataS ource = ldr
DataGrid2.DataB ind(

Both the datagrids did get displayed ie. page ran without exceptions
If the MSDN documentation is correct then I should get an error, becos I am executin
another command without closing the first data reader. So I thought that DataBind doe
close the DataReader

I have executed your example and saw that the data reader is not closed after DataBind. Hmm..

Well I just dont know what to say
Any comments

Rgds
Trinath.