using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) { bulkCopy.DestinationTableName = "dbo.MatchingColumnsTableName"; try { bulkCopy.WriteToServer(sourceDataTable); } catch { throw; } }
Regards, Sheo Narayan http://www.dotnetfunda.com
Login to post response