ÎÞ·¨¸ü¸ÄACCESSÊý¾Ý¿â
±¾ÈË×öÁËÒ»¸ö¸ü¸ÄÃÜÂëµÄBUTTON£¬ÔÚ´°ÌåÉÏÃæ»¹ÓÐÒ»¸öTEXTBOX¿Ø¼þ£¬ºǫ́Êý¾Ý¿âÓõÄÊÇACCESS£¬ÏÖÔÚÎÊÌâÈçÏ£ºµã»÷¸ü¸ÄÃÜÂëµÄBUTTONºó£¬TEXTBOXÏÔʾ¸ü¸ÄºóµÄÃÜÂëBBB,£¨ÔÃÜÂëÊÇAAA£©£¬µ«ÊÇÎҹصô´°ÌåºóÔÙÖØÐÂÖ´ÐУ¬Ö±½Óµã»÷ÏÔʾÃÜÂëµÄBUTTON£¬TEXTBOX»¹ÊÇÏÔʾδ¸ü¸ÄµÄÃÜÂëAAA£»ºÃÏñ¾ÍÊdzÌÐòÖ´Ðж¼Ã»ÓÐÎÊÌ⣬µ«ÊǾÍÊDz»Äܽ«ACCESSÊý¾Ý¿âÖÐÃÜÂë±íÖеÄÃÜÂ룡 ÓÃACCESS³ÌÐò´ò¿ª¸ÃÊý¾Ý¿âÃÜÂ뻹ÊÇÔÃÜÂë
string updatestr = "update login set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa'";
OleDbCommand strcommand = new OleDbCommand(updatestr, connection);
strcommand.Connection.Open();
strcommand.ExecuteNonQuery();
update [login]
ÊÔÊÔ
update [login] set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa'
ÔÙÖØÐ²éѯÏÔʾ
È·¶¨ÔËÐгÌÐòʱ ACCESS´¦ÓڹرÕ״̬£¿
²âÊÔ¹ýÁË update [login] set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa' ²»ÐУ¡ access³ÌÐò´¦ÓڹرÕ״̬
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......