access»ñÈ¡×Ö¶ÎÃû - .NET¼¼Êõ / ASP.NET

ÔÚasp.netÖУ¬ÈçºÎͨ¹ý³ÌÐò»ñÈ¡accessÊý¾Ý¿âÖеÄ×Ö¶ÎÃû¡£ÎҵıíÃûÊǹ̶¨µÄ£¡
ÄܸøÎÒÍêÕû´úÂëÂ𣿻òÊÇ°¸Àý¡£¡£¡£

---

°Ù¶È£º¡¡C# access ×Ö¶ÎÃû

---

SQL code:
select name from syscolunms where object_id=object_id('yourtablename') order by colid

---

//...
//1µÚ¼¸ÁÐ
string fd_name = myDataSet.Tables["Table_name"].Columns[1].Caption;

---

ÒýÓÃ

SQL code
select name from syscolunms where object_id=object_id('yourtablename') order by colid

Õâ¸öÔÚaccessÖв»ºÃÓÃ

---

upupupupup

---

DataTable dt;
  private OleDbConnection conn;
conn = new OleDbConnection("Á¬½ÓÊý¾Ý¿â");
  conn.Open();
  conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new Object[] { null, null, TableName, null });
   
 
  for(int i=0;i<dt.Rows.Count;i++)
  {
  dt.Rows[0]["COLUMN_NAME"].ToString();
   
}
   
 

---

ÊÔÊÔ...

---

.......................

---

111111

---

oledb 連½Ó·½Ê½
¿ÉÒÔÓÃ
SqlConnection µÄGetOleDbSchemaTable·½·¨來獲È¡ËùÓеıíÃû
10樓ÒÑ經給³