Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

¹ØÓÚASP.net(vb)²¥·Å¼à¿ØÂ¼ÏñµÄÎÊÌâ

ÎÒÓг§¼Ò×öµÄASPµÄ¼à¿ØÂ¼Ïñ£¨DVR£©µÄ¾ÖÓòÍø²¥·ÅµÄÔ´³ÌÐòÓë¿Ø¼þ£¬ÏëÒªÓÃASP.net×öÒ»¸öÊÓÆµ»Ø·ÅµÄ³ÌÐò£¨ÀûÓÃËûµÄ¿Ø¼þ£©µ«²»ÖªÈçÏÂÈ¥×ö£¬Íû¸÷λָµã¡£
ÏȸãÇå³þËûÃǵĿؼþÊÇÔõôÓõÄ,
È»ºó¾ÍÖ±½ÓÓúÃÁË.
²»¹ý,Èç ......

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

VBÐÞ¸Ä×¢²á±í

ÓÃVBÔõôֻÕë¶Ôwindows×Ô´øµÄÎļþµÄÓÒ¼üÌí¼Ó²Ëµ¥ È磨.txt .doc)
Õâ¸öÊÇÖ»Õë¶ÔÒÔÕâÁ½¸öΪÀ©Õ¹ÃûµÄÎļþ²Ù×÷
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\txtfile\shell\[Ëæ±ãÆðÃû]\command]
@= ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ