how to display a table in a grid when its name is selectd from another grid

Question

hai i am working on an application where i connect to a database and list the tables available in it in a datagridview. now from these listed tables when a user selects a table i want the description and content of the table to be displayed in seperate gridviews.... please help me i am new to vb.net

mathu mathi · Answer

hai Santosh thank u very much it works .. thanks a lot

Santhosh Rajan · Answer

sorry for being late...but its late than never right...? okay anyways when u select a table name from first grid use this query SELECT COLUMN_NAMEDATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=' ' Replace with the table name from selected row in first grid hope this will help let me know if it didnt

mathu mathi · Answer

i have the list of tables in one datagrid when a table is selected i need the description that is field name and its data type displayed in other datagrid

Santhosh Rajan · Answer

What all description of table (like coloumnsits data typelength identity etc) do u needed..?