VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ(·½·¨2)
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬÈϵĿհ×ÃÜÂë µ¥»÷ "²âÊÔÁ¬½Ó" Ìáʾ " Á¬½Ó³É¹¦" µã»÷ È·¶¨ £¨ÔÚ VC6.0 Ï£¬»áÌáʾ"ÇëÑ¡ÔñÊý¾Ý±í" Ñ¡ÖÐ×Ô¼ºËù´´½¨µÄ±íÃû×Ö¼´¿É-> È·¶¨£©
»Øµ½Ó¦ÓóÌÐòÏòµ¼£¬ºóÃæµÄʹÓÃĬÈÏÖµ¾Í¿ÉÒÔ¡£
Íê³ÉÒԺ󣬿ÉÒÔÔÚ Ö÷³ÌÐòµÄ¶Ô»°¿òÖУ¬Ìí¼ÓÒ»¸ö°´Å¦£¬ÔÚ°´Å¦µÄÏìÓ¦º¯ÊýÖмÓÈë¶ÔÊý¾Ý¿â³ÉÔ±µÄÖ±½Ó¸³Öµ¾Í¿ÉÒÔ£¬ÀýÈ磬ÎÒµÄÊý¾Ý¿â±í½á¹¹ÈçÏ£º
ID ×Ô¶¯Ôö³¤£¬Ö÷¼ü¡£
Óû§ÃûSUserName ×Ö·ûÐÍ
Óû§ÐÔ±ðSSex ×Ö·ûÐÍ
ÎÒÏëÔö¼ÓÒ»ÌõеÄÊý¾Ý£ºÕÅÈý ÄÐÄÇô£¬
Ö±½ÓÔÚ°´Å¦µÄÏìÓ¦º¯ÊýÖÐдÉÏ£º
m_pSet->AddNew();
m_pSet->m_SUserName = "ÕÅÈý";
m_pSet->m_SSex = "ÄÐ" ;
m_pSet->Update();
¾Í¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âµÄ²Ù×÷¡£
PS: ÕâÖÖ·½·¨ºÜ·½±ã£¬ÀàÏòµ¼×Ô¶¯¸ø´´½¨ÁËÒ»¸öÊý¾Ý¿â²Ù×÷µÄÀࣺC¹¤³ÌÃûSet ËüÊÇCResordSetµÄÒ»¸ö¼Ì³ÐÀà¡£ÀïÃæ¶ÔÊý¾Ý¿âÖÐµÄ±í½øÁË×Ô¶¯µÄ´¦Àí£¬ÎªÃ¿Ò»Ïî´´½¨ÁËÒ»¸ö±äÁ¿¡£ÎÒÃÇÖ»ÐèÒª½øÐв¢Ìí¼Ó£¬¸øÃ¿¸ö±äÁ¿¸³Öµ£¬¸üУ¬ÕâÑùµÄ²Ù×÷£¬¾Í¿ÉÒÔÍê³É¶ÔÊý¾Ý¿âµÄ´¦Àí¡£
¾ßÌåµÄÀý×Ó¿ÉÒԲο¼ÍøÉϵÄÕâÆªÎÄÕ£ºhttp://www.yesky.com/259/1807259.shtml
ËüÐèÒªÓû§´´½¨Ò»¸öÊý¾ÝÔ´£¬²¢Ñ¡ÔñÏàÓ¦µÄÓû§±íºó²Å¿ÉÒÔ¡£
µÚ¶þÖÖ·½·¨½áÊø¡£
Ïà¹ØÎĵµ£º
´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!! ......
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......
Take Equity Collection System as an example, Some other office collegues want to access it from home without VPN, The way to check is:
1. Check if it's limited in network, this needs to confirm with network people
2. If the step 1 passed, get the external IP address of the system, map ......
string sql = "select a.orderId,a.UserName,b.CodeValue as Delivery ,a.DeliveryAddress,a.PhoneNum,c.CodeValue as Payment,d.CodeValue as OrderStatus,d.CodeValue as OrderStatusID,a.OrderTime,a.Merchant from (( m_Order a ";
sql += " left j ......
´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......