Line 93: var data = db.Query("SELECT Players.FirstName, Players.Surname, Bowling.Overs, Bowling.Maidens, Bowling.Runs, Bowling.Wickets, Bowling.Average, Bowling.BestWickets, Bowling.BestRuns, Bowling.Economy FROM Bowling INNER JOIN Players ON Players.ID = Bowling.PlayerID WHERE Team= @0 AND Season= @1 AND League=@2 ORDER BY Average 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();
|