如何从数据库里挑出所有table的名称? vb.net:schemaTable = dataConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) '得到全部的用户表,用户表类型为Table,进行过虑 DataGrid2.DataSource = schemaTable DataGrid2.DataBind() 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://www.csdn.net/Develop/read_article.asp?id=20501 帮助里的: 以下示例返回数据库中的表的列表。public DataTable GetTables(OleDbConnection conn){ conn.Open(); DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"}); conn.Close(); return schemaTable;} public static void ReadMyData(string myConnString) { string mySelectQuery = "SHOW TABLES"; OdbcConnection myConnection = new OdbcConnection(myConnString); OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection); myConnection.Open(); OdbcDataReader myReader = myCommand.ExecuteReader(); try { while (myReader.Read()) { Console.WriteLine(myReader.GetValue(0)); } } finally { // always call Close when done with connection. myReader.Close(); // always call Close when done with connection. myConnection.Close(); } } 正则表达式~~ 做silverlight3 RIA 与linq to sql的查询的问题 数据库数据 有什么办法改变鼠标状态 int x= Convert.ToInt32(a) - Convert.ToInt32(b); 各位大虾,求救。。。 水晶报表里使用程序脚本的问题~ ‘生命’垂危的呼唤 关于dataGrid的问题 大家都来啊,如何解决这样的矛盾? 用C#做浏览器,用什么控件 打开一个 .aspx 的文件,为什么看不到,网页的设计页面?
以下示例返回数据库中的表的列表。public DataTable GetTables(OleDbConnection conn)
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
conn.Close();
return schemaTable;
}
{
string mySelectQuery = "SHOW TABLES";
OdbcConnection myConnection = new OdbcConnection(myConnString);
OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
myConnection.Open();
OdbcDataReader myReader = myCommand.ExecuteReader();
try
{
while (myReader.Read())
{
Console.WriteLine(myReader.GetValue(0));
}
}
finally
{
// always call Close when done with connection.
myReader.Close();
// always call Close when done with connection.
myConnection.Close();
}
}