Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL VB.NET
hi
Is it possible to load tables in datagridview and open selected table in another datagridview just like opening a selected table using combobox? I got the sql statement that displays list of tables with other schema information in sql server compact.I want to try it with ms access database .
any help would be appreciated
 Dim Query2 As String = " Select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'TABLE'"  
Posted 18-Feb-13 21:27pm
ronjit264
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Thank you for quick response .I will try it out
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Yes ...
Select * from INFORMATION_SCHEMA.TABLES where table_name like 'E%'
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 339
1 Maciej Los 208
2 George Jonsson 144
3 Kornfeld Eliyahu Peter 139
4 Dave Kreskowiak 130


Advertise | Privacy | Mobile
Web04 | 2.8.140709.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid