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 are the Types of authentications in IIS
Explain the difference between asp.net mvc and asp.net webforms? : asp.net mvc
what is the trace in ASP.NET
Where is the view state data stored?
Types of state management techniques ?
How to add DateTime Control in normal DataGrid Server Control?
What is web.config. How many web.config files can be allowed to use in an application ?
10 Answers Accenture, BirlaSoft, Infosys, InterGraph, Satyam, Wipro,
To redirect the user to another page which method do we use without performing a round trip to the client?
What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout
how we use web services
What is the Difference B/W Finalize() and Dispose() in .Net?
12 Answers HCL, IBM,
If there is submit button in a from tell us the sequence what happens if submit is clicked and in form action is specified as some other page ?