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

Visual Basic .net for beginners - Part 1 : Introduction to Visual basic

This is the first chapter of the tutorial series “Visual Basic .net for beginners” . This series is for absolute beginners in programming . So no previous experience is required.  At the end of this series you will be able to build your own windows, web application in with professional quality standards. This is the introduction part of the series. In this tutorial we will take look at the features of visual basic , .net frame work, visual basic IDE (Integrated Development Environment) and many other things that a visual basic beginner should know.

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