as i understand ... the best solution is the BulkCopy
ex:
public void BulkCopy()
{
dt = (DataTable)Session["lstCars"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("TRUNCATE TABLE carsForSale", connection);
connection.Open();
cmd.ExecuteNonQuery();
SqlBulkCopy bulkObj = new SqlBulkCopy(connection);
bulkObj.DestinationTableName = "carsForSale";
bulkObj.WriteToServer(dtUsers);
connection.Close();
}
}
best regards