Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Course Of The Month
3 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Invalid attempt to read when reader is closed
Posted on 2004-08-23
A colleague of mine is experiencing a very perplexing error.
He is using the following code to databind a datagrid:
Dim dbSearchReader As SqlDataReader = dbConnection.ConnectionStr
dbConnection.Open()
dbCommand = New SqlCommand(Session("SQL"),
dbSearchReader = dbCommand.ExecuteReader
dgProducts.DataSource = dbSearchReader
dgProducts.DataBind()
When he runs his program on localhost and the development server the datagrid binds correctly.
When he runs his program on the live server he gets the following error:
System.InvalidOperationExc
Any ideas are appreciated :-)
Thanks,
Dave.
He is using the following code to databind a datagrid:
Dim dbSearchReader As SqlDataReader = dbConnection.ConnectionStr
dbConnection.Open()
dbCommand = New SqlCommand(Session("SQL"),
dbSearchReader = dbCommand.ExecuteReader
dgProducts.DataSource = dbSearchReader
dgProducts.DataBind()
When he runs his program on localhost and the development server the datagrid binds correctly.
When he runs his program on the live server he gets the following error:
System.InvalidOperationExc
Any ideas are appreciated :-)
Thanks,
Dave.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
5 Comments
You cannot link to a DataReader, a DataReader is only used to display foward only information.
Use a DataSet Instead.
Use a DataSet Instead.
>> Dim dbSearchReader As SqlDataReader = ...??
I don't think you pasted the correct code, can you paste it again?
I don't think you pasted the correct code, can you paste it again?
Hi there,
when you bind ( dgProducts.DataBind()), ADO.Net closes the Reader. So, the reason you are getting error is, may be, due to something else you are doing after DataBinding. something else is trying to access the Reader.
when you bind ( dgProducts.DataBind()), ADO.Net closes the Reader. So, the reason you are getting error is, may be, due to something else you are doing after DataBinding. something else is trying to access the Reader.
Not sure why it put an "=" after the first line of pasted code? Shall post again.
Dim dbSearchReader As SqlDataReader
dbConnection.ConnectionStr
dbConnection.Open()
dbCommand = New SqlCommand(Session("SQL"),
dbSearchReader = dbCommand.ExecuteReader
dgProducts.DataSource = dbSearchReader
dgProducts.DataBind()
Cheers for the comments so far.
Dim dbSearchReader As SqlDataReader
dbConnection.ConnectionStr
dbConnection.Open()
dbCommand = New SqlCommand(Session("SQL"),
dbSearchReader = dbCommand.ExecuteReader
dgProducts.DataSource = dbSearchReader
dgProducts.DataBind()
Cheers for the comments so far.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Generate Unique ID in VB.NET | 21 | 136 | |
| How to show selected values from drop down and text box on the popup? | 25 | 43 | |
| how to pass the "this" object from C# to a Java Script function. | 2 | 40 | |
| ASP.NET Built-In Report Creator / Viewer | 5 | 41 |
ASP.Net to Oracle Connectivity
Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers to develop an ASP.NET client…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
- Document Imaging
- Printers and Scanners
- Images and Photos
- Photos / Graphics Software
- GIMP
- Document Management, *Scripts, *tiff, *batch
Attackers love to prey on accounts that have privileges.
Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Suggested Courses
Course of the Month3 days, 10 hours left to enroll
751 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.