TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Wynand Vermaak
1.6k
111
709
Stored Procedure
Dec 9 2018 11:30 AM
Hi there
I am new to software development and have a test project I am working on. I have been trying to create a sql stored procedure and C# to insert data into a header table and a detail table. I need to be able to save multiple rows in the detail table which must be linked to a single header row id as per the picture below. The stored procedure I have created works but only saves one line in the header table and one in the detail table. As soon as I add a second line in the listview on my C# windows form and save it, it generates a id for the first row and another id for the second line.
Reply
Answers (
4
)
How to raise an Opinion Poll?
Different Types of Indexes and how we use them in Sql?