<div>
Turns out when I looked at the teamates sp it was usinga &nbsp;return param value that needed to be capture and not a row affected count. &nbsp;Switched to executescalar and all is well!
</div>


Turns out when I looked at the teamates sp it was usinga  return param value that needed to be capture and not a row affected count.  Switched to executescalar and all is well!

<div>
<div class="content wysiwyg-content">
I have a stored procedure that deletes a single record (based on unique id) &nbsp;When I run this from query analyzer it returns the out param as 1. &nbsp; When I call this from .NET ExecuteNonQuery(cmd) it return a 19 which by definition is 19 records affected. &nbsp;I have verified things by putting a new, single record in and deleting it via sql analyzer, then entering a single record and trying to delete it from ExecuteNonQuery. &nbsp;It deletes but the return value is wrong and causes the rest of the app (which is expecint a 1) to cough. &nbsp;Thougts?
</div>
</div>


I have a stored procedure that deletes a single record (based on unique id)  When I run this from query analyzer it returns the out param as 1.   When I call this from .NET ExecuteNonQuery(cmd) it return a 19 which by definition is 19 records affected.  I have verified things by putting a new, single record in and deleting it via sql analyzer, then entering a single record and trying to delete it from ExecuteNonQuery.  It deletes but the return value is wrong and causes the rest of the app (which is expecint a 1) to cough.  Thougts?

ExecuteNonQuery return wrong value .NET 2.0

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.