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 ?

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.