Add a C# DataTable's data into an existing MSSQL Table

Asked Jun 26 '13 at 17:45

Active Jun 26 '13 at 17:45

Viewed 196 times

I am wondering if there is a way to write a c# DataTable's data into an existing Microsoft SQL database table.

In my code, I have imported an Excel sheet into a DataTable. I would like to add the contents of the DataTable to an existing SQL table. Is there an easy way to do this?

I found this stack question (How to insert a data table into SQL Server database table?) that sort of touches on what I would like to do.

Or do I need to run the DataTable through a loop and insert each row of data through code?

Thanks in advance for your help.

edited May 23 '17 at 12:21

Community

asked Jun 26 '13 at 17:45

ThaKidd KG5ORD

1,535
3
24
38

1

See http://stackoverflow.com/questions/9075159/how-to-insert-a-data-table-into-sql-server-database-table, which is identical to this question. – Nathan Dace Jun 26 '13 at 18:04
PocketDews: You are right. I looked at the code wrong. That is exactly what I need to do. – ThaKidd KG5ORD Jun 26 '13 at 20:18

Add a C# DataTable's data into an existing MSSQL Table

0 Answers0