/// summary /// 取 所有 表名 /// /summary /// returns/returns public Liststring GetTableNameList() { Liststring list = new Liststring(); OleDbConnection Conn = new OleDbConnection(ConnStr); try { if (Conn.State == ConnectionState.Closed) C
/// <summary>
/// 取<strong><strong>所有</strong></strong>表名
/// </summary>
/// <returns></returns>
public List<string> GetTableNameList()
{
List<string> list = new List<string>();
OleDbConnection Conn = new OleDbConnection(ConnStr);
try
{
if (Conn.State == ConnectionState.Closed)
Conn.Open();
DataTable dt = Conn.GetSchema("Tables");
foreach (DataRow row in dt.Rows)
{
if (row[3].ToString() == "TABLE")
list.Add(row[2].ToString());
}
return list;
}
catch (Exception e)
{ throw e; }
finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); }
}
/// <summary>
/// 取<strong>指定</strong>表<strong><strong>所有</strong></strong><strong>字段名</strong>称
/// </summary>
/// <returns></returns>
public List<string> GetTableFieldNameList(string TableName)
{
List<string> list = new List<string>();
OleDbConnection Conn = new OleDbConnection(ConnStr);
try
{
if (Conn.State == ConnectionState.Closed)
Conn.Open();
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.CommandText = "SELECT TOP 1 * FROM [" + TableName + "]";
cmd.Connection = Conn;
OleDbDataReader dr = cmd.ExecuteReader();
for (int i = 0; i <br>
</string></string></string></string></string></string>
