vb2005²Ù×÷access
ÎÒÏëʵÏÖµÄÊǸüмǼµÄÒ»¸ö¹¦ÄÜ
ÔÚÕâ¸ö±íÖÐ ÓÐÈÕÆÚ ºÍ»õ±ÒÀàÐ͵Ä×Ö¶Î
±í×Ö¶ÎΪ
MemberCharge ±íÃû
ID1 ×Ô¶¯±àºÅ
ID Îı¾
DateTime ʱ¼ä
Type Êý×Ö
Money »õ±Ò
StorageMoney »õ±Ò
ÒÔÉÏÊDZíµÄ
VB.NET code:
Dim strUpdate As String = "update MemberCharge set ID=@ID,DateTime=@DateTime,Type=@Type,Money=@Money,StorageMoney=@StorageMoney where ID1=@ID1"
Õâ¸öÊÇÎÒ×Ô¼ºµÄдµÄ sqlÓï¾ä
VB.NET code:
myComm.Parameters.AddWithValue("@ID1", txtID1.Text.Trim)
myComm.Parameters.AddWithValue("@ID",txtID.Text.Trim)
myComm.Parameters.AddWithValue("@DateTime",txtTime.Text.Trim)
myComm.Parameters.AddWithValue("@Type", txtMemberType.Text.Trim)
myComm.Parameters.AddWithValue("@Money", txtMoney.Text)
myComm.Parameters.AddWithValue("@StorageMoney", txtMoney.Text)
myComm.ExecuteNonQuery()
¸üÐÂʧ°Ü£¬ËµÎÒµÄupdateÓï¾äÓдíÎó£¬ÎÒÓе㲻Ã÷°×ÎÒ´Ó Êý¾Ý¿âÖжÁÈ¡µ
Ïà¹ØÎÊ´ð£º
ÎÒÓг§¼Ò×öµÄASPµÄ¼à¿Ø¼Ïñ£¨DVR£©µÄ¾ÖÓòÍø²¥·ÅµÄÔ´³ÌÐòÓë¿Ø¼þ£¬ÏëÒªÓÃASP.net×öÒ»¸öÊÓƵ»Ø·ÅµÄ³ÌÐò£¨ÀûÓÃËûµÄ¿Ø¼þ£©µ«²»ÖªÈçÏÂÈ¥×ö£¬Íû¸÷λָµã¡£
ÏȸãÇå³þËûÃǵĿؼþÊÇÔõôÓõÄ,
È»ºó¾ÍÖ±½ÓÓúÃÁË.
²»¹ý,Èç ......
vbдµÄ³ÌÐò±àÒëºó,ÔËÐÐÈô³ö´í,ÈçºÎÖªµÀµ½ÔÚÄÄÒ»ÐÐ?
°´Ctrl+F5Ô¤±àÒ룬³ö´íʱ»áÌøתµ½´íÎóÐÐ
²»ÊÇÄÇÑùµÄÁË,ÎÒÊÇÒªÇó±àÒë³ÉEXEºóÔËÐÐ,Ìáʾ³ö´íÄÜ·ñÌáʾ´íÔÚÄÄÒ»ÐÐ.
ÎÒ±àÒëºóÔÚÎҵĵçÄÔÉÏÔËÐÐûÎÊÌâ,µ«Ô ......
vbÖÐÔõôͨ¹ýxmlÀ´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£
û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£
XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£
Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£
Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......
¸÷λ´óϺ£º
ÎÒÓÐÒ»¸öVBµ÷ÓÃË®¾§±¨±íµÄϵͳ£¬±¨±íÊÇ×÷Ϊһ¸öDesignǶÔÚVBÀïµÄ£¬½ñÌì·¢ÏÖ´òÓ¡µÚÒ»Õű¨±íÕý³££¬Í¬ÑùµÄÊý¾Ý£¬ÔÚµã´òÓ¡ÔÙµ÷ÓÃÒ»´Î¾Í»á±¨ Memory FullµÄ´íÎ󣬵«ÊÇ ......
ÔÚvbÖÐÔõôÅжϣ¬²åÈëµ½Êý¾Ý¿âÖеÄÖµÊÇÖظ´µÄ£¬±¾È˲ŸսӴ¥VBÓïÑÔ£¬ÉõÊÇÓкöàµØ·½»¹²»¶®£¬»¹Çë¸÷λ´óÏÀÃǸø³ö´úÂ룬ллÁËѽ£¡£¡£¡
²åÈë֮ǰselectһϰ¢¡£
»òÕßдһ¸ö×éºÏSQL²åÈëÓï¾ä£¬ÀýÈç
IF not Exist(
& ......