i need code for insert,delete,update adn display records
using stored procedure in C#
Answer Posted / 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 |
Post New Answer View All Answers
Describe session handling in a webfarm?
i want the asp.net technical questions and answeres
Explain the use of dataadapter.
What are the two Layouts supported by a Web form in ASP.NET?
What does mvc represent in asp.net? : asp.net mvc
What is the difference between user control and custom control?
What are the different method of navigation in asp.net?
What is a 401 redirect?
Which is better union or union all?
What is difference between view and partial view?
Explain the difference between an exe and a dll?
How many types of file extensions for razor views in ASP.Net MVC?
How does a content page differ from a master page?
How can i explain my project during interview?many time i expalain my project but they did't accept? please explain me.
Explain different types of validators in asp.net?