ÈÃÈË·è¿ñµÄACCESS. ʱ¼ä×Ö¶ÎÎÞ·¨ÓÃparametersÉùÃ÷

VB.NET code:
Dim strSql As New StringBuilder()
strSql.Append("select * from ¶¨µ¥ where 1=1 ")
strSql.Append(" and ʱ¼ä >= @¿ªÊ¼Ê±¼ä and ʱ¼ä <= @½áÊøʱ¼ä and Õ˺Å=@Õ˺Å")


Dim parameters As OleDbParameter() = {New OleDbParameter("@¿ªÊ¼Ê±¼ä", OleDbType.DBDate), _
New OleDbParameter("@½áÊøʱ¼ä", OleDbType.DBDate), _
New OleDbParameter("@Õ˺Å", OleDbType.VarChar)}

'ÕâÑù»á±¨²»ÄÜת»»µÄ´íÎó
parameters(0).Value = Convert.ToDateTime(sj1.ToString("yyyy-MM-dd 00:00"))
parameters(1).Value = Convert.ToDateTime(sj2.ToString("yyyy-MM-dd 59:59"))
parameters(2).Value = user

'ÓÃÒÔÏÂÓï·¨²»»á±¨´í,¾ÍÊǵò»µ½½á¹û
'parameters(1).Value = Convert.ToDateTime(sj2.AddHours(23).AddMinutes(59).AddSeconds(59))


'Óöϵã»áµÃµ½ÒÔÏÂ×Ö·û,Èç¹ûÖ±½ÓÌùµ½·ÖÎöÆ÷Àï¾Í¿ÉÒԲ鵽½á¹û
'select * from ¶¨µ¥ where 1=1 and ʱ¼ä >= #12/20/2009# and ʱ¼ä <= #12/20/2009 11:59:59 PM# and Óû§Ãû='bbb'



GOOGLEÁËÒ»ÏÂ,·¢ÏÖ´ó¶àÊýÈËÑ¡ÔñÁË°ÑÈÕÆÚµ±stringÀ´´¦Àí,ÎҸоõÕâÑùÓÃÔÚÏîÄ¿Öзdz£²»ºÃ.

´ó¼Ò¿ÉÒÔÊÔÒ»ÏÂ,Äã»á·¢ÏÖACCESS·Ç³£±ä̬.¶¼ÓеãÌÖÑáMSÁË....

---

µÚÒ»ÖÖд·¨
parameters(1).Va