读取表的属性:
using System;
using System.Data;
using System.Data.OleDb;
class TestADO
{
static void Main(string[] args)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\test.mdb";
string strSQL = "SELECT * FROM employee" ;
OleDbConnection conn = new OleDbConnection(strDSN);
OleDbDataAdapter cmd = new OleDbDataAdapter( strSQL, conn );
conn.Open();
DataSet ds = new DataSet();
cmd.Fill( ds, "employee" );
DataTable dt = ds.Tables[0];
Console.WriteLine("Field Name DataType Unique AutoIncrement AllowNull");
Console.WriteLine("==================================================================");
foreach( DataColumn dc in dt.Columns )
{
Console.WriteLine(dc.ColumnName+" , "+dc.DataType +" ,"+dc.Unique +" ,"+dc.AutoIncrement+" ,"+dc.AllowDBNull );
}
conn.Close();
}
}
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。