About ExecuteNonQuery ?

[papyrus_lei]

when i use procedure CommandType is procedure and then run ExecuteNonQuery() the return value of ExecuteNonQuery() is always -1 so the return value of ExecuteNonQuery is useless when use procedure?

[cshaaaa]

It executes the query and just return the no of rows affected.:laugh:

[Anish Gopi]

Hai For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1. For more information See SqlCommand.ExecuteNonQuery Method[^]

[Anonymous]

the procedure execute correctly and the data in DB changed. but the return value is -1 why? return value just useful when execute sql query?

[papyrus_lei]

thanks!

[papyrus_lei]

thanks! ^_^