/// <summary>
/// 取得所有表
/// </summary>
private ArrayList GetTables_ADONET()
{
ArrayList TabelNameList = new ArrayList();
//处理OleDbConnection
string strConnectionString = @"Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=CTI_Mast;Data Source=192.168.18.230,1544/sql2008";
OleDbConnection cn = new OleDbConnection(strConnectionString);
cn.Open();
//利用OleDbConnection的GetOleDbSchemaTable来获得数据库的结构
DataTable dt = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow dr in dt.Rows)
{
TabelNameList.Add(Row[0]);
}
}