读取表的属性: 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(); } } |
|