using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient ; using System.Data.SqlTypes; DataSet myDataSet=new DataSet();
SqlConnection SQLCN = new SqlConnection("server=你的服务器;database=你的数据库;uid=sa;pwd=");SqlDataAdapter dsCMD; dsCMD =new SqlDataAdapter("select name from sysobjects where xType='u'", SQLCN);SQLCN.Open(); dsCMD.Fill(myDataSet,"myDataSet");string table1=myDataSet.Tables[0].Rows[0][0].ToString(); //这是第一个表string table2=myDataSet.Tables[0].Rows[1][0].ToString(); //这是第二个表string table3=myDataSet.Tables[0].Rows[2][0].ToString(); //这是第三个表......
数据库连接就不用说了吧? 连接好用如下SQL语句 SqlDataAdapter vAdapter = new SqlDataAdapter("select * from DBName.dbo.sysobjects where xtype = 'U',数据库连接); DataTable vTable = new DataTable(""); vAdapter.Fill(vTable); ,现在数据库“DBName”中所有的用户表都在VTABLE里了:)
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient ;
using System.Data.SqlTypes;
DataSet myDataSet=new DataSet();
SqlConnection SQLCN = new SqlConnection("server=你的服务器;database=你的数据库;uid=sa;pwd=");SqlDataAdapter dsCMD;
dsCMD =new SqlDataAdapter("select name from sysobjects where xType='u'", SQLCN);SQLCN.Open();
dsCMD.Fill(myDataSet,"myDataSet");string table1=myDataSet.Tables[0].Rows[0][0].ToString(); //这是第一个表string table2=myDataSet.Tables[0].Rows[1][0].ToString(); //这是第二个表string table3=myDataSet.Tables[0].Rows[2][0].ToString(); //这是第三个表......
连接好用如下SQL语句
SqlDataAdapter vAdapter = new SqlDataAdapter("select * from DBName.dbo.sysobjects where xtype = 'U',数据库连接);
DataTable vTable = new DataTable("");
vAdapter.Fill(vTable);
,现在数据库“DBName”中所有的用户表都在VTABLE里了:)