{
::CoInitialize(NULL);//初始化com环境
HRESULT hr;
try
{
hr=m_pCon.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
m_pCon->ConnectionTimeout=3;
hr=m_pCon->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= opencard.mdb","","",adModeUnknown);
}
}
catch(_com_error e)
{
CString temp;
temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
::MessageBox(NULL,temp,"提示信息",NULL);
}
m_pRecordSet.CreateInstance(__uuidof(Recordset));
CString sql;
int nItem=0;
sql.Format("select z_UserID,z_UserName,z_DoorEnadled,z_CardNO from z_w_Card , z_w_User where z_w_Card.z_CardID=z_w_User.z_CardID");
m_pRecordSet->Open((_bstr_t) sql,m_pCon.GetInterfacePtr(), adOpenDynamic,adLockOptimistic,adCmdText);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE|LVS_EX_CHECKBOXES);
m_list.InsertColumn(0,"编号",LVCFMT_LEFT,80);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,80);
m_list.InsertColumn(2,"卡号",LVCFMT_LEFT,80);
m_list.InsertColumn(3,"考勤",LVCFMT_LEFT,80);
_bstr_t str;
while(m_pRecordSet->adoEOF==0)
{
str = (_bstr_t)m_pRecordSet->GetCollect("z_UserID");
m_list.InsertItem(nItem,"");
m_list.SetItemText(nItem,0,(char*)str);
m_pRecordSet->MoveNext();
}
}
::CoInitialize(NULL);//初始化com环境
HRESULT hr;
try
{
hr=m_pCon.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
m_pCon->ConnectionTimeout=3;
hr=m_pCon->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= opencard.mdb","","",adModeUnknown);
}
}
catch(_com_error e)
{
CString temp;
temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
::MessageBox(NULL,temp,"提示信息",NULL);
}
m_pRecordSet.CreateInstance(__uuidof(Recordset));
CString sql;
int nItem=0;
sql.Format("select z_UserID,z_UserName,z_DoorEnadled,z_CardNO from z_w_Card , z_w_User where z_w_Card.z_CardID=z_w_User.z_CardID");
m_pRecordSet->Open((_bstr_t) sql,m_pCon.GetInterfacePtr(), adOpenDynamic,adLockOptimistic,adCmdText);
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE|LVS_EX_CHECKBOXES);
m_list.InsertColumn(0,"编号",LVCFMT_LEFT,80);
m_list.InsertColumn(1,"姓名",LVCFMT_LEFT,80);
m_list.InsertColumn(2,"卡号",LVCFMT_LEFT,80);
m_list.InsertColumn(3,"考勤",LVCFMT_LEFT,80);
_bstr_t str;
while(m_pRecordSet->adoEOF==0)
{
str = (_bstr_t)m_pRecordSet->GetCollect("z_UserID");
m_list.InsertItem(nItem,"");
m_list.SetItemText(nItem,0,(char*)str);
m_pRecordSet->MoveNext();
}
}
the application's support team for more information.
出现一个这样的对话框,是为什么啊!
这个语句出错;出现一个对话框显示
Unhandled exception in www.exe(KERNEL32.dll)我的Sql语句有错误吗!
我的其他地方会出现错误码!
::MessageBox(NULL, sql, NULL, MB_OK);