Error: There is no row at position 0

Question

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.

Manav Pandya · Answer

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

Manav Pandya · Answer

Hello Try to use below sequence : DataTable dt = new DataTable(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) // cmd is SqlCommand object { da.Fill(dt); } Thanks

Manav Pandya · Answer

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

Ravindra Singh · Answer

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) );

pratik pangire · Answer

@manav pandey Noop, not working can you check my code through Teamviewer or refer any code for addtocart.

pratik pangire · Answer

@manav pandya Da is filling datatable but datatable remains empty

pratik pangire · Answer

@manay pandya how can i check datatable is filling the required row or not