For Asp.net Training Fill the Enquiry Form
(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:-
In this table id is an identity column.
Create stored procedure for the insertion. I have created the stored procedure using input parameters:-
create proc data_ins( @name varchar(100),@age int)
insert into emp values( @name, @age)