Access 如何获取字段名

[帝国队长]

Access数据库如何通过表名来获取字段名，就是SQL语句，再不然用ADO连接数据库后，如何获取呀

[zxhx]

这里有：
http://blog.csdn.net/zyq5945/archive/2010/04/29/5541280.aspx

[zwfgdlc]

	_stprintf_s(szQuery, _countof(szQuery), TEXT("select id_usernum, id_idcard,id_name from userinfo where id_idcard='%s'"), szidCard);
	try
	{
		AdoRst = AdoConn->Execute(szQuery, NULL, adConnectUnspecified);
	}catch(_com_error &e)
	{
		MessageBox(e.Description(), e.ErrorMessage(), MB_ICONERROR);
		CoUninitialize();
		return;
	}
	
	CString s;
	try
	{
		for (long i=0; i<AdoRst->Fields->Count; i++)
		{
			s.Format(TEXT("字段%d:%s"), i, (TCHAR*)AdoRst->Fields->Item[i]->Name);
			MessageBox(s);
		}
	}
	catch(_com_error &e)
	{
		MessageBox(e.Description(), e.ErrorMessage());
	}

[帝国队长]

问题解决了
m_pConn.CreateInstance( __uuidof(Connection) );

m_pRs.CreateInstance( __uuidof(Recordset) );

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

m_pRs->Open( "t2",

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

fun(m_pConn,m_pRs,bstrConnStr);


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

}

[daoge2010]

这个可以搞定吗？试试