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]

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-us/cpguide/html/cpconusingparameterswithdataadapters.asp
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconinputoutputparametersreturnvalues.asp

 

[Herfried K. Wagner [MVP]]

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:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.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