AccessÖÐSQLÓï¾ä²ÎÊýµ÷ÓõÄÎÊÌâ

SQLÓï¾äÖÐÒýºÅÌ«¶à£¬ÏëÓòÎÊýµ÷Óõķ½Ê½¡£¾ÙÀýÈçÏ£º
sql="update ±íÃû set ×Ö¶Î1=@²ÎÊý1"£¬È»ºó¼ÓÉÏcommand.Parameters.Add("@²ÎÊý1",²ÎÊý1),Ö´ÐÐÖ®¡£
µ«ÊÇÔÚÌõ¼þÖпɼÓÈë²ÎÊýÂð£¿Èçʵ¼ÊÎÊÌâ
update ±íÃû set ¡£¡£¡£¡£¡£Where DateDiff('d',datetime,@DateTimePicker.Value)=0
È»ºóÔÙ¸øcommand.Parameters.Add("@DateTimePicker.Value",DateTimePicker.Value)ÕâÑù×ö¿ÉÒÔÂð£¿
»òÕß
Select ¡£¡£¡£¡£from  ±í1 where DateDiff('d',datetime,@DateTimePicker.Value)=0
È»ºóÔÙ¸øcommand.Parameters.Add("@DateTimePicker.Value",DateTimePicker.Value)ÕâÑù×ö¿ÉÒÔÂð£¿
×¢:DateTimePicker.ValueÊÇdatetimeÀàÐÍ¡£ÆäÖеÄupdate»òSelectÓï¾äÓÖÊÇǶÌ×µÄSQLÓï¾ä

---

ÆÚ´ý´óʦµÄ¼û½â£¬AccessÈçºÎÒýÓòÎÊý£¬ÈçºÎ¸ø²ÎÊý¸³Öµ£¬ÈçºÎ²âÊÔ¸³ÖµÊÇ·ñ³É¹¦ÄØ

---

C# code:
string sql = "update wc_subject set sub_amount=sub_amount+1, sub_date=? where sub_id=?";

OleDbCommand command = new OleDbCommand(sql, connection);
command.Parameters.Add("?", OleDbType.Date).Value = userName;
command.Parameters.Add("?", OleDbType.Integer).Value = 1;

---

ÒýÓÃ

C# codestring sql="update wc_subject set sub_amount=sub_amount+1, sub_date=? where sub_id=?";

OleDbCommand command=new OleDbCommand(sql, connection);
command.Parameters.Add("?", OleDbType.Dat