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

Which is the best institute in navi mumbai to learn DotNet

2 Answers  

---

Is bulk insert faster than insert?

0 Answers  

---

Describe datareader object of ado.net with example.

0 Answers  

---

How to creating a SqlCommand Object?

0 Answers   Arigo Infotech,

---

List the 4 common ado.net namespaces?

0 Answers  

---

Which type of database is used while processing dynamic database?

1 Answers   Microsoft,

---

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

---

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

0 Answers   Arigo Infotech,

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers  

---

What does ado stand for in ado.net?

0 Answers  

---

What is ado or jdbc?

0 Answers  

---

What is the hierarchy of data in databases?

0 Answers  

---