Home / Stored_Procedure / Insert data into table using stored procedure in asp.net

Thursday, 16 November 2017

Insert data into table using stored procedure in asp.net

Date - 


Insert data into table using stored procedure in asp.net

*At first you create a table in SqlServer given field name in procedure and its datatype which you want.
*Procedure datatype is same as you given in table datatype.
*Then press F5 to execute the stored procedure.

create proc UDP_INSRegistration
(
@UserName varchar(50),
@Addresses varchar(50),
@PhoneNo numeric(11, 0))
as
insert into Regisration(UserName, Addresses,PhoneNo) values(@UserName,@ Addresses,@PhoneNo)
go

exec UDP_INSRegistration 'Bansal','Moradabad',0987654321

Create PROCEDURE UDP_INSRegistration
(
@UserName varchar(50),
@Addresses varchar(50),
@PhoneNo numeric(11, 0))
AS
BEGIN
insert into Registration(UserName,Addresses,PhoneNo) values(@UserName,@Addresses,@PhoneNo)
END

Create PROCEDURE UDP_SELRegistration
AS
BEGIN
select * from Registration
END

Alter  PROCEDURE UDP_INSRegistration
(
@UserName varchar(50),
@Addresses varchar(50),
@PhoneNo numeric(11, 0))
AS
BEGIN
insert into Registration(UserName,Addresses,PhoneNo) values(@UserName,@Addresses,@PhoneNo)
END

Alter  PROCEDURE UDP_SELRegistration
AS
BEGIN
select * from Registration
END

Create proc UDP_DELRegistration
(
@UserName varchar(50),
@Addresses varchar(50),
@PhoneNo nvarchar(50))
AS
BEGIN
DELETE from Registration
WHERE
UserName=@UserName
END

Alter proc UDP_DELRegistration
(
@UserName varchar(50),
@Addresses varchar(50),
@PhoneNo nvarchar(50))
AS
BEGIN
DELETE from Registration
WHERE
UserName=@UserName
END

Create PROCEDURE UDP_UPDRegistration
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
Update Registration set User_Address=@User_Address,User_PhNo=@User_PhNo where UName=@UName
END

Create PROCEDURE UDP_UPDRegistration22
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
Update Registration set UName=@UName,User_Address=@User_Address where User_PhNo=@User_PhNo
END

Create PROCEDURE UDP_DELRegistration
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
DELETE from Registration
WHERE UName=@UName
END

Create PROCEDURE UDP_DELRegistration22
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
DELETE from Registration
WHERE User_PhNo=@User_PhNo
END

Alter PROCEDURE UDP_UPDRegistration
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
Update Registration set User_Address=@User_Address,User_PhNo=@User_PhNo where UName=@UName
END

Alter PROCEDURE UDP_DELRegistration
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
DELETE from Registration
WHERE UName=@UName
END

Create PROCEDURE UDP_SELRegistration22
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
select UName,User_Address from Registration where User_PhNo=@User_PhNo
END

Alter PROCEDURE UDP_SELRegistration22
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
select UName,User_Address from Registration where User_PhNo=@User_PhNo
END

***** Create PROCEDURE UDP_INSRegistration
(
@UName varchar(50),
@User_Address varchar(50),
@User_PhNo nvarchar(50))
AS
BEGIN
insert into Registration(UName,User_Address,User_PhNo) values(@UName,@User_Address,@User_PhNo)
END

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos

Share this

0 comments

Post a Comment

Subscribe to: Post Comments (Atom)