static void Main(string[] args) { //Variable definition var connectionString = "Data Source=172.16.0.6;Initial Catalog=AO2017;Persist Security Info=True;User ID=sa;Password=BQ3$ervice"; var generalFilePath = @"\\canydocs\archives\Users\Missing Dates Report\"; var reportName = "RFP"; var fileName = reportName.Replace(" ", "_") + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".csv"; var filePath = generalFilePath + reportName + @"\" + fileName; var selectStatement = @"EXECUTE dbo.Missing_Dates_RFP_Report"; //Execution start //Instansiate a new SqlActions object var sqlActions = new SqlActions(connectionString); //Execute the selectStatement and store the results in a list of strings var dt = sqlActions.SelectToDataTable(selectStatement); //Create file to write to File.Create(filePath).Dispose(); //Instansiate a new DataTableExtensions object var dataTableExtensions = new DataTableExtensions(); //Write the data from the data table to the file dataTableExtensions.WriteToCsvFile(dt, filePath); }
static void Main() { //Variable definition var connectionString = "Data Source=172.16.0.6;Initial Catalog=AO2017;Persist Security Info=True;User ID=sa;Password=BQ3$ervice"; var generalFilePath = @"\\canydocs\archives\Users\BVI Reports\Team Billing Reports\"; List <string> teamList = new List <string>(); teamList.Add("Team Red"); teamList.Add("Team Blue"); teamList.Add("Team Green"); teamList.Add("Team Silver"); teamList.Add("Black Team"); teamList.Add("Team Platinum"); teamList.Add("Team Magenta"); teamList.Add("Team White"); teamList.Add("Misc"); foreach (var team in teamList) { var reportName = "BVA - " + team; var fileName = reportName.Replace(" ", "_") + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".csv"; var filePath = generalFilePath + team + @"\" + fileName; var selectStatement = @"EXECUTE dbo.Budget_vs_Actual_Report '" + team + "'"; //Execution start //Instansiate a new SqlActions object var sqlActions = new SqlActions(connectionString); //Execute the selectStatement and store the results in a list of strings var dt = sqlActions.SelectToDataTable(selectStatement); //Create file to write to File.Create(filePath).Dispose(); //Instansiate a new DataTableExtensions object var dataTableExtensions = new DataTableExtensions(); //Write the data from the data table to the file dataTableExtensions.WriteToCsvFile(dt, filePath); } }