c# – How to Insert and Update through stored procedure in SQL Server and return total no of row affected

For Insertion and updating of rows for my asp.net website I’ve created a stored procedure. I want to return total no of rows (insert + update). My stored procedure works fine when I “Execute” this SP by placing value of variable manually but when run it my website, no row update or insert. Here Is … Read more