I dont know where the error is in this code

Question

Try

MySqlConn.Open()

        Dim Query = "Select * From venuesdb.cost where EventDate  >= ('" & DateTimePicker1.Text & "') AND =< ('" & DateTimePicker2.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()

I keep getting error saying that there is a SQL error here '>= ('" & DateTimePicker2 & " ')'

The syntax of your query is incorrect. Why are you putting the `WHERE` fields in brackets? Also, I believe you need to specify the field name (EventDate) again after the `AND`. — nicolaus-hee, May 03 '15 at 16:07
What is the actual message? It may not like text being used with math operators — Ňɏssa Pøngjǣrdenlarp, May 03 '15 at 16:10

score 2 · Accepted Answer · answered May 03 '15 at 16:11

Your syntax is incorrect, you can either use between without <= and >=(mind symbol sequence in the operators):

Dim Query = "select *
             from venuesdb.cost
             where EventDate  between '" & DateTimePicker1.Text & "' AND '" & DateTimePicker2.Text & "'"

or specify field each time you specify condition:

Dim Query = "select *
             from venuesdb.cost
             where EventDate  >= '" & DateTimePicker1.Text & "' AND EventDate <= '" & DateTimePicker2.Text & "'"

score 1 · Answer 2 · edited May 23 '17 at 12:06

1

You missed a EventDate in your query. Change your code to this:

Dim Query = "Select * From venuesdb.cost where EventDate  >= ('" & DateTimePicker1.Text & "') AND EventDate =< ('" & DateTimePicker2.Text & "')"

Also, you should use parameters in your query to avoid SQL-injection attacks. You can read more about it in this SO question.

edited May 23 '17 at 12:06

Community

1
1

answered May 03 '15 at 16:16

user707727

1,287
7
16

I dont know where the error is in this code

2 Answers2