Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸ö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ת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

ÇëºÃÐÄÈ˰ïÎÒ°ÑVBÔ´ÂëתΪVB.NET~

Ï£Íû´ó¼ÒÄܹ»°ïÎÒÏÂ.¸ÐлÁË..


Ô´Âë´«ÔÚ´óÃ×ÅÌ VB6 µÄÔ´Âë http://www.damipan.com/file/3wNoKLW.html

תΪVB.NETÔ´Âë.

СµÜÍêÈ«ÊÇÐÂÊÖ ²»¶®µÄ˵.Âé·³¸÷λ°ïæһÏÂ

ÎÒµÄEMAILÊÇ:4452 ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

¡¾¼±Çó¡¿VBÖÐʹÓÃWScriptµ÷ÓÃÍⲿÃüÁî - VB / »ù´¡Àà

ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:

Private Function getFile_CMD(filename, filepath) As Bo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ