Our Training Programs

All contents are copyright of their authors.

Copy Data From One Table To Another using SqlBulkCopy

Copy Data From One Table To Another using SqlBulkCopy

Vinod Sharma

12yAsked Sep 26, 2014, 1:39 AM1.9k.NET

Hi Sir

I Want to copy data from one table to another using mapping function. Suppose i have product Info Table having some fields ProductCode, name etc....

Now i want to copy this data to another table if i have same Product Code to another table then data should be update......

If any suggession then tell me . I Have to do it from SqlBulkCopy Method...

Thanks In Advance

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Vinod Sharma12y ago
I Want to copy data from one table to another using mapping function. Suppose i have product Info Table having some fields ProductCode, name etc....
Now i want to copy this data to another table if i have same Product Code to another table then data should be update......

Is there Anybody Plz Help Me to do this task
Rajesh Pathakoti12y ago
HI,
Please go through the below link

http://geekswithblogs.net/AzamSharp/archive/2005/07/18/47597.aspx
Omid Nasri12y ago
Hi Mr sharma
You can see example in this link :

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(v=vs.110).aspx

this link help you for work with SqlBulkCopy class in C# and show all function and propertis of this class