Copy Data From One Table To Another using SqlBulkCopy

Question

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

Omid Nasri · Answer

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

Vinod Sharma · Answer

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 Pathakoti · Answer

HI, Please go through the below link http://geekswithblogs.net/AzamSharp/archive/2005/07/18/47597.aspx

Copy Data From One Table To Another using SqlBulkCopy

Answers (3)