private void BindGrid() { ChallanDelverdDAL obj = new ChallanDelverdDAL(); Int32 iTocityIdno = (drpToCity.SelectedIndex <= 0 ? 0 : Convert.ToInt32(drpToCity.SelectedValue)); string UserClass = Convert.ToString(Session["Userclass"]); Int32 UserIdno = 0; if (UserClass != "Admin") { UserIdno = Convert.ToInt32(Session["UserIdno"]); } DataSet DsDetl = obj.SearchDelevryRegisterReport(Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text)), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text)), iTocityIdno, Convert.ToInt32(ddlDateRange.SelectedValue), UserIdno, ApplicationFunction.ConnectionString()); if ((DsDetl != null) && (DsDetl.Tables[0].Rows.Count > 0)) { Double TotalNetAmountLocGRAmnt = 0; Double TotalNetAmountCrsngGRAmnt = 0; Double TotalNetAmount = 0; for (int i = 0; i < DsDetl.Tables[0].Rows.Count; i++) { TotalNetAmountLocGRAmnt += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["LocGR_Amnt"]); TotalNetAmountCrsngGRAmnt += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["CrsngGR_Amnt"]); TotalNetAmount += Convert.ToDouble(DsDetl.Tables[0].Rows[i]["Net_Amnt"]); } lblNetTotalAmountLocGRAmnt.Text = TotalNetAmountLocGRAmnt.ToString("N2"); lblNetTotalAmountCrsngGRAmnt.Text = TotalNetAmountCrsngGRAmnt.ToString("N2"); lblNetTotalAmount.Text = TotalNetAmount.ToString("N2"); ViewState["CSVdt"] = DsDetl.Tables[0]; grdMain.DataSource = DsDetl.Tables[0]; grdMain.DataBind(); imgBtnExcel.Visible = true; lblTotalRecord.Text = "Total Record (s): " + DsDetl.Tables[0].Rows.Count; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + DsDetl.Tables[0].Rows.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); imgBtnExcel.Visible = false; lblTotalRecord.Text = "Total Record (s): 0 "; lblcontant.Visible = false; divpaging.Visible = false; } }