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
hades5k
NA
1
0
Updating database from dataset
Mar 18 2004 9:18 AM
I have a problem using DataTable, DataSet with database (winform). In the apps, users will add new vendor in a form. On the same form (while adding the details for the vendor) the can add skills specific for that vendor in a listview. Now it's time to save everything in the database (SQL Server). The vendor-code must be unique. I could open the connection, compare code, insert vendor, find a way to return identity, then add the vendor-specific skills. Would it be easier to insert the record in a master/child datatable and I-dont-know-how-to update the database from there, considering that the user value for code must be unique? And HOW?? Oh god HOW?? : ) My real problem is that I don't know how to efficiently use DataSet, DataTable with database. Here's the tables : VENDOR ------ (identity) vendor_id (char) vendor_name (char) vendor_email VENDORSKILL ----------- (identity) vendorskill_id (int) vendor_id (char) vendorskill_name (char) vendorskill_description Thanx alot!! Chris
Reply
Answers (
1
)
N-Unit testing for winforms
Adding apostrophes to a record section