In a windows form I want to insert some data.
How do I get selected data from tblTest into tblTest2.
Both databases are on the same server.
I need the stored procedure code and the execut code from the form

DB1
tblTest
TestID Identity Specification NO
Test nvarchar(50)
Dato datetime
Belop money

DB2
tblTest2
TestID int Identity spec yes, increment 1, seed 1
Test nvarchar(50)
Test2 nvarchar(50)
Kundenr int
Ordredato datetime
MvaGrunnlag money
Vaar_Ref nvarchar(50)

thanks
Reidar

Hi there,

This is an ASP.NET forum, so I am not sure I understand why you're posting a win forms question.

Also, this is a Pro forum, so some work from your side is likely to be expected before people reply here. What have you tried so far? What code works and what doesn't? Did you get any errors?

The better your question (e.g. relevant forum, relevant content, detailed problem description and demonstration of things you've already tried), the better the answers you get....

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!