Saving Dynamically generated DataSets to the SQL Server Database

See more:

VB

Hi Everyone,

My project to Generate Dynamic Forms for Microsoft SQL Server 2008 Catalogs is just about finished. The problem I now have to solve is: "How do I update the database from a specific dataset?"

My application generates a tab page containing all necessary controls and places them onto a Table Layout Panel control. Each tab page contains a binding navigator control and a binding source control, which in turn binds specific controls to specific columns(fields) of the database table. This allows the binding navigator control to function.

My problem comes from the fact that whenever I generate a new tab page a new dataset is generated for that table. For example: In my Northwind database I can generate tab pages for both the Employees and Products tables. My form will show tab pages for both of them and I can make changes to the dataset in each without any problems.

Here is the noggin scratcher: The binding navigator control and the Save button on it are generated dynamically for each tab page . I need some way to distinguish the Employees dataset from the Products dataset when the Save button is press so the proper table on the database gets updated.

Does anyone have any idea how this can be done? I have searched the Internet and couldn't find anything remotely similar to my problem.

Thanks in advance,
MRM256