CString sql; sql.Format("SELECT * FROM [table_name] WHERE 字段名1= '%s' AND 字段名2 = %d",str1,str2);
楼上正解,你的str就是他的str1或str2
我还是不知道怎么弄呢 我的语句是这样的 try { m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open("SELECT * FROM DClass,DInformation WHERE DClass.D_Class = DInformation.D_Class AND DClass.D_type=",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);m_bSuccess = TRUE; m_pRecordset->MoveFirst(); 在这里的话 要怎么修改呢 DClass.D_type= 我要把str 赋值他
cstring strsql; strsql.format(“SELECT * FROM DClass,DInformation WHERE DClass.D_Class = DInformation.D_Class AND DClass.D_type= %s”,str);m_pRecordset->Open(strsql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
sql.Format("SELECT * FROM [table_name]
WHERE 字段名1= '%s' AND 字段名2 = %d",str1,str2);
我的语句是这样的
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM DClass,DInformation WHERE DClass.D_Class = DInformation.D_Class AND DClass.D_type=",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);m_bSuccess = TRUE;
m_pRecordset->MoveFirst();
在这里的话 要怎么修改呢
DClass.D_type= 我要把str 赋值他
strsql.format(“SELECT * FROM DClass,DInformation WHERE DClass.D_Class = DInformation.D_Class AND DClass.D_type= %s”,str);m_pRecordset->Open(strsql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
{
hr = m_pConnection->Open(_T("Provider=SQLOLEDB;Server=XP-201103191332;Database=TEXT;User ID=sa;pwd=123456;Integrated Security=SSPI "),_T(""),_T(""),adModeUnknown);///连接数据库
}
}
catch( _com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format(_T("连接数据库失败!\r\n错误信息:%s"),e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
} 你根据自己的改,别直接复制,我给的是例子。
m_pRecordset->Open((_variant_t &)strsql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);这个是我按着 5楼的那个 改的 就是会中断
try
{
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(_bstr_t(strsql),m_pConnection.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
return m_pRecordset;