void FilePathButtonClick(object sender, EventArgs e) { var location = SetFolderLocation(); if (location == "") return; foreach (var fileName in FlatFileReader.GetAllFileNames(location)) { var gStandardReader = new GStandardSchemaReader(location, fileName); var name = fileName + "_" + gStandardReader.GetName(); var columnInfos = gStandardReader.GetFlatFileColumnInfo(); using (var sqlBulkImport = new SqlBulkImport("Server=localhost;Database=GStandDb;Trusted_Connection=True;")) { var dt = sqlBulkImport.CreateTable(name); sqlBulkImport.CreateColumns(dt, columnInfos); FlatFileReader.ReadFlatFileInToDataset(Path.Combine(location, fileName), dt, name, columnInfos); sqlBulkImport.ImportTable(dt, name); } } }
private void button1_Click(object sender, EventArgs e) { if (folderBrowserDialog.ShowDialog() == DialogResult.OK) { this.folderLocationLabel.Text = folderBrowserDialog.SelectedPath; } string tempPath = folderBrowserDialog.SelectedPath; foreach (string fileName in FlatFileReader.GetAllFileNames(tempPath)) { var gStandardReader = new GStandardSchemaReader(tempPath, fileName); var name = gStandardReader.GetName(); var columnInfos = gStandardReader.GetFlatFileColumnInfo(); using (var sqlBulkImport = new SqlBulkImport("Server=localhost;Database=testdb2;Trusted_Connection=True;")) { var dt = sqlBulkImport.CreateTable(name); sqlBulkImport.CreateColumns(dt, columnInfos); FlatFileReader.ReadFlatFileInToDataset(Path.Combine(tempPath, fileName), dt, name, columnInfos); sqlBulkImport.ImportTable(dt, name); } } }