public void DataBindEx()
        {
            DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_SingleProject_BLL();
            string strwhere = "";

            if (Common.Session.GetSession("SuperAdmin").ToLower() == "true")
            {
                strwhere = " Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'";
            }
            else
            {
                strwhere  = "SingleProjectID in (select SingleProjectID from t_singleprojectuser where roleid=" + Common.Session.GetSession("RoleId") + ") ";
                strwhere += "And Area_Code like '" + ConvertEx.ToString(Session["AREA_CODE"]) + "%'";
            }
            DataSet list1 = bll.GetList(strwhere);

            DropDownList1.DataTextField  = "gcmc";
            DropDownList1.DataValueField = "SingleProjectID";
            DropDownList1.DataSource     = list1;
            DropDownList1.DataBind();
        }