Answer / 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.

Answer / guest

oledb provid universal connection strintg .using oledb we
can conntect to any data base.

Answer / jnan

using system.data.oledb

What are the various methods provided by the DataSet object to generate XML?

0 Answers  

---

What is the purpose of using adodb?

0 Answers  

---

What are the differences between OLEDB and SQLClient Providers?

0 Answers  

---

differences between ADO and ADO.NET

0 Answers   Microsoft,

---

Can we do database operations without using any of the ado.net objects?

0 Answers  

---

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  

---

What is Serialization in .NET? what are the types of Serialization?

0 Answers   Arigo Infotech,

---

Which method is used by command class to execute SQL statements that return single value?

0 Answers  

---

What is ado.net code?

0 Answers  

---

What is a sqldataadapter?

0 Answers  

---

What is ole used for?

0 Answers  

---

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,

---