Answer Posted / ashish kumar gupta

Execute Reader: Use for accessing data. It provides a
forward-only, read-only (Select), connected record set.

Execute Non Reader: Use for data manipulation, such as
Insert, Update, and Delete.

Execute Scalar: Use for Retrieving 1 row 1 col. Value. I.e.
single value. E.g. for retrieving aggregate function. It is
faster than other ways of retrieving a single value from
database.

Name the namespace which is used by ado.net?

959

---

Describe the .net base class library.

1067

---

How long should a session id be?

1041

---

What is sql data source control in asp.net?

1059

---

What is query string in asp.net?

1071

---

What is custom events?

1056

---

What are the memory-mapped files?

1013

---

From which base class all web forms are inherited?

980

---

How to disable disable browser's Back button in asp.net (JavaScript)?

1141

---

If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

981

---

What is variable and constant in .net programming language?

813

---

What’s difference between “optimistic” and “pessimistic” locking?

1072

---

What is the purpose of master page?

915

---

Write some code using interfaces, virtual methods, and an abstract class`

2050

---

What is asp.net introduction?

1014

---