[RESOLVED] The multi-part identifier could not be bound.

[Mrkanin]

Hey all...

I am writing a webservice to take care of some license problems we have.. it need to be able to see if there are more licenses in use than the client have in total, and thereby allowing a client to either open a program or not. based on how many licenses that are in use already.

problem is that i get this error when i try to test out by code bit:

"System.Data.SqlClient.SqlException: The multi-part identifier "AcroRd32.exe" could not be bound."

what i am doing is that i try to send an sqlCommand to my database to get back the number of maxLicenses allowed..

the c# code is here:
string s = "Select maxLicenses from LicenseList where programName = " + program;
con = new SqlConnection(conString);
con.Open();
cmd = new SqlCommand(s, con);
reader = cmd.ExecuteReader();

the error massage says its in the cmd.ExecuteReader() line that fails...

have checked all names and they match with the names in the DB.
Anyone know what can be the problem?

[Alsvha]

string s = "Select maxLicenses from LicenseList where programName = " + program;


You're missing the sql string delimiters for the "s" variable's content.

Something like this it would seem

string s = "Select maxLicenses from LicenseList where programName = '" + program + "'";


(notice the ekstra ' in the string, which is what SQL considers string delimiters)

[Mrkanin]

thanks...
its working now...