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 |
How .net CLR works with n-tier application
How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server
what is the jit? what is the type of jit and purpose of it>
What is datagrid asp.net?
what is caching?
What is sdlc process?
4. How do you plan to achieve these goals?
7 Answers Burger King, Latest, Swatz Oils,
How do sessions work?
Why do we need Sessions?
How do you relate an aspx page with its code behind Page?
What is an iHTTPModule, and explain its implementation with its limitations?
Explain what does wsdl stand for?