// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter( strSQL, myConn );
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );//如果动态连接sql数据库的话,加上使用OleDataAdapter的FillSchema方法。
DataTable dt = dtSet.Tables[0];
listBox1.Items.Add("Field Name DataType Unique AutoIncrement AllowNull");
listBox1.Items.Add("==================================================================");
foreach( DataColumn dc in dt.Columns )
{
listBox1.Items.Add(dc.ColumnName+" , "+dc.DataType +" ,"+dc.Unique +" ,"+dc.AutoIncrement+" ,"+dc.AllowDBNull );
}
SqlDataAdapter da = new SqlDataAdapter("SELECT TOP 1 * FROM 表名",數據鏈接)
DataTable dt = new DataTable();
da.Fill(dt);
// 然後枚舉所有的列即可
foreach(DataColumn dc in dt.Columns)
{
// get field name by dc.ColumnName property
}