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 benefits of ADO.NET?

0 Answers   B-Ways TecnoSoft,

---

What is typed dataset ?

0 Answers   NA,

---

What are the types of databinding?

0 Answers  

---

What is ole word?

0 Answers  

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers   Infosys, Wipro,

---

Explain the advantage of ADO.Net?

0 Answers  

---

What two types of data providers does ADO.NET supply? What determines which one you should use?

0 Answers   CDC,

---

What is the provider being used to access oracle database?

0 Answers  

---

Define data access layer?

0 Answers  

---

FetCh Records No 5 to 10 From Dataset

4 Answers  

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  

---

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

---