delete error from database

[Ashraf zia]

i am deleting a record from the database and i get an exception message : datatype mismatch, i have the following query for deleting a reocrd from the database: string query = "delete from registration where id = '"+ Convert.ToInt16(this.id.Text)+"'"; its point to the line 568 which contains: com.ExcecuteNonQuery();

[Elina Blank]

What is the type of your id column. According to your query it must be tinyint. do Convert.ToInt32, if it is of type int

Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O

[Russell Jones]

if it's an int type you shouldn't use the single quote characters what db are you using sql server normally likes delete where id = 7 access tends to like Delete * from where id = 7 i would guess it's a type conversion thing though, by putting the ' char in you make the data provider pass it as a string type HTH Russ

[ednrgc]

remove the single quotes and it will work.