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 difference cookie and session?

0 Answers  


What is the difference between debug and release?

0 Answers  


Can you edit data in the Repeater control?

11 Answers   CAC, Creative,


what are partial classes and their use?

3 Answers   Microsoft,


Explain the different types of assemblies?

0 Answers  






Why is validation always done on the server? When does that occur?

2 Answers  


What is session authentication?

0 Answers  


Explain the difference between Repeater and Data list control in ASP.NET?

0 Answers  


what is the difference between primary key and foreign key?

2 Answers  


How would one do a deep copy in .NET?

6 Answers   TCS,


When does a session actually start?

0 Answers  


To bind columns manually which tags do you need to add within the asp:datagrid ?

0 Answers   Siebel,


Categories