public static void InsertDt <T>(ref T dtInput, string tableName)
where T : DataTable
{
SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(connString);
DataTable tmptable = dtInput;
if (tmptable.Rows.Count > 0)
{
bulkInsert.DestinationTableName = tableName;
bulkInsert.WriteToServer(tmptable);
}
dtInput.Clear();
bulkInsert.Close();
bulkInsert.Dispose();
tmptable.Dispose();
}
public static void InsertFromTARIF()
{
foreach (var item in TarifDataTable)
{
InfTariff infTariff = FillInfTarifItem(item);
FilltmpInfTarifDetRow(ref infTariff);
}
SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(connString);
DataTable tmpInfTariff = InfTariffDataTable;
if (tmpInfTariff.Rows.Count > 0)
{
bulkInsert.DestinationTableName = "infTariff";
bulkInsert.WriteToServer(tmpInfTariff);
}
bulkInsert.Close();
bulkInsert.Dispose();
tmpInfTariff.Dispose();
}
public static void InsertFromTARIF()
{
foreach (var item in TarifDataTable)
{
InfTariff infTariff = FillInfTarifItem(item);
FilltmpInfTarifDetRow(ref infTariff);
}
SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(connString);
DataTable tmpInfTariff = InfTariffDataTable;
if (tmpInfTariff.Rows.Count > 0)
{
bulkInsert.DestinationTableName = "infTariff";
bulkInsert.WriteToServer(tmpInfTariff);
}
bulkInsert.Close();
bulkInsert.Dispose();
tmpInfTariff.Dispose();
}