CRUD operations in vb.net using stored procedure

Stored procedure is basically a way of keeping your database layer separate from your program's code. You will store all SQL commands you'd like to execute in a stored procedure in your database server that you can use externally. A stored procedure is a set of SQL statements stored in a relational database as a group with a name, so that it can be reused by multiple programs or shared by multiple programs.

There are various benefits of using a store procedure in your database programs like eliminating the risk of SQL Injection attack because all the parameters used will be populated dynamically. Since, a Store procedure is compiled once and is stored in the database in executable form as a result of which the procedure calls are very quick and very efficient. The Executable code is cashed automatically and shared among many users resulting lower memory requirement. Another advantage of using store procedure is that SQL statements are grouped in the database allowing them to be executed with a single call which minimises the usage of slow network, reduces network traffic and improves overall round-trip response time.

In this article we will discuss

• creating a new record in VB.Net and SQL server using a store procedure
• Reading a record in VB.Net and SQL server using a store procedure
• Update a record in VB.Net and SQL server using a store procedure
• Delete a record in VB.Net and SQL server using a store procedure

CRUD which stands for Create, Read, Update and Delete is basically a functionality to insert a record into a database table, Read a record from the database table, Update a record in a database table or delete a record from a database table. In this article we will discuss • creating a new record in VB.Net and SQL server using a store procedure • Reading a record in VB.Net and SQL server using a store procedure • Update a record in VB.Net and SQL server using a store procedure • Delete a record in VB.Net and SQL server using a store procedure

In this video I will teach you how to create CRUD operations in vb net using stored procedure. The CRUD which stands for Create, Read,Update and Delete is basically a functionality to insert a record into a database table, Read a record from the database table, Update a record in a database table or delete a record from a database table.

VB.Net