How to return a value from stored procedure to Visual Basic.NET

Here I am going to show you how to return a value from a stored procedure written in SQL Server. As the first step we need to create a stored procedure that returns a value. In my case, I have a database called car and a table in it called tblCar. For counting the number  of row I used the following stored procedure.

If you don’t know how to create a stored procedure in SQL Server, please read this tutorial before we start.

http://tutz4u.blogspot.in/2014/03/how-to-make-stored-procedure-in-sqlserver.html

Simple steps to create stored procedure in SQL Server : Using SQL Server Management Studio Or Visual Studio

Here is a simple tutorial on how to create and use stored procedure in SQL server with Visual Studio IDE or  SQL Server Management Studio. Stored procedures are the most secured, structured, efficient method to access data from SQL server.

Step 1 :

(If you have SQL Server Management Studio)

Open  SQL Server Management Studio and  choose the server to connect and provide username and password if necessary and