Store data in database using stored procedure and 3-tier architecture

Posted by Vicky193 under ASP.NET on 6/21/2013 | Points: 10 | Views : 2033 | Status : [Member] | Replies : 1
This will give you tested code of how to store data in database using stored procedure as well as 3-tier architecture.
Click on the following link.

http://dotnet-php.blogspot.com/2013/06/how-to-store-data-in-database-using-3.html




Responses

Posted by: Bageshkumarbagi on: 6/21/2013 [Member] Starter | Points: 25

Up
0
Down
hi,

CREATE PROCEDURE insertproduct
@pid int,
@pname varchar(50),
@ptype varchar(50),
@pver varchar(10),
@pdesc varchar(50),
@pprice int
AS
insert into product values(@pid,@pname,@ptype,@pver,@pdesc,@pprice);

once create the store proc first chenge CREATE to ALTER use like this.

ALTER PROCEDURE insertproduct
@pid int,
@pname varchar(50),
@ptype varchar(50),
@pver varchar(10),
@pdesc varchar(50),
@pprice int
AS
insert into product values(
pid=@pid,
pname=@pname,
ptype=@ptype,
pver=@pver,
pdesc=@pdesc,
pprice=@pprice);


i think it will be work. try it


Thanks,
Bagesh Kumar Singh

Thanks,
Bagesh Kumar Singh
Mark as answer if you have been satisfied

Vicky193, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response