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 ado.net components?

965

---

Explain the difference between ado and ado.net?

941

---

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

1038

---

What is data control techniques?

960

---

What is a control toolbox?

968

---

What is ado full form?

1020

---

What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1061

---

What are the key features of ado.net?

1199

---

What are the different execute methods of Ado.Net?

1026

---

What is datasource in ado.net?

1072

---

What is the difference between oledb sql server and oledbdotnet provider?

1014

---

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1032

---

How will you fill the gridview by using datatable object at runtime?

1057

---

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

943

---

What is a datareader object?

1099

---