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