_ConnectionPtr m_pconnection;
_RecordsetPtr m_precordset;
_CommandPtr m_command;
ParametersPtr *Params1 = NULL;
_ParameterPtr paramet1;
CString name;
UpdateData(TRUE);
try
{
m_pconnection.CreateInstance("ADODB.Connection");
m_pconnection->ConnectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=QH-20160810ZMWN\\SQLEXPRESS";
HRESULT hr=m_pconnection->Open("","","",adModeUnknown);
if (SUCCEEDED(hr))
{
HRESULT hr1=m_command.CreateInstance(__uuidof(Command));
m_precordset.CreateInstance(__uuidof(Recordset));
m_command->ActiveConnection=m_pconnection;
m_command->CommandText=_bstr_t(_T("select * from studentinfo where stuno=@stuno"));//stuno定義為 int 型別
paramet1=m_command->CreateParameter(_bstr_t(_T("")),adVarChar,adParamInput,2,_variant_t(_T("5")));
paramet1->Value=https://bbs.csdn.net/topics/_variant_t(_T("5"));
int ff=0;
m_command->Parameters->Append(paramet1);
m_precordset->Open((IDispatch*)m_command,vtMissing,adOpenStatic,adLockOptimistic,adCmdText);
while (!m_precordset->adoEOF)
{
edit_stuNo=(WCHAR*)_bstr_t(m_precordset->GetCollect("stuno"));
edit_stuName=(WCHAR*)_bstr_t(m_precordset->GetCollect("stuname"));
UpdateData(false);
m_precordset->MoveNext();
}
}
}
catch (_com_error e)
{
CString errormessage;
errormessage.Format(_T("連接資料庫失敗!\r\n錯誤資訊:%s"),(LPCTSTR)e.Description());
AfxMessageBox(errormessage);
}
出現了這個錯誤求解答謝謝大家
uj5u.com熱心網友回復：
sql陳述句出錯，先在視圖調通陳述句，再放進代碼，@stuno變數沒定義uj5u.com熱心網友回復：
那是引數不是變數，應該不用定義吧uj5u.com熱心網友回復：
單獨運行sql陳述句可行嗎？uj5u.com熱心網友回復：
不行啊，剛才我把表里的stuno定義為int型別，然后
uj5u.com熱心網友回復：
這樣寫就能通過了uj5u.com熱心網友回復：
解決了，是我自己搞復雜了uj5u.com熱心網友回復：
不是代碼出錯，是資料庫SQL陳述句出錯轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/120628.html
標籤：數據庫