Answer Posted / 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 the difference between dataset and datatable?

986

---

What is difference between datatable and dataset?

1042

---

How to read data with the sqldatareader ?

956

---

What is the difference between OLEDB Provider and SqlClient?

970

---

How to generate a single aggregate?

965

---

What is difference between executequery and executeupdate?

974

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2125

---

What are the namespaces used in ADO.Net to connect to a database?

1184

---

Compare Data Reader & Dataset in ado.net?

976

---

How can we add/remove row's in "datatable" object of "dataset"?

1001

---

Explain how to create dynamic gridview?

952

---

What is read only and forward only in ado.net?

926

---

How to retrieve the user id which is provided while windows authentication?

1079

---

Explain how to pass multiple tables in datasets simultaneously?

1015

---

What is the meaning of executenonquery?

1031

---