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

Which is faster ado.net or linq?

1014

---

Is entity framework better than ado.net?

1007

---

Explain how to create dynamic gridview?

969

---

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?

1016

---

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

1157

---

What is bubbled event?

968

---

How would you connect to a database by using .NET?

935

---

What is data view and variable view?

905

---

What is difference between ado and other data object?

909

---

Explain ODP.net

994

---

What does executereader return?

966

---

What is ado oledb and odbc?

935

---

What is a column variable?

934

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

865

---

What is defaultview in datatable?

1024

---