private static void UseFileWithSemicolon() { string connStr = ConnectionStringManager.MakeExcel(@"C:\twork\ReAlign\Sample Test Files\invalid file with;semicolon.xml", null, null, true, false); ConnectionStringManager csm = new ConnectionStringManager(); csm.ConnectionString = connStr; Console.WriteLine("cs=" + csm.ConnectionString); }
private static void ParseConnectionStringTest() { string connStr = ConnectionStringManager.MakeExcel(@"c:\f=oo;ba'r.xls", null, null, true, false); var result = ConnectionStringParser.Parse(connStr); foreach (var item in result) { Console.WriteLine("[{0}] = [{1}]", item.Key, item.Value); } }
System.Data.DataSet IFileConverter.Import(string filename) { string connectionString = null; if (Options.Provider == "Microsoft.ACE.OLEDB.12.0") { connectionString = ConnectionStringManager.MakeExcel2007(filename, Options.Username, Options.Password, Options.UseHeader, true); } else { connectionString = ConnectionStringManager.MakeExcel(filename, Options.Username, Options.Password, Options.UseHeader, true); } //if (OpenTableBy == "POSITION") //{ // OpenTableByPosition(connectionString); //} return(Common.OleDbTables(connectionString, Tablename, Options.TableFilter)); }
private void UpdateTableList() { switch (InputDataSource) { case InputDataSourceType.File: if (FileSupportsTables(Filename)) { switch (GetFileExtension(Filename)) { case "MDB": Provider = DatabaseProvider.OleDb; ConnectionString = ConnectionStringManager.MakeAccess(Filename, null, null, true); break; case "XLS": Provider = DatabaseProvider.OleDb; ConnectionString = ConnectionStringManager.MakeExcel(Filename, null, null, true, true); break; case "XLSX": Provider = DatabaseProvider.OleDb; ConnectionString = ConnectionStringManager.MakeExcel2007(Filename, null, null, true, true); break; default: throw new ArgumentException("File extension not supported: " + Filename); } GetTableListing(Provider, ConnectionString); } break; case InputDataSourceType.Database: GetTableListing(Provider, ConnectionString); break; default: throw new ArgumentOutOfRangeException("InputDataSource=" + InputDataSource); } }
public void TestConnectionStringWithEqualAndSemicolonChar() { // Arrange string connStr = ConnectionStringManager.MakeExcel(@"c:\f=oo;ba'r.xls", null, null, true, false); Assert.AreEqual(connStr, "Provider=\"Microsoft.Jet.OLEDB.4.0\"; Data Source=\"c:\\f=oo;ba'r.xls\"; user id=\"admin\"; password=\"\"; Extended Properties=\"Excel 8.0; HDR=Yes; IMEX=1\";"); // Act var result = ConnectionStringParser.Parse(connStr); foreach (var item in result) { Console.WriteLine("[{0}] = [{1}]", item.Key, item.Value); } // Assert Assert.AreEqual(result["Provider"], @"Microsoft.Jet.OLEDB.4.0"); Assert.AreEqual(result["Data Source"], @"c:\f=oo;ba'r.xls"); Assert.AreEqual(result["user id"], @"admin"); Assert.AreEqual(result["password"], @""); Assert.AreEqual(result["Extended Properties"], @"Excel 8.0; HDR=Yes; IMEX=1"); Assert.AreEqual(result.Count, 5); }