[RESOLVED] Displaying data from database using what i entered into a textbox, help please

[KRJ1993]

hello there, i trying to display certain data from a database i have using a value i entered in a textbox
here is the code i have so far
txtDate.Text = frmViewBookings.txtDate.Text

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:\TheGarageDatabase.mdb"

con.ConnectionString = dbProvider & dbSource

con.Open()


sql = "SELECT * FROM Bookings WHERE Date = '" & txtDate.Text & "'"

da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "TheGarageDatabase")
dgvBookingSearch.DataSource = ds.Tables("TheGarageDatabase")
con.Close()

maxRows = ds.Tables("TheGarageDatabase").Rows.Count
MsgBox(maxRows)
inc = 0

the line of code causing the issue is this;
sql = "SELECT * FROM Bookings WHERE Date = '" & txtDate.Text & "'"
any help please

[thetimmer]

What's the error you're getting ?

Also, please remember wrap your code in [C0DE] [/C0DE] tags so it is easier to read.

txtDate.Text = frmViewBookings.txtDate.Text

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = C:\TheGarageDatabase.mdb"

con.ConnectionString = dbProvider & dbSource

con.Open()


sql = "SELECT * FROM Bookings WHERE Date = '" & txtDate.Text & "'"

da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "TheGarageDatabase")
dgvBookingSearch.DataSource = ds.Tables("TheGarageDatabase")
con.Close()

maxRows = ds.Tables("TheGarageDatabase").Rows.Count
MsgBox(maxRows)
inc = 0

[KRJ1993]

has been resolved now, i just deleted and re added the datasource and it worked, no idea why i was getting an error, must have been because i updated the database or something, thanks for your help though!