Answer Posted / 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

What are the HTML server controls in ASP.NET?

1050

---

Explain the different parts that constitute ASP.NET application?

968

---

What is base class of .net?

911

---

What is enableviewstate in asp net?

906

---

Explain the difference between sql invalidation and sql notification.

926

---

What is the difference between file-based dependency and key-based dependency?

1014

---

List the types of authentication supported by asp.net?

889

---

Why session management is required?

954

---

What is caching? What are different ways of caching in asp.net?

1222

---

1.what is the application pool. 2.what is the HttpModile and Http Handler. 3.C# 3.0 Features ? 4.Anonoymous Type,methopd and claas in 3.0? 5.difference between statsic and const ? 6.session vs application 7.state management clint side and server side ? 8.Genric list 9.c# 3.0 vs 3.5

2107

---

Which method is used to perform all validation at the page level?

917

---

What is viewstate in asp net with example?

946

---

What are the asp.net list controls and difference between them?

972

---

How dataadapter.fill works?

985

---

What are the event handlers that we can have in global.asax file?

929

---