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 Dynamic Web and discuss its usage with the help of real life examples?

0 Answers   Huawei,

---

With example & diagram explain AutoPostBack.

2 Answers  

---

What is the difference between Classic ASP and ASP.Net?

0 Answers  

---

What does the following SQL statement return, assuming that all tables and column names are correct? SELECT FirstName, StreetAddress FROM Employees JOIN AddressBook ON Employees.EmpID = AddressBook.EmpID a) Nothing, the JOIN syntax is wrong. b) All the records form the Employees table, and only the matching ones form the StreetAddress table. c) All the records from the StreetAddress table and only the matching records form the Employees table. d) Only the matching records from the two tables.

4 Answers   Syntax Softtech,

---

Explain about the .NET framework?

0 Answers  

---

Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

0 Answers   Hexaware, Infosys,

---

Where does Web.Config Info stored? Will this be stored in the registry?

4 Answers   Accenture,

---

what is difference between .net 3.0 and 3.5

3 Answers  

---

Can you create an app domain ?

1 Answers  

---

What?s the difference between Codebehind="MyCode.aspx.cs" andSrc="MyCode.aspx.cs"?

5 Answers   SLC Ltd,

---

What is difference between session and viewstate?

0 Answers  

---

when a request is made in Life cycle of ASP.NET page .

0 Answers  

---