private static void GETDBDATA() { Database.DBConnect DB = new Database.DBConnect("", "", "", ""); List <string[]> List = new List <string[]>(); List.AddRange(DB.ExecuteQuery("Dataset", "SELECT Sum(`Contributers`),Sum(`Commits`),Sum(`Forks`),Sum(`Branches`),Sum(`Watchers`),Sum(`PullRequests`),Sum(`TotalIssues`),Sum(`OpenIssues`),Sum(`ReleaseCounts`) FROM `Dataset` WHERE `Language`=\"C\";")); List.AddRange(DB.ExecuteQuery("Dataset", "SELECT Sum(`Contributers`),Sum(`Commits`),Sum(`Forks`),Sum(`Branches`),Sum(`Watchers`),Sum(`PullRequests`),Sum(`TotalIssues`),Sum(`OpenIssues`),Sum(`ReleaseCounts`) FROM `Dataset` WHERE `Language`=\"PHP\";")); List.AddRange(DB.ExecuteQuery("Dataset", "SELECT Sum(`Contributers`),Sum(`Commits`),Sum(`Forks`),Sum(`Branches`),Sum(`Watchers`),Sum(`PullRequests`),Sum(`TotalIssues`),Sum(`OpenIssues`),Sum(`ReleaseCounts`) FROM `Dataset` WHERE `Language`=\"Java\";")); List.AddRange(DB.ExecuteQuery("Dataset", "SELECT Sum(`Contributers`),Sum(`Commits`),Sum(`Forks`),Sum(`Branches`),Sum(`Watchers`),Sum(`PullRequests`),Sum(`TotalIssues`),Sum(`OpenIssues`),Sum(`ReleaseCounts`) FROM `Dataset` WHERE `Language`=\"JavaScript\";")); List.AddRange(DB.ExecuteQuery("Dataset", "SELECT Sum(`Contributers`),Sum(`Commits`),Sum(`Forks`),Sum(`Branches`),Sum(`Watchers`),Sum(`PullRequests`),Sum(`TotalIssues`),Sum(`OpenIssues`),Sum(`ReleaseCounts`) FROM `Dataset` WHERE `Language`=\"HTML\";")); string Text = "Sum(`Contributers`)\tSum(`Commits`)\tSum(`Forks`)\tSum(`Branches`)\tSum(`Watchers`)\tSum(`PullRequests`)\tSum(`TotalIssues`)\tSum(`OpenIssues`)\tSum(`ReleaseCounts`)\n"; foreach (string[] Lines in List) { foreach (string Num in Lines) { Text += Num + "\t\t\t"; } Text += "\n"; } File.WriteAllText("00.txt", Text); }