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 the usage of DelegatingHandler?
What are tuples?
Which is the best institute to learn Microsoft Technologies and the faculty if you Know?
What is difference between viewstate and session state in javascript?
What is a proxy in web service?
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
What is the difference between CC and BCC?
What does the hotspot class in .net do?
What are the best practices to follow to secure connection strings in an ASP.NET web application?
What is variable and constant in .net programming language?
To bind columns manually which tags do you need to add within the asp:datagrid ?
Is asp.net mvc still used? : Asp.Net MVC
Who creates jsessionid?
Explain one critical mapping?
What is the difference between visual basic and asp.net?