Answer Posted / senthil kumar

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");

i hope that these are enough.

What is the meaning of object pooling?

1310

---

Which ado.net object is very fast in getting data from the database?

1146

---

Does entity framework use ado.net?

1019

---

What is connection in ado.net?

997

---

What is Data view?

1142

---

Define ado.net?

1182

---

What are the advantages using ado.net?

1082

---

What is a data control clerk?

1092

---

What is the difference between sqldatareader and sqldataadapter?

1018

---

What are the data providers in ADO.NET framework?

1074

---

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

1118

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

1032

---

What are two important objects of ADO.Net?

1061

---

What is data adapter in ado.net with example?

1101

---

What are the several execute methods of ado.net?

973

---