C/C++ code:
GetDlgItem(IDC_EDIT_SEARCH)->GetWindowText(m_ipsearch);
CoInitialize(NULL);
_ConnectionPtr tempConn(__uuidof(Connection));
_RecordsetPtr tempRst(__uuidof(Recordset));
tempConn->ConnectionString="Provider=SQLOLEDB;driver=SQL Server;Server=10.11.1.166;Database=tongxue;uid=sa;Password=321456";
tempConn->Open("","","",adConnectUnspecified);
CString sql;
sql.Format("select servip from serviceip where instr(servip, '%s') > 0",m_ipsearch);
//sql.Format("select servip from serviceip where servip ='%s'",m_ipsearch);
tempRst = tempConn->Execute((_bstr_t)sql,0,adCmdText);
if(!tempRst->rsEOF)
{
m_servip=(TCHAR*)(_bstr_t)tempRst->GetFields()->GetItem("servip")->Value;
((CComboBox*)GetDlgItem(IDC_COMBO_IP))->AddString(m_servip);
tempRst->MoveNext();
}
else MessageBox("¸ù±¾Ã»ÕâÕâºÅIP£¡");
m_ipsearchÊÇÒ»¸öCStringÀàÐÍÊý¾Ý£¨´ÓÒ»¸öedit ¿Ø¼þÖлñµÃ£©,serviceipÊÇÊý¾Ý¿âÖеÄÒ»¸ö´æ´¢IP±íÃû£¬
servipÊǾßÌåIP×Ö¶ÎÃû£»È»ºó´Ó±íserviceipµÄservipÖÐÄ£ºý²éѯm_ipsearch£¬²¢½«²éѯµ½µÄ½á¹ûÌí¼Óµ½
Ò»¸öcombo¿Ø¼þÖС£
µ«³ÌÐòÔÚÔËÐе½tempRst = tempConn->Execute((_bstr_t)sql,0,adCmdText); ʱ±¨´í£º
Runtime Error!
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......