SQLÓï¾äÖÐÒýºÅÌ«¶à£¬ÏëÓòÎÊýµ÷Óõķ½Ê½¡£¾ÙÀýÈçÏ£º
sql="update ±íÃû set ×Ö¶Î1=@²ÎÊý1"£¬È»ºó¼ÓÉÏcommand.Parameters.Add("@²ÎÊý1",²ÎÊý1),Ö´ÐÐÖ®¡£
µ«ÊÇÔÚÌõ¼þÖпɼÓÈë²ÎÊýÂð£¿Èçʵ¼ÊÎÊÌâ
update ±íÃû set ¡£¡£¡£¡£¡£Where DateDiff('d',datetime,@DateTimePicker.Value)=0
È» ......
ÎÒÓиö±í a ÀïÃæÓÐid num name Èý¸ö×Ö¶Î
id num name
1 02314 abc
2 035647 sdw
3 045/ dsa
ÎÒÏëͨ¹ýÓï¾ä °ÑnumÇ°Ãæ02 03 ......
СµÜÔÚд³ÌÐòʱÓöµ½ÄÑÌâÁË
ÏëʵÏÖÈçϱíת»»,,ÉîÖªËã·¨ºÜÄÑ,ÄÜÁ¦ÓÐÏÞ,Çëǰ±²Ãǰï°ïæ!
ÓÐÊý¾Ý¿â±íClass
ÐÇÆÚ ¿Î½Ú ¿Î³Ì °à¼¶
1 3 רҵ1 µç×ӵ繤17
1 4 ÕþÖÎ µç×ӵ繤17
1 5 ÓïÎÄ µç×ӵ繤17
1 6 Ó¢Óï µç×ӵ繤17
2 1 Ó¢Óï µç×ӵ繤17
2 2 ÎïÀí µç×ӵ繤17
2 2 ÎïÀí µç×ӵ繤17
2 3 Ó ......
ÓÅ»¯Ê±¼ä¶ÎµÄ²éѯ£¬Ê±¼äÁÐÓ¦¸ÃÈçºÎÉèÖÃÄØ£¿
²éѯʱ»áÓõ½Ä³Ò»¶Îʱ¼ä£¬Ê±¼äÁÐÒªÉèÖÃΪ¾ÛºÏË÷Òý»¹ÊǷǾۺÏË÷Òý
Èç¹ûʱ¼äÊÇΨһµÄ¿ÉÒÔÉèÖóɾۼ¯µÄ¡£
²»Î¨Ò»µÄ»°¡£¡£¡£¡£¡£
Ŷ´íÁË£¬²»Ò»¶¨ÊÇΨһµÄ
ÄÇÔõôÉèÄØ?ÉèΪ¾ÛºÏ°¡£¿£¿£¿
¾Û¼¯Ë÷Òý
(- -|| Ëĸö×Ö¾ÓȻ˵ »Ø¸´ÄÚÈݶÌ)
......
UPDATE T_PlanFund
SET FPlanSumarry = 'ÊýÂëÏà»ú' FPlanMoney = 99999 FPlanMoneyDirection = 0 FPlanMoneyImport = 0 FPlanFundSign = ' ' FPlanFundDate = 2010 / 1 / 11 FPlanFundLock = 0
FPlanNote = '111'
WHERE FPlanFundId = 10
´íÎóÐÅÏ¢£º'FPlanMoney'¸½½ü ......
»ù´¡±í
FID Öµ
0 *
1 ºì
2 ˦
3 ÂÌ
Êý¾Ýºá±í1
Fnum F1 F2
001 0 1
002 &nb ......