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

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Mark" <(E-Mail Removed)> wrote in message
news:6138B4B3-ED4A-4BE3-A406-(E-Mail Removed)...
>
>
> 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,

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

On Sun, 20 Feb 2005 11:13:02 -0800, "Mark" <(E-Mail Removed)> wrote:

¤
¤
¤ 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 Removed)
Microsoft MVP (Visual Basic)