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 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.