Answer Posted / harikumar m

1.
Connected Uses: Data Provider(It Includes
Connection,DataCommand,DataReader)
Disconnected Uses: Data Set,Data Adapter

2.
Connected: Network traffic is high,poor in Performance
DisConnection: Network traffic is low,Good in Performance

3.

Connected: Data is up to date
Disconnected: Data is not up to date

4.
Connected: 'Join' can be used to relate two tables
Disconnected: DataRelations(a Class) can be used to relate
two tables

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2378

---

What is the difference between executequery and executenonquery?

909

---

How is entity framework different from ado.net?

945

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1018

---

What is microsoft ole db provider for sql server?

931

---

What is a control toolbox?

966

---

What is the difference between DataReader and DataSet in ADO.NET?

1159

---

Explain how to pass multiple tables in datasets simultaneously?

1032

---

What is difference in record set and dataset?

1072

---

What DataReader class do in ADO.NET ?

1093

---

Which database is the ado.net?

973

---

Describe the disconnected architecture of ADO.NET’s data access model.

1060

---

Define connection string?

1066

---

Which provider is used to connect ms access, oracle, etc…?

999

---

Explain the difference between sqlcommand object and command behavior object?

1080

---