如题,代码如下:
CString stri;
ADO m_ado;
m_ado.OnInitADOConn();
m_CboGZMa.GetLBText(m_CboGZMa.GetCurSel(),stri);
m_CboGZMiaoShu.ResetContent();
CString sql3;
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = '+stri+' ");//
m_ado.m_pRecordset = m_ado.OpenRecordset(sql3); while(!m_ado.m_pRecordset->adoEOF)
{
m_CboGZMiaoShu.AddString((_bstr_t)(m_ado.m_pRecordset->GetCollect ("故障码")));
m_ado.m_pRecordset->MoveNext();
}其中stri的值会随另外一个组合框的变化而发生变化,其内容为汉字,求高手指点,从网上查了好久,不得其解!
CString stri;
ADO m_ado;
m_ado.OnInitADOConn();
m_CboGZMa.GetLBText(m_CboGZMa.GetCurSel(),stri);
m_CboGZMiaoShu.ResetContent();
CString sql3;
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = '+stri+' ");//
m_ado.m_pRecordset = m_ado.OpenRecordset(sql3); while(!m_ado.m_pRecordset->adoEOF)
{
m_CboGZMiaoShu.AddString((_bstr_t)(m_ado.m_pRecordset->GetCollect ("故障码")));
m_ado.m_pRecordset->MoveNext();
}其中stri的值会随另外一个组合框的变化而发生变化,其内容为汉字,求高手指点,从网上查了好久,不得其解!
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = '''+stri+''' ");//
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = '"+stri+"'");
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = N'+stri+' ");//
故障描述 varchar 8 0
故障码 varchar 200 0
sql3.Format("SELECT 故障码 FROM faultcode WHERE 故障描述 = '"+stri+"'");