来自「C语言操作ADO数据库 这些操作是对一个微软Access 2000数据库进行的」· 代码 · 共 14 行

ArrayList result = new ArrayList();
				OleDbConnection myConn=new OleDbConnection(this.ConnectionString);
				myConn.Open();
				OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM Customer",myConn);
				OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
				DataSet thisDataSet=new DataSet();
				thisAdapter.Fill(thisDataSet,"Customer");
				DataTable myTable=thisDataSet.Tables["Customer"];
				foreach(DataColumn myCol in myTable.Columns)
				{
					result.Add(myCol.ColumnName.ToString());
				}
				myConn.Close();	
				return result;