public static void ImportDataTableTest()
{
PFSQLAnywhereUL db = new PFSQLAnywhereUL();
string connectionString = string.Empty;
try
{
_msg.Length = 0;
_msg.Append("ImportDataTableTest started ...");
Program._messageLog.WriteLine(_msg.ToString());
db.DatabasePath = _frm.txtDatabaseFile.Text;
db.DatabaseName = _frm.txtDatabaseName.Text;
db.Username = _frm.txtUsername.Text;
db.Password = _frm.txtPassword.Text;
db.DatabaseKey = _frm.txtDatabaseKey.Text;
connectionString = db.ConnectionString;
db.OpenConnection();
StringBuilder sql = new StringBuilder();
//first delete table if it already exists
string tabName = "KeyValTable";
if (db.TableExists(tabName))
{
bool dropped = db.DropTable(tabName);
if (dropped == false)
{
_msg.Length = 0;
_msg.Append("Unable to drop table ");
_msg.Append(tabName);
throw new DataException(_msg.ToString());
}
else
{
_msg.Length = 0;
_msg.Append("\r\n");
_msg.Append(tabName);
_msg.Append(" dropped.");
Program._messageLog.WriteLine(_msg.ToString());
}
}
Program._messageLog.WriteLine("\r\nCreating a table in the database ...");
//create the table
DataTable dt = _frm.keyValsDataSet.Tables["KeyValTable"];
DataColumn dc = dt.Columns[0];
dt.PrimaryKey = new DataColumn[] { dc };
db.CreateTable(dt);
db.CloseConnection();
db.OpenConnection();
db.ImportDataFromDataTable(dt, 1000);
db.CloseConnection();
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
Program._messageLog.WriteLine(_msg.ToString());
AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
}
finally
{
_msg.Length = 0;
_msg.Append("... ImportDataTableTest finished.");
Program._messageLog.WriteLine(_msg.ToString());
}
}