Vb.net Access查询按年月

    我需要通过单个查询条件按年月,查询到access数据库里的数据为 (日期类型2008-02-02)


        Dim DDTP1 As String

        Dim date1 As Date = DTP1.Value

        DDTP1 = Format(date1, "#yyyy-MM#")


        Dim myTable As DataTable = myDataSet("select * from Pay where TData = " & DDTP1).Tables(0)
       
        (表Pay , 日期字段Tdata )


        上面的查询不能实现,烦请哪个高手帮下我!多谢.

     
   

---

绑定

---

VB.NET code:
这个方法吧

Dim DDTP1 As String
Dim date1 As Date = DTP1.Value.ToString("yyyy-mm-dd")
Dim myTable As DataTable = myDataSet("select * from Pay where TData = " & DDTP1).Tables(0)

'(表Pay , 日期字段Tdata )


'上面的查询不能实现,烦请哪个高手帮下我!多谢.

---

VB.NET code:
strSql = " select top 10 * from VWEmployees where EmpBirthday between '" & cmbBirS.Value.Date & "' And '" & cmbBirE.Val