protected void JqgridHomeTeam_DataRequesting(object sender, JQGridDataRequestEventArgs e) { var teamHomeMatchList = ThaitaeDataDataContext.Create().TeamMatches.Where(item => item.MatchId == Convert.ToInt32(e.ParentRowKey) && item.TeamHome == 1).ToList(); JqgridHomeTeam.DataSource = teamHomeMatchList; JqgridHomeTeam.DataBind(); }
protected void JqgridAwayPlayer_DataRequesting(object sender, JQGridDataRequestEventArgs e) { List <PlayerMatch> playerTeamList; using (var dc = ThaitaeDataDataContext.Create()) { int teamMatchid = Convert.ToInt32(e.ParentRowKey); var team = dc.TeamMatches.Single(item => item.TeamMatchId == teamMatchid); playerTeamList = ThaitaeDataDataContext.Create().PlayerMatches.Where( item => item.TeamId == team.TeamId && item.MatchId == team.MatchId && item.SeasonId == team.SeasonId).ToList(); } JqgridAwayPlayer.DataSource = playerTeamList; JqgridAwayPlayer.DataBind(); }