VB SQL Êý¾ÝÐÞ¸Ä
ÓÐÒ»¸ö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' " ÓÐûÓÐÀàËÆrdoÖеÄeidtÕâµÄ·½·¨µÄ°¡ÒýÓà VB codecn.Execute"update mytable set student_name = '"& list1.list(3)&"' where id = '5'" ÎÒ¿´Á˱ðÈ˵ÄrdoµÄ³ÌÐò device_rdb.Edit device_rdb!device_no = text_no.Text device_rdb!device_name = text_device.Text device_rdb.Update ÎÒÏÖÔÚÓõÄado Ó¦¸ÃÔõô¸Äµô Äã°ÑÄãadoµÄ´úÂëÌù³öÀ´,ÎÒ°ïÄã¸Ä¸Ä. ÒýÓà ÒýÓà 3 Â¥ jhone99 µÄ»Ø¸´: VB codecn.Execute"update mytable set student_name = '"& list1.list(3)&"' where id = '5'" ÎÒ¿´Á˱ðÈ˵ÄrdoµÄ³ÌÐò device_rdb.Edit device_rdb!device_no = text_no.Text device_rdb!device_name = text_device.Text device_rdb.Update ÎÒÏÖÔÚÓõÄado Ó¦¸ÃÔõô¸Äµô Di
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
Ï£Íû´ó¼ÒÄܹ»°ïÎÒÏÂ.¸ÐлÁË.. Ô´Âë´«ÔÚ´óÃ×ÅÌ VB6 µÄÔ´Âë http://www.damipan.com/file/3wNoKLW.html תΪVB.NETÔ´Âë. СµÜÍêÈ«ÊÇÐÂÊÖ ²»¶®µÄ˵.Âé·³¸÷λ°ïæһÏ ÎÒµÄEMAILÊÇ:4452 ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£ ´úÂëÈçÏ£º VB code: Private Function getFile_CMD(filename, filepath) As Bo ......