For Asp.net Training Fill the Enquiry Form
Stored Procedure
(with input
parameter) in ADO.Net
Stored procedure is the precompiled form of queries which executed to perform some
task. We can also call stored procedure using Ado.net.
In this task I have created insertion
procedure for the following table insertion:-
Figure 1
In this
table id is an identity column.
Step 1:-
Create
stored procedure for the insertion. I have created the stored procedure using
input parameters:-
create proc data_ins( @name varchar(100),@age int)
as
insert into emp values( @name, @age)
