Passing a variable to a sql query?

[SCA Analyst]

How might I pass a variable's value into a sql query?

simple example: Select * from tbl_person
where age >= <variable from form>

[Armin Zingler]

"SCA Analyst" <jg********@scf.sk.ca> schrieb

How might I pass a variable's value into a sql query?

simple example: Select * from tbl_person
where age >= <variable from form>

http://msdn.microsoft.com/library/en...taadapters.asp
http://msdn.microsoft.com/library/en...turnvalues.asp
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Herfried K. Wagner [MVP]]

* "SCA Analyst" <jg********@scf.sk.ca> scripsit:

How might I pass a variable's value into a sql query?

simple example: Select * from tbl_person
where age >= <variable from form>

Notice that a separate group for ADO.NET related question is available:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Bernie Yaeger]

Dim oconn As New SqlConnection("data source=d5z0071;database=imc;integrated
security=sspi;")

Dim dapubpay As New SqlDataAdapter("select * from pubpay where bipad = " &
chr(39) & mbipadvar & chr(39) & " order by bipad, issuecode, vflag", oconn)

HTH,

Bernie Yaeger

"SCA Analyst" <jg********@scf.sk.ca> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...

How might I pass a variable's value into a sql query?

simple example: Select * from tbl_person
where age >= <variable from form>