Answer / Shivendra Pratap

Stored procedures are used in ADO.NET for various reasons, such as optimizing data access performance by reusing pre-compiled SQL statements, enforcing database security and integrity by restricting the types of queries that can be executed on a database server, improving application maintainability by encapsulating complex business logic within the stored procedure, and reducing network traffic by executing multiple SQL statements as a single unit.

HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND PROGRAMING?

4 Answers  

---

What is data adapter in ado.net with example?

1 Answers  

---

Explain how to create dynamic gridview?

1 Answers  

---

What is the use of data grid?

1 Answers  

---

Explain how to pass multiple tables in datasets simultaneously?

1 Answers  

---

Diff b/w DataReader,Dataset and Data table?

5 Answers   HCL,

---

Explain all the classes those are used for database connections between sql server and asp.net?

1 Answers  

---

What is the current version of entity framework?

0 Answers  

---

What is openquery?

1 Answers  

---

What is a dataset?

3 Answers  

---

What is typed dataset ?

1 Answers   NA,

---

What is the provider and namespaces being used to access oracle database?

4 Answers   Microsoft,

---