public void fillSite() { string sid; iUserCreationClient UserCreationClient = new iUserCreationClient(); CustomProfile profile = CustomProfile.GetProfile(); sid = UserCreationClient.GetTerritoryID_FromUserId(profile.Personal.UserID, profile.DBConnection._constr); ddlSite.DataSource = UserCreationClient.GetSiteNameFromId(sid, profile.DBConnection._constr); ddlSite.DataBind(); ListItem lst1 = new ListItem(); lst1.Text = "Select All"; lst1.Value = "0"; ddlSite.Items.Insert(0, lst1); }