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
Explain about the Class view window?
Define dll hell?
What is the postback property in asp.net?
Which is better viewstate or session?
What is ispostback property?
What is viewstate? In which event of the page life cycle, is the viewstate available?
Explain the path instructions in xaml?
What are the features that make asp.net more used framework? : asp.net mvc
How many types of Cookies are available in ASP.NET?
What is state management in .net?
In early binding will the method invoked on com component will verify it?s existance in the system or not ?
How does asp net store session ids by default?
What is a form tag?
What is boxing and unboxing in asp.net?
Do I need to have the latest version of windows media player installed?