Database Schema and Property Grid.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings.
I am trying to use the PropertyGrid Control to display database schema.
So far so good. The property grid control displays the database field
properties in the property grid.
My Question is:
How do I change/alter the actual database architecture (say change a field
type from double to text when I change the values in the property grid.).
Any help would be much appreciated.

Mark
 
Mark - it really depends on how you've set things up. Ultimately, I think
you're going to need to write some DDL to handle the Alter table stuff
 
Mark,

Does this means that your are creating an updater for MSDE or something?

There are on the net when you search for that with Google already a lot.
That before you are inventing the wheel again.

Otherwise it is just creating an Exe with command.executenonquery and the
proper SQL commands.

I hope this helps.

Cor
 
¤
¤
¤ Greetings.
¤ I am trying to use the PropertyGrid Control to display database schema.
¤ So far so good. The property grid control displays the database field
¤ properties in the property grid.
¤ My Question is:
¤ How do I change/alter the actual database architecture (say change a field
¤ type from double to text when I change the values in the property grid.).
¤ Any help would be much appreciated.

It depends upon the database. Not every database supports the same method (or SQL DDL dialect) for
performing this task.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top