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.

What is microsoft ado.net?

1078

---

What are the features of ado.net?

964

---

What is openrowset?

928

---

What are the advantages and drawbacks of using ado.net?

1055

---

How to pass multiple tables in datasets simultaneously?

1016

---

What is different between sqlcommand object and command behavior object?

1000

---

What is linq and entity framework?

947

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2341

---

What is basic use of data view?

949

---

Explain the advantage of ADO.Net?

944

---

Compare Data Reader & Dataset in ado.net?

946

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2038

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1010

---

What is the difference between linq and ado.net?

953

---

Where is adodb dll located?

925

---