private void BinddepartDropList(int adviserId)
        {
            CommonLookupBo commonLookup     = new CommonLookupBo();
            DataSet        dsDepartmentlist = new DataSet();

            dsDepartmentlist         = commonLookup.GetDepartment(adviserId);
            ddlDepart.DataSource     = dsDepartmentlist.Tables[0];
            ddlDepart.DataTextField  = dsDepartmentlist.Tables[0].Columns["AD_DepartmentName"].ToString();
            ddlDepart.DataValueField = dsDepartmentlist.Tables[0].Columns["AD_DepartmentId"].ToString();
            ddlDepart.DataBind();
            ddlDepart.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
        }