Error: There is no row at position 0

pratik pangire

HI, i am currently working on a project, when i run the program, there is an error showing on button click event It says this:

Exception Details: System.IndexOutOfRangeException: There is no row at position 0.

protected void btnAddCart_Click(object sender, EventArgs e)
{
if (Session["Mycart"] == null)
{
ShoppingCart Mycart = new ShoppingCart();
Session["Mycart"] = Mycart;
}
string Id = Request.QueryString["BookID"];
Mycart =(ShoppingCart)Session["New"];
String Query = "select * from BookData where BookID= '" + Id + "'";
SqlCommand cmd = new SqlCommand(Query, con);
SqlDataAdapter Da = new SqlDataAdapter(cmd);
DataTable Dt = new DataTable();
Da.Fill(Dt);
DataRow row = Dt.Rows[0];
Mycart.Insert(new CartItem(Int32.Parse(Id),
row["name"].ToString(),
row["author"].ToString(),
int.Parse(row["isbn"].ToString()),
row["language"].ToString(),
row["publisher"].ToString(),
row["Summary"].ToString(),
Double.Parse(row["price"].ToString()),
1)
);
}

Please reply fast, its very urgent

thank you.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

pratik pangire8y ago
@manav pandey Noop, not working can you check my code through Teamviewer or refer any code for addtocart.
0
Manav Pandya8y ago
Hello

Try to use below sequence :
DataTable dt = new DataTable();
using (SqlDataAdapter da = new SqlDataAdapter(cmd)) // cmd is SqlCommand object
{
    da.Fill(dt);
}
Thanks
+1
pratik pangire8y ago
@manav pandya Da is filling datatable but datatable remains empty
0
Manav Pandya8y ago
Hello

Just put debug point at : Da.Fill(Dt);

than check that Da is filling details of datatable and also check that DataTables remain empty or not

Try to do R & D than let me know the result

Thanks
+1
pratik pangire8y ago
@manay pandya how can i check datatable is filling the required row or not
0
Ravindra Singh8y ago
if (Dt.Tables[0].Rows.Count > 0)
{
Mycart.Insert(new CartItem(Int32.Parse(Id),
row["name"].ToString(),
row["author"].ToString(),
int.Parse(row["isbn"].ToString()),
row["language"].ToString(),
row["publisher"].ToString(),
row["Summary"].ToString(),
Double.Parse(row["price"].ToString()),
1)
);
+1
Manav Pandya8y ago
Hello

Its showing error because you are using data but columns are empty, i mean there is no row found in DataAdapter

Solution is to put debug point at line : SqlDataAdapter Da = new SqlDataAdapter(cmd);

Make sure that datatable is filling the required row or not

Thats what the problem is i think

One more change :

do not convert directly ToString() -> use Convert.toString(), because it handles if value is null

Let me know if you need any help

Thanks
+1