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

How do you sort the data in datagrid?

4 Answers   Choice Solutions,

---

What is the difference between connected and disconnected environment?

0 Answers  

---

How do you implement locking concept for dataset?

0 Answers  

---

Why do we serialize data?

0 Answers  

---

differences between ADO and ADO.NET

0 Answers   Microsoft,

---

What is ado and dao?

0 Answers  

---

What is difference between sqldatareader and sqldataadapter?

0 Answers  

---

How does entity framework work?

0 Answers  

---

Which method is used to sort the data in ADO.Net?

0 Answers  

---

What is variable view?

0 Answers  

---

What is the difference between sqlcommand and sqldataadapter?

0 Answers  

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  

---