Executenonquery - Executes Successfully But Changes Not Reflected In The Database?

im using VS2005. and the built-in sql express.when i run my code in debug mode, i can see that the required number of rows are being affected correctly.but when i actually go and see in the table data, the data has not been inserted/updated.i am using sqlcommand. executeNonQuery() to insert/update data.also, i must add that both executeScalar and executeReader are working perfectly.what could be the possible reason for executeNonQuery although showing the number of rows affected but does not actually do it when seen in the table data?int x = cmd.ExecuteScalar(); // X SHOWS 2 OR 3 depending on the number of rows affected.