protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string objIdParam = Request["id"]; if (!string.IsNullOrEmpty(objIdParam)) { int objectId = 0; if (int.TryParse(objIdParam, out objectId)) { ClubDTOHelper clubDTOHelper = new ClubDTOHelper(); try { DataItem = clubDTOHelper.GetFromDB(objectId); if (DataItem.Logo != null) { iClubLogo.ImageUrl = PathHelper.GetMultimediaWebPath(this, DataItem.Logo); } } catch (Exception ex) { //logger } SearchParameters.Match searchParam = new SearchParameters.Match(); searchParam.Club_Id = objectId; ml.DataBind(searchParam); using (UaFootball_DBDataContext db = DBManager.GetDB()) { IEnumerable <vGamesByPlayerByTeam> playersForClub = db.vGamesByPlayerByTeams.Where(d => d.IsNational == 0 && d.PlayedFor == objectId).OrderByDescending(d => d.TotalMatches).ThenByDescending(d => d.TotalMinutes); rptPlayers.DataSource = playersForClub; rptPlayers.DataBind(); } } } } }