Invalid attempt to call FieldCount when reader is closed

[mark.norgate]

Hi

I have a problem with a repeater and a data connection.

In my Page_Load, I have the following code:

Dim connectionStrin g As String =
WebConfig.Conne ctionString
Dim connection As SqlConnection = New
SqlConnection(c onnectionString )
Dim adapter As SqlDataAdapter = New
SqlDataAdapter( "SELECT applicationID FROM pvtProductAppli cation WHERE
productID = " + Request.QuerySt ring("prodId"), connection)
Dim dataSet As DataSet = New DataSet()
connection.Open ()
adapter.Fill(da taSet)
ApplicationRepe ater.DataSource = dataSet
ApplicationRepe ater.DataBind() /* error here */
connection.Clos e()

and I have a ApplicationRepe ater_ItemCreate d that also opens a data
connection and closes it. The error is raised as indicated above.

Can someone please help??

Thanks, Mark

[Teemu Keiski]

Hi,

are these operations (this and the one in ItemCreated) sharing the same
connection object, which would get closed unexpectedly?

You don't need to optimize that way (sharing one connection on the page)
necessarily, since connection pooling in .NET will mostly take care of that
e.g it will get you connections efficiently and reuse them. Of course if
there could be numerous of conenction object creations, that's another thing

And with DataAdapters' you don't need to open the connection first before
calling Fill, it is opened for you.

Anyways, to give more exact advice, can you show the code in ItemCreated
using the connection?
--
Teemu Keiski
AspInsider, ASP.NET MVP
http://blogs.aspadvice.com/joteke
http://teemukeiski.net


<ma**********@g mail.comwrote in message
news:51******** *************** ***********@b64 g2000hsa.google groups.com...

Hi

I have a problem with a repeater and a data connection.

In my Page_Load, I have the following code:

Dim connectionStrin g As String =
WebConfig.Conne ctionString
Dim connection As SqlConnection = New
SqlConnection(c onnectionString )
Dim adapter As SqlDataAdapter = New
SqlDataAdapter( "SELECT applicationID FROM pvtProductAppli cation WHERE
productID = " + Request.QuerySt ring("prodId"), connection)
Dim dataSet As DataSet = New DataSet()
connection.Open ()
adapter.Fill(da taSet)
ApplicationRepe ater.DataSource = dataSet
ApplicationRepe ater.DataBind() /* error here */
connection.Clos e()

and I have a ApplicationRepe ater_ItemCreate d that also opens a data
connection and closes it. The error is raised as indicated above.

Can someone please help??

Thanks, Mark