Simple SQL question

[Morpheus]

How do I use a variable in a SQL query?

[sizer]

try

 

Dim myStr as String="5"
dim query as  String

query="SELECT * FROM somewhere WHERE something= " & myStr 

[Morpheus]

Is it the same code in C#?

[sizer]

String myStr="4";
String myQuery;
myQuery="SELECT * FROM somewhere WHERE something=" + myStr;

[sizer]

more complex --->

 

String myStr ="Customers";
String myStr1="4";
String myStr2="id";
String myQuery;

myQuery="SELECT * FROM" + myStr + " WHERE " + myStr2 + "=" +myStr1;

[hog]

However if you use a string you should quote it thus:

 

Dim myStr As String="5"
Dim query As  Stringquery="SELECT * FROM somewhere WHERE something= '" & myStr & "'"

[sizer]

Yes, i forgot qoutes!!!

Thanks hog!

 

String myStr ="Customers";
String myStr1="4";
String myQuery;

myQuery="SELECT * FROM" + myStr + " WHERE id ='" + myStr1 + "'";

[Morpheus]

Thanks!