mardi 5 mai 2015

Choose from various dates using date time picker

This button filters the datagridview using datetimepicker. What should I do if I want to filter it between dates?

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click

    MySqlConn = New MySqlConnection
    MySqlConn.ConnectionString = "Server = Localhost; database = venuesdb; user id = root; Password = "
    Dim SQLDataAdapter As New MySqlDataAdapter
    Dim DatabaseDatSet As New DataTable
    Dim Bindsource As New BindingSource        
    Try
        MySqlConn.Open()
        Dim Query = "Select * From venuesdb.cost where EventDate  = ('" & DateTimePicker1.Text & "')"
        Command = New MySqlCommand(Query, MySqlConn)
        SQLDataAdapter.SelectCommand = Command
        SQLDataAdapter.Fill(DatabaseDatSet)
        Bindsource.DataSource = DatabaseDatSet
        DataGridView1.DataSource = Bindsource
        SQLDataAdapter.Update(DatabaseDatSet)
        MySqlConn.Close()
    Catch ex As Exception
        MessageBox.Show(ex.Message)
    End Try
    MySqlConn.Dispose()
End Sub

Aucun commentaire:

Enregistrer un commentaire