Member Avatar for HunainHafeez

is it true that no. of rows affected by select statement (ado.net) , is always -1.
i.e. NO. OF ROWS AFFECTED BY SELECT STATEMENT = -1 ;

if it is then why ?

  • 2 Contributors
  • 1 Reply
  • 178 Views
  • 5 Minutes Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

Hmm.. wasnt aware of that. Are you indicating that you see that behaviour for ADO.NET? You can get the number of rows affected in SQL...

SELECT @@rowcount AS 'TotalRows'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.