Sql SELECT will not work with variable

I would appreciate any assistance with getting my sql select statement to work so that any matches from data in my textbox will result in my dgv being populated with the matches.  Right now I just get a blank dg, even though I know there are matches.
Dim cString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/log1/labeldb.mdb"
        Dim sqlString As String = "SELECT * FROM Log1 WHERE wDD=" & tDate.Text
        Dim OleDBCon As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(cString)
        Dim DataSet As New DataSet()
        Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlString, OleDBCon)
        OleDBCon.Open()
        OleDbDataAdapter1.Fill(DataSet, "Log1")
        DG1.DataSource = DataSet.Tables("Log1")

Open in new window

FingerlakesconstAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
johnnash1180Connect With a Mentor Commented:
Check the date format(?) entered in the tDate text box. Also try the following format...

Dim sqlString As String = "SELECT * FROM Log1 WHERE wDD='" & tDate.Text & "'"

John Nash
0
 
FingerlakesconstAuthor Commented:
Thanks, yours seems to have more spacing between the single and double quotes than all of the combinations I've been trying for the past hour or so.  I'll let you know in a few minutes after I run it.
0
 
FingerlakesconstAuthor Commented:
That did the trick, thanks.
0
All Courses

From novice to tech pro — start learning today.