Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
5
Answers
Invalid attempt to call Read when reader is closed
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Gaurav Bhandari
11y
5.8k
1
Reply
I got "
Invalid attempt to call Read when reader is closed
"
error. How i resolve it ?
string fetch_isbn = "Select rc.cartdetail_isbn,rc.cartdetail_qty,sb.quantity as old_qty From rt_cartdetail as rc join sell_book as sb on sb.product_id = rc.cartdetail_isbn where rc.cartdetail_cartid='" + Session["cart_pid"] + "'";
SqlCommand objcmd_ISBN = new SqlCommand(fetch_isbn, objconn);
objconn.Open();
{
SqlDataReader reader_isbn = (SqlDataReader)objcmd_ISBN.ExecuteReader();
if (reader_isbn != null && reader_isbn.HasRows)
{
while (reader_isbn.Read())
{
string isbn = reader_isbn["cartdetail_isbn"].ToString();
int qty = Convert.ToInt32(reader_isbn["cartdetail_qty"]);
int old_qty = Convert.ToInt32(reader_isbn["old_qty"]);
int new_qty = 0;
new_qty = old_qty - qty;
reader_isbn.NextResult();
// objconn.Close();
string update_sellqty = "Update sell_book set quantity = '" + new_qty + "' where product_id='" + isbn + "'";
SqlCommand objcmd_update_sellqty = new SqlCommand(update_sellqty, objconn);
//objconn.Open();
objcmd_update_sellqty.ExecuteNonQuery();
// objconn.Close();
}
}
}
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
web service
C# replace characters