Answer Posted / vivek

using Connection object
SqlConnectin cn=new SqlConnection();
from .net we can connect to any backend with middlleware
and direct connections.
middleware means ODBC,OleDb,ISAM etc.
we can directly connect to Sqlserver and Oracle
we can connect to sql server in 4 ways
1)direct connection
2)ODBC way
3)OleDb way
4)Express way
for oracle we can connect in 3 ways.
1)direct connection
2)ODBC way
3)OleDb way

What is the difference between a datareader and a dataset?

1037

---

What does ado stand for in ado.net?

1102

---

What is XML serialization

1060

---

How to connect and retrieve data from database using dataset

1054

---

how can implement dropdownlist in particular of dataset when try to update?

2776

---

What is disconnected architecture in ado.net?

989

---

What are datareaders?

981

---

Is ado.net an orm?

962

---

Is it possible to edit data in Repeater control?

963

---

Which method is used to sort the data in ADO.Net?

1978

---

How many major types of connection objects in ADO.NET?

1035

---

What is ado asp?

996

---

What is difference in record set and dataset?

1075

---

What is disconnected data?

1044

---

What is microsoft ole db provider for sql server?

933

---