public static void ImportDataTableTest(MainForm frm)
{
PFDB2 db = new PFDB2();
string connectionString = string.Empty;
try
{
_msg.Length = 0;
_msg.Append("ImportDataTableTest started ...");
Program._messageLog.WriteLine(_msg.ToString());
db.ServerName = frm.txtServerName.Text;
db.DatabaseName = frm.txtDatabaseName.Text;
db.PortNumber = frm.txtPortNumber.Text;
db.Username = frm.txtUsername.Text;
db.Password = frm.txtPassword.Text;
connectionString = db.ConnectionString;
db.OpenConnection();
StringBuilder sql = new StringBuilder();
DataTable dt = frm.keyValsDataSet.Tables["Mike.KeyValTable"];
string tableName = dt.TableName;
//first delete table if it already exists
Program._messageLog.WriteLine("\r\nDropping old table if it exists ...");
if (db.TableExists(tableName))
{
bool dropped = db.DropTable(tableName);
if (dropped == false)
{
_msg.Length = 0;
_msg.Append("Unable to drop table ");
_msg.Append(tableName);
throw new DataException(_msg.ToString());
}
}
Program._messageLog.WriteLine("\r\nCreating a table in the database ...");
//create the table
db.CreateTable(dt);
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());
}
}