(C# and ADO.NET) ExecuteNonQuery() problem

[gicio]

Hi there!

how I can find out why ExecuteNonQuery() return 0 and not 1 by submit?
at this moment I see no chance to know why my query isnt submited.


thx


gicio

 

[a_jam_sandwich]

If you are getting a return value from the execute the query is being run

Check the SQL

it return 0 because no records were affected

Andy

 

[Robby]

Is it a Delete, Update, Insert query?

Are you certain that a row should be affected?