ÓÐÒ»¸öList²Ëµ¥£¬Ñ¡Ôñ³öÒªÐ޸ĵÄÑ¡Ï±à¼Ò»Ïµã»÷¡°±£´æ¡±ÒÔºó£¬Ð޸ĵÄÄÚÈݾͻᱣ´æµ½SQLÖС£ Ï£ÍûÓгÌÐò²Î¿¼Ò»Ï¡£Ê¹ÓÃʲô·½·¨¡£EditGrid¡£ cn.Execute "update mytable set student_name = '" & list "' where id = '5' " VB code: cn.Execute "update mytable set student_name = '" & list1.list(3) & "' where id = '5' "
ÔÚvbÖÐÔõôÅжϣ¬²åÈëµ½Êý¾Ý¿âÖеÄÖµÊÇÖظ´µÄ£¬±¾È˲ŸսӴ¥VBÓïÑÔ£¬ÉõÊÇÓкöàµØ·½»¹²»¶®£¬»¹Çë¸÷λ´óÏÀÃǸø³ö´úÂ룬ллÁËѽ£¡£¡£¡ ²åÈë֮ǰselectһϰ¢¡£ »òÕßдһ¸ö×éºÏSQL²åÈëÓï¾ä£¬ÀýÈç IF not Exist( & ......