about visual basic.net
Hi
I install vb.net ready and make connection ready, but when
I try to using SQL statement it is error:
my SQL is
dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID
the error is it does not no the string &? Please show me the solution how to solve this error! thank my email is narath-chhay@hotmail.com
Software/Hardware used:
Software/Hardware used:
ASKED:
June 24, 2009 1:15 AM
UPDATED:
December 15, 2010 11:10 PM
Answer Wiki:
What is the error message ?
Are you sure your table name is "tblCustome" and not "tblCustome<b>r</b>"
Also, if you used the ampersand (&) to indicate that intCustomerID is a parameter, you should do it this way (assuming that SqlClient was being used) :
<pre>
command.CommandText = "select * from tblCustomer where CustomerID = :pCustomerId"
command.Parameters.AddWithValue("pCustomerId",intCustomerID)
</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
