protected void btnGo_OnClick(object sender, EventArgs e) { try { LogBl objLogBl = new LogBl(); DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); //var objResult = objLogBl.SugarsyrpReport(dtFromDateTime, dtToDateTime); var objResult = objLogBl.SweetMilkReport(dtFromDateTime, dtToDateTime); if (objResult.ResultDt.Rows.Count > 0) { gvSweetMilk.DataSource = objResult.ResultDt; gvSweetMilk.DataBind(); divExport.Visible = divExport.Visible = true; gvSweetMilk.Visible = false; for (int i = 0; i < gvSweetMilk.Rows.Count; i++) { TextBox txt = (TextBox)gvSweetMilk.Rows[i].FindControl("txtQtySugar"); txt.Text = objResult.ResultDt.Rows[i]["QtyOfSugarSyrup"].ToString(); } } else { divExport.Visible = false; //divRecord.Visible = true; } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }