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