Updating database from dataset
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