public void fillSite()
{
iUCCommonFilterClient UCCommonFilter = new iUCCommonFilterClient();
CustomProfile profile = CustomProfile.GetProfile();
ddlFrmSite.DataSource = UCCommonFilter.GetSiteNameByUserID_Transfer(profile.Personal.UserID, profile.DBConnection._constr);
ddlFrmSite.DataBind();
ListItem lstfrm = new ListItem();
lstfrm.Text = "--Select--";
lstfrm.Value = "0";
ddlFrmSite.Items.Insert(0, lstfrm);
iUCCommonFilterClient objService = new iUCCommonFilterClient();
List <vGetUserProfileByUserID> UsersList = new List <vGetUserProfileByUserID>();
UsersList = objService.GetUserListBySiteID(1, profile.DBConnection._constr).ToList();
UsersList = UsersList.Distinct().ToList();
vGetUserProfileByUserID select = new vGetUserProfileByUserID()
{
userID = 0, userName = "******"
};
UsersList.Insert(0, select);
ddlTransferedBy.DataSource = null;
ddlTransferedBy.DataBind();
ddlTransferedBy.DataSource = UsersList;
ddlTransferedBy.DataBind();
}