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

How .net CLR works with n-tier application

4 Answers   HCL, Hughes,


How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server

0 Answers   CTPL,


what is the jit? what is the type of jit and purpose of it>

2 Answers   Honeywell,


What is datagrid asp.net?

0 Answers  


what is caching?

4 Answers   Microsoft,


What is sdlc process?

0 Answers  


4. How do you plan to achieve these goals?

7 Answers   Burger King, Latest, Swatz Oils,


How do sessions work?

0 Answers  


Why do we need Sessions?

0 Answers   QuestPond,


How do you relate an aspx page with its code behind Page?

2 Answers   Accenture,


What is an iHTTPModule, and explain its implementation with its limitations?

1 Answers   Siebel,


Explain what does wsdl stand for?

0 Answers  


Categories