public void DashBoard() { try { DataTable dt = new DataTable(); dt = objRptDL.DashBoardCount_CntryDAL(Session["ConnStr"].ToString()); try { lblFinYear.Text = dt.Rows[0]["FinYear"].ToString() == "" ? "0" : dt.Rows[0]["FinYear"].ToString(); } catch { } lblNewReg.Text = dt.Rows[0]["NewReg"].ToString() == "" ? "0" : dt.Rows[0]["NewReg"].ToString(); lblRevist.Text = dt.Rows[0]["ReVisit"].ToString() == "" ? "0" : dt.Rows[0]["ReVisit"].ToString(); lblTotEnrollments.Text = dt.Rows[0]["Insutionsenrolled"].ToString() == "" ? "0" : dt.Rows[0]["Insutionsenrolled"].ToString(); lblTotalValueofdrug.Text = dt.Rows[0]["ValueOfDrugs"].ToString() == "" ? "0" : dt.Rows[0]["ValueOfDrugs"].ToString(); lblDayIns.Text = dt.Rows[0]["DayIns"].ToString() == "" ? "0" : dt.Rows[0]["DayIns"].ToString(); lblMnthIns.Text = dt.Rows[0]["MnthIns"].ToString() == "" ? "0" : dt.Rows[0]["MnthIns"].ToString(); lblYearIns.Text = dt.Rows[0]["YearIns"].ToString() == "" ? "0" : dt.Rows[0]["YearIns"].ToString(); lblDayNewR.Text = dt.Rows[0]["DayNewR"].ToString() == "" ? "0" : dt.Rows[0]["DayNewR"].ToString(); lblMnthNewR.Text = dt.Rows[0]["MnthNewR"].ToString() == "" ? "0" : dt.Rows[0]["MnthNewR"].ToString(); lblYearNewR.Text = dt.Rows[0]["YearNewReg"].ToString() == "" ? "0" : dt.Rows[0]["YearNewReg"].ToString(); lblDayRV.Text = dt.Rows[0]["DayRV"].ToString() == "" ? "0" : dt.Rows[0]["DayRV"].ToString(); lblMnthRV.Text = dt.Rows[0]["MnthRV"].ToString() == "" ? "0" : dt.Rows[0]["MnthRV"].ToString(); lblYearRV.Text = dt.Rows[0]["YearReVisit"].ToString() == "" ? "0" : dt.Rows[0]["YearReVisit"].ToString(); lblDayI.Text = dt.Rows[0]["DayI"].ToString() == "" ? "0" : dt.Rows[0]["DayI"].ToString(); lblMnthI.Text = dt.Rows[0]["MnthI"].ToString() == "" ? "0" : dt.Rows[0]["MnthI"].ToString(); lblYearI.Text = dt.Rows[0]["YearValueOfDrugs"].ToString() == "" ? "0" : dt.Rows[0]["YearValueOfDrugs"].ToString(); } catch (Exception ex) { Response.Redirect("~/Error.aspx"); } }