protected void btnDeleteReview_Click(object sender, EventArgs e) { for (int i = 0; i < gvReviews.Rows.Count; i++) //Input Validation to make sure one and only one checkbox is selected { CheckBox cb; cb = (CheckBox)gvReviews.Rows[i].FindControl("cbSelect"); if (cb.Checked) { amountchecked = amountchecked + 1; } } if (amountchecked < 1 || amountchecked > 1) { lblMessage.Text = "Please Select only one restaurant to work with at a time."; } else { for (int i = 0; i < gvReviews.Rows.Count; i++) //If all conditions are good pull the information from the one selected { CheckBox cb; cb = (CheckBox)gvReviews.Rows[i].FindControl("cbSelect"); if (!cb.Checked) { continue; } else { UserFunctions uf = new UserFunctions(); string restaurantname = gvReviews.Rows[i].Cells[1].Text; string restaurantaddress = gvReviews.Rows[i].Cells[2].Text; string review = gvReviews.Rows[i].Cells[5].Text; int restaurantID = uf.GetRestaurantID(restaurantname, restaurantaddress); UserObject user; user = (UserObject)Session["User"]; string username = user.username; if (uf.DeleteReviewDB(username, restaurantID, review) > 0) { lblMessage.Text = "Success. You have deleted that review"; DBConnect objDB = new DBConnect(); String strSQL = "SELECT Reviews.Review, Reviews.PriceRating, Reviews.QualityRating, Restaurant.Name, Restaurant.Address FROM Reviews JOIN Restaurant ON Reviews.RestaurantID=Restaurant.RestaurantID WHERE Username='******'"; DataSet myDS = objDB.GetDataSet(strSQL); gvReviews.DataSource = myDS; gvReviews.DataBind(); } else { lblMessage.Text = "Error. Please try again."; } } } } }