i need code for insert,delete,update adn display records
using stored procedure in C#

Answers were Sorted based on User's Feedback



i need code for insert,delete,update adn display records using stored procedure in C#..

Answer / poornima

create proc produrename
@id int,
@name varchar(50),
@Add varchar(50),
@choice Varchar(30)

as
begin
if(@choice='insert')
begin
insert into tablename values(@id,@name,@Add)
end
if(@choice='update')
begin
update tablename set name=@name,Add=@Add where id=@id
end
if(@choice='delete')
begin
delete from tablename where id=@id
end
if(@choice='display')
begin
select * from tablename where id=@id
end
end

Is This Answer Correct ?    9 Yes 0 No

i need code for insert,delete,update adn display records using stored procedure in C#..

Answer / poornima

create proc produrename
@id int,
@name varchar(50),
@Add varchar(50),
@choice Varchar(30)

as
begin
if(@choice='insert')
begin
insert into tablename values(@id,@name,@Add)
end
if(@choice='update')
begin
update tablename set name=@name,Add=@Add where id=@id
end
if(@choice='delete')
begin
delete from tablename where id=@id
end
if(@choice='display')
begin
select * from tablename where id=@id
end
end

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What is the size of Get method and how much data it can store?

0 Answers   HCL,


Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe

1 Answers  


explain about Back ground process control in .net

1 Answers   Digital Mesh, Infronics,


What are the media types of http requests and response?

0 Answers  


What is a postback url?

0 Answers  






Which is faster union or union all?

0 Answers  


Is it possible to migrate visual interdev design-time controls to asp.net?

0 Answers  


What is asp.net with mvc? : Asp.Net MVC

0 Answers  


Define managed code and managed data in .net?

0 Answers  


Difference between response.redirect and server.transfer?

0 Answers  


Various types of Page Load functions

4 Answers   Net Solution,


How do you store a value in viewstate and retrieve them?

0 Answers  


Categories