在Combobox中获取所选数据库的表名 [英] Get table names of selected database in Combobox

问题描述

我有两个组合框，在一个组合框中我现在获得sqlserver的所有数据库名称当我从组合框中选择任何数据库时我想在第二个组合框中显示与该数据库相关的所有表格。



i我正在使用此查询但它不起作用



SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA ='+ cmbdatabase.Text.Trim （）+'



请帮助我.....

解决方案

尝试连接到数据库并使用：

  SELECT  TABLE_NAME 
  FROM  INFORMATION_SCHEMA.TABLES 
  WHERE  TABLE_TYPE = '  BASE TABLE' 

或者不指定数据库连接中的DB：

  USE  yourDBName;  SELECT  name  FROM  sys.Tables 

< blockquote>尝试以下方法 -

USE+ cmbdatabase.Text.Trim（）+; SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES< br /> 

i have two combobox, in one combobox i am getting all databases name of sqlserver now when i select any database from combobox i want to show all tables related to that database in second combobox.

i am using this query but it is not working

"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA ='" + cmbdatabase.Text.Trim() + "'"

please help me.....

解决方案

Try connecting to the DB and using:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'

Alternatively without specifying the DB in teh connection:

USE yourDBName; SELECT name FROM sys.Tables

Try the following -

"USE " + cmbdatabase.Text.Trim() + "; SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"<br />

这篇关于在Combobox中获取所选数据库的表名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！