SQL querystring syntax error

[CookieNZ]

Dim jobnumber As String = Request.QueryString("JobNo")


Dim dbquerystring As New OleDbDataAdapter("select * from mainjobdetails where jobno=" & "'jobnumber'", dbconnection)

Doesn't seem to load the right data and I am sure I have got the wrong syntax.

 

[TechGnome]

Try this:

Dim dbquerystring AsNew OleDbDataAdapter("select * from mainjobdetails where jobno='" & jobnumber & "'", dbconnection)

-tg