Answer Posted / siddhartha sharma

using System.data.oledb;
oledbdataadapter da;
dataset ds;
da=new data Adapter("select * from
Databasename","connection string");
ds=new dataset();
da.fill(ds);// fetch the database to frontend
//// we use that syntex to fetch oracle database to our
application

What is the return type of executescalar?

498

---

What are all the different authentication techniques used to connect to MS SQL Server?

550

---

What does datareader object do?

546

---

What is the default Timeout for SqlCommand.CommandTimeout property?

514

---

What is a dataview?

539

---

---

Compare Data Reader & Dataset in ado.net?

557

---

Is it possible to edit data in Repeater control?

535

---

Why do we serialize data?

502

---

Which keyword is used to accept variable number of parameters?

692

---

What are the rules to implement connection pooling?

513

---

What are dataproviders?

555

---

What is the default provider in ado.net?

520

---

How to add a check box or a dropdown list to a column in a datagrid?

542

---

How does ado.net work?

494

---

How to Read, Add, Update and Delete record in Entity Framework ?

574

---