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

Define data adapter?

0 Answers  

---

Difference between sqlcommand and sqlcommandbuilder?

0 Answers  

---

What are the steps you will take to improve performance?

0 Answers  

---

How do u implement locking concept for dataset?

2 Answers   ABC,

---

describe the dataset object in ado.net.

0 Answers  

---

What is Data Provider?

0 Answers  

---

Why is it important to close an ado.net application?

0 Answers  

---

Explain the various objects in dataset.

0 Answers  

---

What is execute reader in ado.net?

0 Answers  

---

what is Execute NOn Query?

29 Answers   Infosys, Protech, Sars Systems, SwanSoft Technologies,

---

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

3 Answers   TCS,

---

What are the different execute methods of Ado.Net?

0 Answers  

---