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

What is an orm, and why would you use one instead of plain old ado.net?

0 Answers  

---

Is datareader faster than datatable?

0 Answers  

---

How to identify the controls which can be used for binding data?

0 Answers  

---

how to keep track of index in listbox items.

2 Answers  

---

What is the difference between the clone() and copy() methods of the dataset class?

0 Answers  

---

Why is stored procedure used in ado.net?

0 Answers  

---

once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

---

Explain the difference in record set and dataset?

0 Answers  

---

How we can provide data to ado.net?

0 Answers  

---

Difference between sqlcommand and sqlcommandbuilder?

0 Answers  

---

What are the ado.net objects?

0 Answers  

---

Is entity framework better than ado.net?

0 Answers  

---