VB.NET Database DesignView

[Guest]

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

 

[Guest]

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.