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