Line 93: var data = db.Query("SELECT Players.FirstName, Players.Surname, Batting.Innings, Batting.Not_Out, Batting.Runs, Batting.Highest_Score , Batting.Average FROM Batting INNER JOIN Players ON Players.ID = Batting.PlayerID WHERE Team= @0 AND Season= @1 AND League=@2 ORDER BY Runs DESC", team, season, leagueSQL, cupSQL, innsSQL);
Line 94: //var data = db.Query("SELECT Date, Time, Opposition, Location, Format, PutneyScore, PutneyWickets, OppositionScore, OppositionWickets, Result, Points, Toss FROM Fixtures WHERE Team = @0 AND Year(Date)=@1 ORDER BY DATE", team, season);
Line 95: var columns = data.First().Columns;
Line 96:
Line 97: var doc = new Document();
|