Hi I am trying to use the value entered in a datepicker control as a parameter in a query but I kept getting error please find below different constructions I used and associated errors.
1) da = New OleDbDataAdapter("select * from student_info Where Bday =" & DateTimePicker_Select.Value & "", con)
ERROR: Synthax error (missing operator) in querry epression 'Bday=10/1401972 9:48:00 AM'.
2) da = New OleDbDataAdapter("select * from student_info Where Bday =" & DateTimePicker_Select.Text & "", con)
ERROR: The above construct returns empty rows just colum names and empty rows.
====================================================
Private Sub birthday_saerch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles birthday_saerch.Click
Dim con As New OleDbConnection
con.ConnectionString = _
"provider=Microsoft.JET.OLEDB.4.0; " & _
"data source = '" & Application.StartupPath & "\school_record.mdb'"
Dim ds As New DataSet
Dim dt As New DataTable
ds.Tables.Add(dt)
Dim da As New OleDbDataAdapter
'da = New OleDbDataAdapter("select * from student_info Where matric_number =" & txt_serach.Text & "", con)
da = New OleDbDataAdapter("select * from student_info Where Bday =" & DateTimePicker_Select.Value & "", con)
'da = New OleDbDataAdapter("select * from student_info Where Bday =" & DateTimePicker_Select.Text & "", con)
da.Fill(dt)
dv.DataSource = dt.DefaultView
con.Close()
End Sub
