hades5k

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

Answers (1)