Got an error on while (reader_isbn.Read()) Second times when while loop execute.. Can any one help me out from this problem ?
string fetch_isbn = "Select * From rt_cartdetail where cartdetail_cartid='" + Session["cart_pid"] + "'";
SqlCommand objcmd_ISBN = new SqlCommand(fetch_isbn, objconn);
objconn.Open();
{
//CommandBehavior.CloseConnection
SqlDataReader reader_isbn = (SqlDataReader)objcmd_ISBN.ExecuteReader(CommandBehavior.CloseConnection);
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"]);
reader_isbn.NextResult();
objconn.Close();
//Response.Redirect(isbn);
string fetch_sell_book_details = "Select * From sell_book where product_id='" + isbn + "'";
SqlCommand objcmd_sell_book_details = new SqlCommand(fetch_sell_book_d ...
Go to the complete details ...