Data type mismatch in criteria expression.

Hi Ravi,

 

Please check your table column dataypes.

 

In textbox all the values will be consider as string. 

 

ex : in textbox if you enter the value 10 , c# will consider it as string "10" .

 

if you want to save it as number , please use Convert.ToInt32(yourvalue) 

 

So please check your table columns datatype for  "City_Details","Status"

 

If both column is declared as "Text", there is some issue. If anyone has number or datetime , you are getting this error. Please check your tables. 

Hey

 

The error seems that you are passing wrong datatype value to the database.

 

Make sure to pass string to string or int to int correctly.

 

Rectifying this will solve your issue.