VB.NET Database DesignView

[thowle]

Is there any simple way I can create a Design View for a Table in VB.NET..
For an example of what I need is in Microsoft Access.. when you create a new
table, is has the field name, data type, description, etc.

How can I do this in VB.NET, a datagrid and make my own data collection
(That will be harder than I wish ;)).

Are there any possibly 3rd part controls of this type.

[Bernie Yaeger]

Hi,

You can use information_schema to get such information into a
dataset/datatable; then simply bind it to a datagrid. Here's an example:

select * from information_schema.columns where table_name = 'a_rsumtable'

HTH,

Bernie Yaeger

"thowle" <th****@brtc.net> wrote in message
news:4D**********************************@microsof t.com...

Is there any simple way I can create a Design View for a Table in
VB.NET..
For an example of what I need is in Microsoft Access.. when you create a
new
table, is has the field name, data type, description, etc.

How can I do this in VB.NET, a datagrid and make my own data collection
(That will be harder than I wish ;)).

Are there any possibly 3rd part controls of this type.

[thowle]

Well, I mean I know how to get the information but what Im trying to do is
exactly whats in Enterprise Manager, or Access. Im making a utility to
essentially create a table, and want a nice little control like in Access.

"Bernie Yaeger" wrote:

Hi,

You can use information_schema to get such information into a
dataset/datatable; then simply bind it to a datagrid. Here's an example:

select * from information_schema.columns where table_name = 'a_rsumtable'

HTH,

Bernie Yaeger

"thowle" <th****@brtc.net> wrote in message
news:4D**********************************@microsof t.com...

Is there any simple way I can create a Design View for a Table in
VB.NET..
For an example of what I need is in Microsoft Access.. when you create a
new
table, is has the field name, data type, description, etc.

How can I do this in VB.NET, a datagrid and make my own data collection
(That will be harder than I wish ;)).

Are there any possibly 3rd part controls of this type.