public formMain() { this.InitializeComponent(); this.dsnManager = new OdbcDataSourceManager(); this.dsnList = this.dsnManager.GetAllDataSourceNames(); this.populateDSNDropdown(); this.connection = new OdbcConnectionManager(); this.dataTable = new DataTable(); }
private static void Main(string[] args) { if (args.Length != 5) { if ((args.Length != 5) && (args.Length != 0)) { showUsage(); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new formMain()); } else { OdbcDataReader reader2; string dsn = args[0]; string username = args[1]; string password = args[2]; string path = args[3]; string str5 = args[4]; OdbcConnectionManager manager = new OdbcConnectionManager(dsn, username, password); StreamReader reader = new StreamReader(path); OdbcCommand command = new OdbcCommand(reader.ReadLine(), manager.cnn); DataTable table = new DataTable(); try { reader2 = command.ExecuteReader(); } catch (Exception exception) { Cursor.Current = Cursors.Default; MessageBox.Show("Error executing command\n\n" + exception.Message); return; } try { table.Load(reader2); } catch (OutOfMemoryException) { MessageBox.Show("Error: Out of memory", "NetTools: ODBCBrowse", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } StreamWriter writer = new StreamWriter(str5); string str7 = ""; foreach (DataColumn column in table.Columns) { writer.Write(str7); if (column.ColumnName.Contains(",") || column.ColumnName.Contains("\"") || column.ColumnName.Contains("\n")) { writer.Write("\""); writer.Write(column.ColumnName.Replace("\"", "\"\"").Replace("\r", " ").Replace("\n", " ")); writer.Write("\""); } else { writer.Write(column.ColumnName); } str7 = ","; } writer.WriteLine(); ExportProgress progress = new ExportProgress(); progress.updateProgressMin(1); progress.updateProgressMax(table.Rows.Count); progress.Show(); int num = 1; foreach (DataRow row in table.Rows) { str7 = ""; foreach (object obj2 in row.ItemArray) { writer.Write(str7); if (obj2.ToString().Contains(",") || obj2.ToString().Contains("\"") || obj2.ToString().Contains("\n")) { writer.Write("\""); writer.Write(obj2.ToString().Trim().Replace("\"", "\"\"").Replace("\r", " ").Replace("\n", " ")); writer.Write("\""); } else { writer.Write(obj2.ToString().Trim()); } str7 = ","; } writer.WriteLine(); progress.updateProgressBar(num); num++; } writer.Close(); } }