how to insert records from datatable to sql database using visual studio 2012

how to insert records from datatable to sql database using visual studio 2012?
MeinhoonaaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
here's a good tutorial that'll walk you through the steps on doing this:

http://www.codeproject.com/Articles/30722/How-to-save-data-from-a-DataSet-into-a-T-SQL-table
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>insert records from datatable to sql database
Q1:  Why does this have to be done with Visual Studio, and which application in Visual Studio are we talking?
Q2:  Are these databases on the same server?
  If yes, You can create a Stored Procedure that does this, referencing both databases, and execute it.  Then the SP can be called from wherever.
  If no, then you'll need an ETL tool such as SSIS, which is part of the Visual Studio suite, to move the data.
0
 
MeinhoonaaAuthor Commented:
I am using sql data client
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.