How do I bind datetimepicker to Microsoft access 2013 database? the splash form, admin login form, main dashboard form has been created, Also, the Add new student form , DateTimePicker, combo box on the form and all the text boxes was successfully made. The problem now lies in How to bind the DateTimePicker and Combo box to the Access database. Also, How do I create the report form with all its features intact?
Regards
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
