Last post Sep 26, 2009 11:41 AM by ganaparthi
Nov 18, 2005 11:42 AM|Nilee|LINK
Nov 18, 2005 02:52 PM|Caddre|LINK
Jan 31, 2009 11:30 AM|izharulislam|LINK
The code for doing SQLBulkcopy is given below.
objCopy.BulkCopyTimeout = 30;
objCopy.BatchSize = 1000;
objCopy.NotifyAfter = 100;
Jan 31, 2009 11:34 AM|izharulislam|LINK
Since the tables are same at both ends i would suggest you to do it in this way.
if you are using SQL server and the server for both database is same then
insert into DatabaseA..table1 select * from DatabaseB.table1
Sep 26, 2009 11:41 AM|ganaparthi|LINK
Hi i have a doubht.
i want to insert multiple rows at a time into database table.(sqlserver) from c# code.
normally we are inserting one row at a time trough sqlcommand.
is there any method to insert entire table of rows at a time into datatable.
hope iam clear.
thanks in advance