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!