Answer / om shivaya namaha

Cursors are used to fetch the records row by row data in a
table but get the data very fast by using the cursors it is
very useful if the table contains few records in a table but
will create a performance isses if the table contain lot of
records

create cursor cursorName for
select EmpId,EmName from Employees
open cursor
while (@@FetchStatus==0)
begin
fetch next from cursorName into @EmpId , @EmName
select * from Employee where empid=@empid
end
close cursor

Can you store dataset in viewstate?

7 Answers   Microsoft,

---

What is X-Path?

2 Answers   Sherston,

---

How to do Forms authentication in asp.net?

2 Answers  

---

Explain what is an abstract class?

0 Answers  

---

What is the use of SmartNavigation property?

4 Answers  

---

---

Explain the updatepanel?

0 Answers  

---

what is the difference b/w .net 1.1 and 2.0 ?

2 Answers   Polaris,

---

What are the asp.net objects? is it application obects, cache objests etc. or is it state managements, web services etc?

3 Answers   Syntel,

---

What are the different types of Session state management options available with ASP.NET?

1 Answers  

---

Usage of web.configuration ?

3 Answers   Microsoft,

---

Define the types of configuration files.

0 Answers  

---

What is the use of directives & explain with example?

2 Answers   C Squared Systems,

---