i need code for insert,delete,update adn display records
using stored procedure in C#
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is the size of Get method and how much data it can store?
Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe
explain about Back ground process control in .net
1 Answers Digital Mesh, Infronics,
What are the media types of http requests and response?
What is a postback url?
Which is faster union or union all?
Is it possible to migrate visual interdev design-time controls to asp.net?
What is asp.net with mvc? : Asp.Net MVC
Define managed code and managed data in .net?
Difference between response.redirect and server.transfer?
Various types of Page Load functions
How do you store a value in viewstate and retrieve them?