protected void BindGrid()
 {
     try
     {
         objBE.Action    = "R";
         objBE.statecode = state;
         objBE.Dept      = Department;
         dt = ObjDL.Equipment_IUDR(objBE, con);
         if (dt.Rows.Count > 0)
         {
             GvLabs.DataSource = dt;
             GvLabs.DataBind();
         }
         else
         {
             GvLabs.DataSource = null;
             GvLabs.DataBind();
         }
     }
     catch (Exception ex)
     {
         ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString());
         ObjCommon.ShowAlertMessage(ex.ToString());
     }
 }
    protected void BindGrid()
    {
        try
        {
            objBE.statecode    = Session["StateCode"].ToString();
            objBE.Dept         = Session["Department"].ToString();
            objBE.CatId        = Session["Category"].ToString();
            objBE.Action       = "R";
            objBE.SampleTypeId = ddlSampType.SelectedValue;

            dt = ObjDL.Equipment_IUDR(objBE, con);
            if (dt.Rows.Count > 0)
            {
                GvEquipment.DataSource = dt;
                GvEquipment.DataBind();
                divequipment.Visible = true;
            }
            else
            {
                GvEquipment.DataSource = null;
                GvEquipment.DataBind();
                cf.ShowAlertMessage("No Data");
                divequipment.Visible = false;
            }
        }
        catch (Exception ex)
        {
            ExceptionLogging.SendExcepToDB(ex, Session["UsrName"].ToString(), Request.ServerVariables["REMOTE_ADDR"].ToString());
            cf.ShowAlertMessage(ex.ToString());
        }
    }