Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

vcÖÐsqlserverÄ£ºý²éѯÎÊÌ⣡ - VC/MFC / Êý¾Ý¿â

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!


Ïà¹ØÎÊ´ð£º

PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)

PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......

sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ

ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database ......

ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§

ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§
ÆÁ±ÎʲôÒâ˼¡£¡£¡£¡£


°²ÐÔÐÔ,µÇ¼Ãû,Ñ¡ÔñµÇ¼Óû§,ÓÒ¼üÊôÐÔ,״̬,½ûÓõǼ

SQL Server Management Studio-->°²È«ÐÔ-->µÇ¼Ãû-->Ñ¡ÔñµÇ¼Óû§-->ÓÒ¼ü ......

¡¾³õѧÕßÇó½Ì¡¿SQLServerµÄʱ¼äÓë³ÌÐòÖв»Ò»ÖÂ

loatÀàÐ͵Äֵת»¯ÎªÊ±¼äÊÇ—>
C# code:

DateTime dt = DateTime.fromOADate(40277.4927000525);
MessageBox.Show(dt.ToString());
MessageBoxÏÔʾµÄʱ¼äÊÇ—>2010-4-9 11:49:29
µ«ÊÇͬÑùµÄÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ