How to avoid the foreach loop

See more:

C#

Hi,

I am having a gridview in that gridview there are 10,000 records are there. The user will select all the 10,000 and click on confirm button. I will update the confirmid for that each row as Y and save it in database. By using the foreach loop I am doing the process so its taking so much of time to update some times the browser gets freezed or else I am getting the Timed out error. How to avoid this situation is there any way to update the row without the foreach loop. Here is my code:

private bool Confirm()
 {
     var result = from GridViewRow msgRow in grdPrice.Rows
                  where ((CheckBox)msgRow.FindControl("chkSelect")).Checked
                  select grdPrice.Rows[msgRow.RowIndex];
     obj = new ProductMasterInfo();
     DataTable dtPrice;
     string res = string.Empty;
     if (ViewState["UploadNo"] != null)
     {
         dtPrice = obj.GetEditData("P", ViewState["UploadNo"].ToString());
         foreach (GridViewRow row in result)
         {
             string refNo = (row.Cells[iTemp].FindControl("hfReferenceNo") as HiddenField).Value;
             DataRow[] dr = dtPrice.Select("ReferenceNo='" + refNo + "'");
             dr[0]["ConfirmId"] = "Y";
             dr[0]["UpdateId"] = SessionVarriables.UserIdSession;
             dr[0]["UpdateDate"] = DateTime.Now.ToString();
         }
          res = obj.UpdateDataByUploadNo(dtPrice, "P", ViewState["UploadNo"].ToString());
     }
     else
     {
         UserUtil.Message("No Data Uploaded", this.Page);
     }
     return isSaved(res);
 }

Thanks