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);
}
