how i can compare id as integer value stored in access with a query value that is in string

Question

User2095221599 posted

how i can compare id as integer value stored in access with a query value that is in string i am getting an error message 

data type  mismatch i m using           where id = ' "+label1.text +" '

thanks in anticipation  

Answer 1

User-693248168 posted

Give this command

where id =  "+label1.text +" 

i.e. dont give the single quotes before and after the ID value.

Answer 2

User-1199946673 posted

Start using parameterized queries:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

 

Answer 3

User1867929564 posted

where id = =  "+Convert.ToInt32( label1.text) +" 

Answer 4

User-821857111 posted

where id = =  "+Convert.ToInt32( label1.text) +" 

That's worse than the first reply in that it doesn't even use valid SQL. The Convert.ToInt is totally unnecessary as the SQL statement to be executed is a string, so it will be converted back to a string when it is concatenated.

Hans is right. The OP's problem will be solved by using parameter queries, and they will be following recommended practice too.