Friday, December 2, 2011

Using SqlBulkCopy from datatable in .NET

Using SqlBulkCopy from datatable in .NET

Using copy As New SqlBulkCopy(Conn.Connection, SqlBulkCopyOptions.Default, Conn.Transaction)
                copy.ColumnMappings.Add("Column2", "PMO_PartNo")
                copy.ColumnMappings.Add("Column4", "PMO_Part_Name")
                copy.DestinationTableName = "PMS_MIG_Part_Master_Upload_Original"
                copy.WriteToServer(dt1)
End Using



No comments:

Post a Comment