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.

Define ado.net?

1185

---

What are the benefits of using ado.net?

1050

---

What are the connected and disconnected modes in ado.net?

964

---

What is ado code?

998

---

Is it possible to load multiple tables in a Dataset?

1144

---

What is oledb driver?

996

---

What providers does Ado.net uses?

1064

---

What is difference between ado.net and asp net?

1091

---

What is datasource in ado.net?

1125

---

What is difference between datatable and dataset?

1128

---

What is the usage of the dataset object in ado.net?

1005

---

What are the usages of the command object in ado.net?

1070

---

What are the steps you will take to improve performance?

946

---

What is aggregating data ?

1026

---

How can we serialize the dataset object?

1053

---