11-12-18, 11:56 PM
السلام عليكم
تظهر لى الرسالة الاتية
Syntax error (missing operator) in query expression 'day payment between #2018/05/05# and #2018/12/11#'.
عند التطبيق فى الكود التالى
Private Sub Button13_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button13.Click
Dim dax As New OleDbDataAdapter
Dim dtx As New DataTable
dax = New OleDbDataAdapter("SELECT * FROM cairo1 WHERE day payment between #" & DateTimePicker1.Text & "# and #" & DateTimePicker2.Text & "#", con)
dax.Fill(dtx)
DataGridView1.DataSource = dtx
لوسمحتم ايه الحل
تظهر لى الرسالة الاتية
Syntax error (missing operator) in query expression 'day payment between #2018/05/05# and #2018/12/11#'.
عند التطبيق فى الكود التالى
Private Sub Button13_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button13.Click
Dim dax As New OleDbDataAdapter
Dim dtx As New DataTable
dax = New OleDbDataAdapter("SELECT * FROM cairo1 WHERE day payment between #" & DateTimePicker1.Text & "# and #" & DateTimePicker2.Text & "#", con)
dax.Fill(dtx)
DataGridView1.DataSource = dtx
لوسمحتم ايه الحل