PC Review


Reply
Thread Tools Rate Thread

ExecuteNonQuery returns wrong number of records affected.

 
 
Vince Varallo
Guest
Posts: n/a
 
      26th Aug 2003
Hello All,

I am using the command.ExecuteNonQuery() method to execute
an update statement. I then check the return value to see
how many records were affected by the update. This used
to work in .NET 1.0, but when we upgraded to .NET 1.1 it
now returns -1. Has anyone else experienced this?

Thanks in advance,
Vince
 
Reply With Quote
 
 
 
 
Roy Osherove
Guest
Posts: n/a
 
      27th Aug 2003
Are you sure you didn't set NO COUNT off or something?
I work with 1.1 and it works great..

--
Regards,

Roy Osherove
http://www.iserializable.com
---------------------------------------------

"Vince Varallo" <(E-Mail Removed)> wrote in message
news:0fab01c36bea$c7dd1520$(E-Mail Removed)...
> Hello All,
>
> I am using the command.ExecuteNonQuery() method to execute
> an update statement. I then check the return value to see
> how many records were affected by the update. This used
> to work in .NET 1.0, but when we upgraded to .NET 1.1 it
> now returns -1. Has anyone else experienced this?
>
> Thanks in advance,
> Vince



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find out records number affected? =?Utf-8?B?SXZhbiBBYnJhbW92?= Microsoft ADO .NET 3 30th Jan 2007 11:02 AM
ExecuteNonQuery returns ORA-01036 illegal variable name/number Jim Brandley Microsoft ADO .NET 6 15th Apr 2005 05:14 PM
SQLCommand.ExecuteNonQuery returns wrong number Harry F. Harrison Microsoft ADO .NET 5 7th Sep 2004 10:44 PM
Number of rows affected for OleDbCommand.ExecuteNonQuery Reece Laurie Microsoft ADO .NET 3 23rd Jun 2004 10:37 AM
ExecuteNonQuery returns wrong results??? Vince Varallo Microsoft Dot NET 0 26th Aug 2003 05:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:30 PM.