public void UploadTableInSqlServer(DataTable dataTable, string connectionString,
string destinationNameTable = "",
int timeout = 100)
{
if (destinationNameTable == "")
{
destinationNameTable = dataTable.TableName;
}
ImportTable importTable = new ImportTable(dataTable, connectionString, destinationNameTable, timeout);
ImporterInSqlServer.UploadTableInSqlServer(importTable);
}
private void ImportBySheduller(object importTable)
{
ImportTable _importTable = (ImportTable)importTable;
try
{
_scheduler.Enter(_importTable);
try
{
ImporterInSqlServer.UploadTableInSqlServer(_importTable);
}
finally
{
_scheduler.Done();
}
}
catch (Exception e)
{
int i;
//throw new AbandonedMutexException();
}
}
private void ImportWithoutSheduller(object importTable)
{
ImportTable _importTable = (ImportTable)importTable;
ImporterInSqlServer.UploadTableInSqlServer(_importTable);
}
