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");
        }
    }