怎样才能取得一张表中所有的字段？/

[zldjp]

请教高手

[wangzs79]

select 方法只能得到字段的名字而已，不能得到字段的约束等信息

[TheAres]

using System;
using System.Data;
using System.Data.OleDb;


string ConnectionString = @"Provider=Microsoft.Jet.OleDB.4.0;Data Source=C:\Program Files\Microsoft Office\Office\1033\FPNWIND.mdb";
OleDbConnection conn = new OleDbConnection(ConnectionString);
conn.Open();

DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
foreach (DataRow dr in schemaTable.Rows)
{
//表名
Console.WriteLine(dr["TABLE_NAME"]);

//字段名
DataTable columnTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,
new object[] {null, null, dr["TABLE_NAME"].ToString(),null});


foreach(DataRow dr2 in columnTable.Rows)
{
Console.WriteLine(" {0}", dr2["COLUMN_NAME"]);
}

}
conn.Close();
}

[rouser]

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
}

[dahuzizyd]

private void Form1_Load(object sender, System.EventArgs e)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mcTest.MDB";
string strSQL = "SELECT * FROM Developer" ;

// 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 );
}

[firejie]

select * from table

[hzhxxx]

可以根据数据库后台的 统表，得到你的