Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

VB.net Dynamic Windows Form that adapts to SQL Table changes

Hi

I would like to try to build a dynamic Windows form that loads controls for any
SQL table and adapts to changes made to the tables. Has anyone ever tried or asked this sort
of question before?
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
What kind of controls?! I guess some sort of grid for the tables, right?! What exactly do you mean with
adapts to changes made to the tables

Basically, this shouldn't be too difficult at all.
My "mind list" would be something like this:
- first get all relevant SQL tables by iterating over the "system tables" to get the info
- then take the components of your choice (e.g. datasetzs or whatever) and dynamically add them to your main window (e.g. through reflection if neccessary/suitable)
- using data binding on e.g. DataChanged (-> DataSource) and your window forms/controls should keep the data up to date
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks for the advice
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now