/// <summary>
/// WriteToOutTable deletes the table named in the outTableName param
/// then creates and inserts and new table with the name given.
/// </summary>
/// <param name="table">The DataTable that will be copied to the database.</param>
/// <param name="outTableName">The name of the new table to be persised</param>
private void WriteToOutTable(DataTable table, string outTableName)
{
if (!string.IsNullOrEmpty(outTableName))
{
if (this.Context.CurrentRead != null)
{
if (DBReadExecute.CheckDatabaseTableExistance(this.Context.CurrentRead.File, outTableName))
{
DBReadExecute.ExecuteSQL(this.Context.CurrentRead.File, "Delete From " + outTableName);
DBReadExecute.ExecuteSQL(this.Context.CurrentRead.File, "Drop Table " + outTableName);
}
DBReadExecute.ExecuteSQL(this.Context.CurrentRead.File, DBReadExecute.GetCreateFromDataTableSQL(outTableName, table));
DBReadExecute.InsertData(this.Context.CurrentRead.File, "Select * from " + outTableName, table.CreateDataReader());
}
}
}
public bool OutTable(System.Data.DataTable pDataTable)
{
bool result = false;
try
{
if (DBReadExecute.CheckDatabaseTableExistance(DBReadExecute.ParseConnectionString(this.mContext.CurrentRead.File), pDataTable.TableName))
{
DBReadExecute.ExecuteSQL(this.mContext.CurrentRead.File, "Delete From [" + pDataTable.TableName + "]");
DBReadExecute.ExecuteSQL(this.mContext.CurrentRead.File, "Drop Table [" + pDataTable.TableName + "]");
}
DBReadExecute.ExecuteSQL(this.mContext.CurrentRead.File, DBReadExecute.GetCreateFromDataTableSQL(pDataTable.TableName, pDataTable));
DBReadExecute.InsertData(this.mContext.CurrentRead.File, "Select * from [" + pDataTable.TableName + "]", pDataTable.CreateDataReader());
result = true;
}
catch (Exception e)
{
// do nothing for now
}
return(result);
}
