ExecuteNonQuery() returning -1

Have you got a trigger running on your table[^]?

"For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1."

If not, you might have an issue with the code.

Have a look here: ServerConnection.ExecuteNonQuery Method [^]

It says:
Return Value: An Int32 value that specifies the total number of rows affected by the Transact-SQL command for UPDATE, INSERT, and DELETE statements. For all other types of statements, the return value is -1.

Now, it depends on what are you doing. Though you say Inserting, but looks like not in a proper expected way.

ExecuteNonQuery in your case is not executing any command directly. It executes a stored procedure. Hence it will not return the number of rows affected. You will have to get that inside in your stored procedure and send it back as an out parameter.

You ask if there is a problem with your code and then proceed to not show it.

Paste some code and it would help! :)

i have found the solution , hence i m using store procedure thats y it is returning -1 other wise it returns 1 in queries