ÄǸöÎÊÌ⻹û½áÊø£¬ACCESSÖ»Äܵ¥¾äSQL
ÔÌû£º
http://topic.csdn.net/u/20090925/23/4611c916-41a1-42bc-9f10-f7dd86ab3ded.html
¼ÈÈ»ACCESSÖ»Ö§³Öµ¥¾äSQL²éѯ£¬ÄÇôÎÒÄǸö³ÌÐòÊDz»ÊǾÍûʲô©¶´£¿
CityBird»Ø¸´Ëµ£º
sql="Select * from admins where admin_user='"&request("admin_user")&"'"
ÕâÀïÓÐ×¢Èë¹¥»÷©¶´£¬Èç¹ûÔÚadmin_passwordÖÐÊäÈë"' update admins set admin_password='' --"
½«¿ÉÄܵ¼ÖÂÄãadmins±íÀïËùÓмǼµÄadmin_password×ֶεÄÄÚÈݱ»¸üÐÂΪ¿Õ×Ö·û´®¡£
ÎÒÓõÄACCESSÊý¾Ý¿â£¬Õâ¸öÁªºÏ²éѯ¸ù±¾¾ÍÖ´Ðв»ÁË¡£¶Ô²»¶Ô £¿
ÄÇôÎҵijÌÐò»¹ÓЩ¶´Â𣿠»¹»á±»ÔõÑùÀûÓà £¿
²»¹ýÂË:request("admin_user")¾Í´æÔÚSQL×¢ÈëµÄΣÏÕ£¡¸úACCESSÖ»Ö§³Öµ¥¾äSQL²éѯû¹ØÏµ£¡
½¨Ò飬Êý¾ÝÔÚ²åÈë»ò¼ìË÷֮ǰ£¬±àдһ¸öº¯Êý½øÐÐÅжϡ£
ÈçÊÇ·ñ°üº¬£ºupdate¡¢insert¡¢select¡¢*µÈ×Ö·û¡£¡£¡£
¶Ô²ÎÊý½øÐÐϹýÂ˾ͺÃÁË¡£ÓõÃ×ÅÕâÑùô.....
Ò»°ãÇé¿öÏ£¬ÐèÒªÄã¶Ô-ºÈ;½øÐйýÂ˾ÍOK¡£µ«ÊÇ×îºÃµÄ°ì·¨ÊÇÏÐÖÃijЩ×ֶεij¤¶È¡£
ÔÙÓоÍÊǶàʹÓôº³õ¹ý³Ì£¬ÕâÑù£¬×¢ÈëµÄÎÊÌâ¶àÉٻؽâ¾öÁË¡£
×î¸ù±¾µÄ·½·¨ÊǶÔ×Ô¼ºÐ´µÄËÑÓеÄÌá½»×ֶνøÐйýÂË´¦Àí¡£scriptºÍsql×¢Èë¶¼·Ç³£Î£ÏÕµÄ˵¡£
Ò»¸öÊÇ×¢É䣬µ«ÕâÑùµÄ×¢Éäû±ØÒªÀûÓÃ
¶þÊÇÍòÄÜÃÜÂ룬ֱ½Ó¾Í½øºǫ́ÁË£¬ËùÒÔ¡°×¢Éäû±ØÒªÀûÓá±
ding
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
access ÒѽûÓôËÊý¾Ý¿âÖпÉÄÜÓꦵÄÄÚÈÝ vba
ÎÒÓÃaccess´ò¿ªÕâ¸öÊý¾Ý¿âÌáʾ½ûÓÃÁËÕâ¸ö
Èç¹ûÎÒÑ¡ÔñÆôÓà ¾ÍÄܸüÐÂÁË
ÈçºÎÔÚ³ÌÐòÖдò¿ªÊý¾Ý¿âÒ²ÆôÓÃÕâ¸öÄØ£¿
OleDbConnection conn = new OleDb ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......