Copying data from datatable to SQL Server

Question

I want to copy data from a DataTable to a SQL Server table; how can I achieve it please help.

Answer 1

You can copy data from a DataTable to a SQLServer Database using SQLServer Management Objects and SqlBulkCopy.

You can also try SqlDataAdapter to Update the data into the database.