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);
}
