private void GetDepartments()
    {
        objDept = new clsDept1();
        DataSet ds = objDept.GetDeptID();

        ddlDept.DataSource     = ds.Tables[0];
        ddlDept.DataTextField  = "DeptName";
        ddlDept.DataValueField = "DepartmentId";
        ddlDept.DataBind();
        ddlDept.Items.Insert(0, "--Select One--");
    }
    private void GetDesignation()
    {
        objDept = new clsDept1();
        DataSet ds = objDept.GetDesignation();

        Cache["DesgData"]      = ds;
        ddlDesg.DataSource     = ds.Tables[0];
        ddlDesg.DataTextField  = "Desg_Name";
        ddlDesg.DataValueField = "DesignationId";
        ddlDesg.DataBind();
        ddlDesg.Items.Insert(0, "--Select One--");
    }