如何获取ACCESS数据库中一张表里的所有字段名

jyayay 2012-06-02 08:40:56

...全文

401 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

jyayay 2012-06-02

打赏
举报

access不能用这个吧？

qq120848369 2012-06-02

打赏
举报

describe xxx

jyayay 2012-06-02

打赏
举报

有没有SQL语句能直接得到指定表里所有的字段名呢？

W170532934 2012-06-02

打赏
举报



#include   <conio.h>  



  #define   PAUSE   printf("\npress   any   key   to   exit");   getch();  



   



  #define   _WIN32_DCOM  



   



  #pragma   warning(push)  



  #pragma   warning(disable:4146)  



  #import   "e:\program   files\common   files\system\ado\MSADO15.DLL"   no_namespace   rename("EOF",   "EndOfFile")  



  #pragma   warning(pop)  



   



  int   main(int   argc,   char*   argv[])  



  {  



  _ConnectionPtr   m_pConn;  



  _RecordsetPtr   m_pRs;  



  CoInitializeEx(NULL,   COINIT_MULTITHREADED);  



  _bstr_t   bstrConnStr   =   "Provider=Microsoft.Jet.OLEDB.4.0;"  



  "Data   Source=F:\\lylong\\db1.mdb;Persist   Security   Info=False";  



  try{  



  m_pConn.CreateInstance(   __uuidof(Connection)   );  



  m_pRs.CreateInstance(   __uuidof(Recordset)   );  



  m_pConn->Open(   bstrConnStr,   "",   "",   adConnectUnspecified   );  



  m_pRs->Open(   "table1",    



  m_pConn.GetInterfacePtr(),   adOpenForwardOnly,   adLockOptimistic,   adCmdTable);  



   



  long   lColumn   =   m_pRs->Fields->Count;  



  printf("%-12s%-10s%-10s\n",   "字段名",   "长度",   "类型");  



  for(   long   i=0;   i<lColumn;   i++   )  



  {  



  printf("%-12s%-10d%-10d\n",   (char*)m_pRs->Fields->Item[i]->Name,    



  m_pRs->Fields->Item[i]->DefinedSize,  



  m_pRs->Fields->Item[i]->Type);  



  }  



   



  m_pRs->Close();  



  m_pConn->Close();  



  }catch(   _com_error   e   )  



  {  



  printf(   "\n%s   Error:   %ld\r\n"  



  "%s\r\n"  



  "%s\r\n",  



  (char*)e.Source(),  



  e.Error(),  



  (char*)e.Description(),  



  (char*)e.ErrorMessage()   );  



  m_pRs->Close();  



  m_pConn->Close();  



  }  



  CoUninitialize();  



  PAUSE;  



  return   0;  



  }