有什么办法能够枚举数据表的列

Question

要求不限制数据源(无论数据库是access,sqlserver,oracle等）...

Answer 1

1. try ADODB.Connection object's OpenSchema method:http://msdn.microsoft.com/library/en-us/ado270/htm/pg_ado_programming_6.asp?frame=true2. or use ADOX library, seeCorrect Column Ordinals of an ADOX Table Object
http://www.codeproject.com/database/adoxcolumnordinal.asp?print=true

Answer 2

记得是
HRESULT GetColumnInfo( ULONG* pulColumns, DBCOLUMNINFO** ppColumnInfo, LPOLESTR* ppStrings ) const;
HRESULT GetColumnInfo( ULONG* pColumns, DBCOLUMNINFO** ppColumnInfo ); 
没用过。

Answer 3

_RecordsetPtr& pSrc;// some recordset
long lFieldCount=pSrc->Fields->GetCount();
for(long i=0;i<lFieldCount;i++)
{
FieldPtr pField = pSrc->Fields->Item[i];
DataTypeEnum datatype = pField->Type;

}