VC++Á¬½ÓSQLServer
VC++Á¬½ÓSQLServer
/*
*Á¬½ÓSQL
*/
void CMFCSQLDlg::OnButton3()
{
// TODO: Add your control notification handler code here
_ConnectionPtr m_pConnection;
// ÔÚÓ¦ÓóÌÐòµÄInitInstanceº¯ÊýÀï¼ÓÈë
if(S_OK!=CoInitialize(NULL))
{
AfxMessageBox("³õʼ»¯COM¿â´íÎó!");
}else
{
AfxMessageBox("³õʼ»¯COM¿â³É¹¦!");
}
// Á¬½ÓÊý¾Ý¿â£º
HRESULT hr; //·µ»Ø½á¹û±äÁ¿
try
{
hr=m_pConnection.CreateInstance("ADODB.Connection"); //´´½¨Connection¶ÔÏó
if(SUCCEEDED(hr))
{
//hr=m_pConnection->Open("Provider=SQLOLEDB;Server=808644DA83B446C\SQLEXPRESS;Database=ChinabaseSQLServer;UserID=sa;pwd=123","","",adModeUnknown); //;Integrated Security=SSPI
m_pConnection->Open("Provider=SQLOLEDB.1;Server=808644DA83B446C\\SQLEXPRESS;DATABASE=ChinabaseSQLServer;UID=sa;PWD=123;","","",adModeUnknown);
MessageBox("Á¬½ÓSQLÔËÐгɹ¦!","³É¹¦",MB_OK);
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
m_pCommand.CreateInstance("ADODB.Command");
_variant_t vNULL;
vNULL.vt = VT_ERROR;
Ïà¹ØÎĵµ£º
ûÏëµ½ ûÏëµ½ ÍòÍòûÏëµ½
¶ÔC++°ËÇÏֻͨÁË7ÇϵÄÎÒ£¬¾¹È»Òª¿ªÊ¼¸ãc++Á˵Ä˵£¬ÕæÊǺò»´Ì¼¤¡£
²»¸ÒÏàÐÅ£¬²»¸ÒÏàÐÅ¡£
ÀàÐÍÊÇÊ²Ã´ÍæÒ⣿ÀàÔõôд£¿×Ö·û´®Ôõô´¦Àí£¿ÔõôÊÍ·ÅÄڴ棿
ż²»Öª£¬²»Öª£¬ÕæµÄ²»Öª¡£¡£¡£¡£
°¥ Íê¶¼ÍêÁË¡£
°¦ ²»¹ÜÔõô˵¶¼ÒªÈ¥Ñ§µÄ¡£¡£¡£Ò»µãÕÞ¶¼Ã»ÓÐ
#incl ......
1.·ÖÀà
ÄÚ²¿ÀàÐÍ ºÍÓû§¶¨ÒåÀàÐÍ
2.
ÕûÐΣºbool ,×Ö·ûÐÍ£¬ÕûÐÎ
true 1 flase 0
·ÇÁã true & ......
µ¥Ïß³Ì
Single-Threaded(static) libc.lib
Debug Single-Threaded(static) & ......
4.2 ¶à½Ç¶È±£Ö¤²âÊÔЧ¹û
¶ÔÓÚ´úÂëÖÊÁ¿ÒªÇóºÜ¸ßµÄÏîÄ¿À´Ëµ£¬½öÓа׺и²¸ÇÊÇÔ¶Ô¶²»¹»µÄ¡£°×ºÐ¸²¸Ç²»ÄÜ·¢ÏÖ´úÂëȱʧ£¬°×ºÐ¸²¸Ç»ùÓÚÏÖÓдúÂ룬Èç¹û´úÂë²»´æÔÚ£¬µ±È»²»ÄÜ·¢ÏÖ¡£ÎªÁ˼ì²â´úÂëȱʧ£¬ÐèÒªÈ˹¤¶Ô²âÊÔÊý¾Ý½øÐмì²é¡£°×ºÐ¸²¸ÇÒ²²»ÄÜ·¢ÏÖÓÃÀýδ·´Ó³¹¦ÄÜ¡£Èç¹ûÉè¼ÆÓÃÀýʱ£¬²âÊÔÔ±²»Á˽â´úÂëµÄ¹¦ÄÜ£¬Í ......