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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
How can u deifne the benefits and limitation of using Viewstate for state management?
What is the purpose of session management?
Difference between web user control and web custom control?
How to use a Master Database in Asp.net?
When does a session actually start?
Where is asp.net view state stored?
What are sharepoint pages?
Explain what is the procedure to create the environment for asp.net? : asp.net mvc
Name some asp objects?
What is the significance of proxy user?
how can create login from create and written conde in asp.net
How does the iis work?
What are the 3 types of web?
What are the merits and demerits of viewstate?
Which method do you use to kill explicitly a users session?