Mapping columns in a DataTable to a SQL table with SqlBulkCopy

by

You probably need some thing like 

 public void BatchBulkCopy(DataTable dataTable, string DestinationTbl, int batchSize)
{
    // Get the DataTable 
    DataTable dtInsertRows = dataTable;

    using (SqlBulkCopy sbc = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity))
    {
        sbc.DestinationTableName = DestinationTbl;

        // Number of records to be processed in one go
        sbc.BatchSize = batchSize;

        // Add your column mappings here
        sbc.ColumnMappings.Add("field1","field3");
        sbc.ColumnMappings.Add("foo","bar");

        // Finally write to server
        sbc.WriteToServer(dtInsertRows);
    }    
}

Ref: How to use SqlBulkCopyColumnMappingCollection?
.
.

Seel also http://www.codeproject.com/Articles/18418/Transferring-Data-Using-SqlBulkCopy

More Related Contents:

  1. Read SQL Table into C# DataTable
  2. Get an IDataReader from a typed List
  3. Any way to SQLBulkCopy “insert or update if exists”?
  4. Sql Bulk Copy/Insert in C#
  5. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  6. Search SQL by date ASP.NET
  7. How can I add user-supplied input to an SQL statement?
  8. How to get last inserted id?
  9. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  10. How to select distinct rows in a datatable and store into an array
  11. Export DataTable to Excel with EPPlus
  12. C# SQL Server – Passing a list to a stored procedure
  13. linq case statement
  14. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  15. SQL WHERE clause matching values with trailing spaces
  16. Equivalent of SQL ISNULL in LINQ?
  17. Check if value exists in dataTable?
  18. Simple way to copy or clone a DataRow?
  19. How to fill Dataset with multiple tables?
  20. SqlConnection.Close() inside using statement
  21. Passing a SQL parameter to an IN() clause using typed datasets in .NET
  22. ASP.NET ODBC Query with parameters
  23. SqlBulkCopy Insert with Identity Column
  24. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  25. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  26. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  27. How to Read text file to DataTable [closed]
  28. Stored procedure returns int instead of result set
  29. Is it possible to format a date column of a datatable?
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment