Answer Posted / srikant dwibedi

using OLEDB connection we can connect the MS-ACCESS,Sql
Server,Oracle.

here i given the coding for connect the oledb connection

OleDbConnection con = new OleDbConnection();
con.ConnectionString="Provider=Microsoft.Jet.OleDb.4.0;Data
Source=databasenamewithpath;";
con.Open();

then u can use the dataset or datareader
OleDbCommand cmd = new OleDbCommand(sql,con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();


OleDbDataReader reader;
reader = cmd.ExecuteReader();


OleDbDataAdapter oda = new OleDbDataAdapter(sql,con);
DataSet ds = new DataSet();
oda.Fill(ds,"tablename");

What is a data control clerk?

1095

---

What is the difference between sqldatareader and sqldataadapter?

1018

---

Explain executenonquery?

1220

---

What is the use of connection object in ado.net?

1091

---

What is microsoft ado.net?

1221

---

How to pass values into a datatable?

1178

---

What is a dynaset in access?

1106

---

What is the functionality of data provider in ado.net?

989

---

What are the different row versions available in table?

1027

---

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

1131

---

Explain the difference between ado and ado.net?

993

---

What is connected architecture in ado.net?

1179

---

What is fill method in ado.net?

1028

---

Define atomicity?

1087

---

How is entity framework different from ado.net?

1001

---