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
What is difference between ispostback and autopostback in asp net?
What are html helpers in asp.net?
What does passport and windows authentication mean in ASP.NET?
Is asp.net and .net same?
How does session work?
What is the significance of proxy user?
What is runat?
Explain the difference between server control and html control.
What are the merits and demerits of viewstate?
What is http protocol and how it works?
Explain the difference between AutoPostBack and IspostBack in ASP.NET?
14. What are your Future Plans for Swatz Oils GROUP U.K?
How do we access view state value of this page in the next page?
Explain the difference between asp & asp.net.
What’s the catch?