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