How to bind datetimepicker to MS access 2013 database?

How to bind datetimepicker to MS access 2013 database?

To Bind the DateTimePicker to an MS Access Database , use this code

On save button click, Use below code

Dim connection As SqlConnection = New sqlconnection()

connection.ConnectionString = "YOUR CONNECTION STRING"

connection.Open()

Dim adp As SqlDataAdapter = New SqlDataAdapter("select * from Table where Date between DateTimePicker1.Value and DateTimePicker2.Value", connection)

Dim ds As DataSet = New DataSet()

adp.Fill(ds)

DataGridView1.DataSource = ds.Tables(0)

To Bind ComboBox to an MS Access database , use this code

 Private Sub FillCombo()
        Try
            Dim fillcon As New OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path to access file.mdb;")
            Dim asql As String = ("SELECT * FROM Items ORDER BY ItemName")
            Dim da As New OleDbDataAdapter(asql, fillcon)
            Dim ds As New DataSet
            da.Fill(ds)
            ItemNameCombo.ValueMember = "ItemName"
            ItemNameCombo.DataSource = ds.Tables(0)
            ItemNameCombo.SelectedIndex = 0
        Catch ex As Exception
            MsgBox("ERROR : " & ex.Message.ToString)
        End Try
    End Sub