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 difference between mvc and asp.net? : Asp.Net MVC
what is the advantage of data reader?
What is the difference between a Thread and Process?
what is wpf and wcf in .net explain with an example?
What is GAC in ASP.NET 2.0
Which two new properties are added in asp.net 4.0 page class?
Types of caching ?
different architectures of asp.net?
how to encrypt a connection string in web.config file?
What is Bundling and Minification in MVC?
Describe Segmentation With Paging?
How do we assign page-specific attributes?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)