SqlBulkCopy Tutorial - Knowledge Base (KB)

How to insert null value for numeric field of a datatable in c#?

Consider My dynamically generated datatable contains the following fileds ...Id,Name,Mob1,Mob2...If my datatable has this it get inserted successfully,...Id Name Mob1 Mob2 1 acp 9994564564 9568848526 ...But when it is like this it gets failed sa...

Fast inserts; BulkCopy with relational data

I have a large amount of constantly incoming data (roughly 10,000 a minute, and growing) that I want to insert into a database as efficiently as possible. At the moment I'm using prepared insert statements, but am thinking of using the SqlBulkCopy class t...

Copying data from table1 to table2, with slightly different datatypes, names and additional column

Im running a task where i need to copy data from ...table1... to ...table2.... ...table1... is generated from a very old application which has a tendency of creating unusual datatypes, such as decimal etc. (these are unnecessary). ...So the structures are...

Update / Insert to SQL table using datatable with column mappings

I'm wanting to do a bulk copy of data from one database to another. It needs to be dynamic enough so that when the users of the source database create new fields, there are minimal changes at the destination end(my end!). ...I've done this using the ...sq...