Answer Posted / sinthu vijay kumar

hi friends...

we have so many databases for ex oracle,sql
server,sybase,ms Access etc.providers are used to giving
the connecion to the database ,which r different for
different databases.the avilable providers in ado.net are
oracle.net data provider,odbc.net dataprovider etc.
the syntax for provider is:
con=new odbcconnection
("uid=scott,pwd=tiger,database=oracle")
here uid,pwd,database r vary with different databases.

What are the benefits of using of ADO.NET in .NET 4.0?

1153

---

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

---

What connected data?

1024

---

Explain the namespaces in which .net has the data functionality class.

1155

---

Do we use stored procedure in ADO.Net?

1057

---

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

1248

---

How can we perform transactions in .net?

1104

---

List all the steps in order, to access a database through ado.net?

1126

---

Explain the difference between ado and ado.net?

997

---

What is the difference between data reader and data adapter?

1073

---

What are the key features of ado.net?

1273

---

How can we check that some changes have been made to dataset since it was loaded?

1016

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

1069

---

List the 4 common ado.net namespaces?

1239

---

What is the difference between statement and preparedstatement interface?

1053

---