Answer / 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.

Answer / guest

oledb provid universal connection strintg .using oledb we
can conntect to any data base.

Answer / jnan

using system.data.oledb

What is the maximum pool size in ado.net connection string?

0 Answers  

---

Define data access layer?

0 Answers  

---

Explain the namespaces in which .net has the data functionality class.

0 Answers  

---

Explain executenonquery?

0 Answers  

---

How do you connect to sql server database without using sqlclient?

0 Answers  

---

What are the drawbacks of using ado.net?

0 Answers  

---

Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,

---

What are different types of Commands available with DataAdapter ?

1 Answers   Arigo Infotech,

---

Explain the overview of ado.net architecture?

0 Answers  

---

What is meant by executenonquery?

0 Answers  

---

Which type of database is used while processing dynamic database?

1 Answers   Microsoft,

---

How to Handle the exceptions in Sqlsrver2000

3 Answers   SQL Star,

---