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

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

What is the difference between mvc and asp.net? : Asp.Net MVC

0 Answers  

---

what is the advantage of data reader?

2 Answers  

---

What is the difference between a Thread and Process?

1 Answers  

---

what is wpf and wcf in .net explain with an example?

2 Answers  

---

What is GAC in ASP.NET 2.0

0 Answers   MCN Solutions,

---

Which two new properties are added in asp.net 4.0 page class?

0 Answers  

---

Types of caching ?

3 Answers   TCS,

---

different architectures of asp.net?

1 Answers  

---

how to encrypt a connection string in web.config file?

3 Answers   Hexaware,

---

What is Bundling and Minification in MVC?

0 Answers   HCL,

---

Describe Segmentation With Paging?

0 Answers   MaxSolPro,

---

How do we assign page-specific attributes?

0 Answers  

---