• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

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?
0
Meinhoonaa
Asked:
Meinhoonaa
1 Solution
 
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
 
Big MontySenior 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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now