Answer Posted / senthil kumar

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

i hope that these are enough.

Does executenonquery return a value?

954

---

Describe ado.net object model in detail.

997

---

What is data view and variable view?

923

---

What is the difference between DataReader and DataSet in ADO.NET?

1164

---

Which is faster datareader or dataadapter?

992

---

What is a control toolbox?

968

---

What does datareader object do?

1007

---

Define connection string?

1072

---

Explain the role of data provider in ado.net?

992

---

What are the data providers used in ado.net

1021

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1023

---

What is the current version of entity framework?

969

---

List all the steps in order, to access a database through ado.net?

1086

---

What is the difference between a datareader and a dataset?

1043

---

What is the difference between dataset and datatable?

1012

---