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
Explain the various authentication mechanisms in asp.net.
How u refer webservices?
Explain some of the major built-in objects in asp.net
From which base class all web forms are inherited?
Contrast oop and soa. What are tenets of each16. How does the xmlserializer work? What acl permissions does a process using it require?
What is the differences between a primary key and a unique key in sql server?
Is it possible to apply themes to an asp.net application? If yes, then how?
Explain what are webservices?
What is the parent class of all the web server control?
What can you do with asp.net?
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is & in a url?
How do you store a value in viewstate and retrieve them?
What is use of <% %> in asp.net?
How does a web application session work?