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 are the ado.net objects?

0 Answers  

---

What we do with the object of ado.net dataset after using it?

0 Answers  

---

What is the use of connection object in ado.net?

0 Answers   TryTechnicals Pvt Ltd,

---

Explain the difference in an abstract class and an interface?

0 Answers  

---

how would i implement dropdownlist in gridview using c#

2 Answers  

---

Can we connect two dataadapters to same data source using single connection at same time?

0 Answers  

---

What is difference between executequery and executeupdate?

0 Answers  

---

Define Execute Reader?

0 Answers  

---

How xml files and be read and write using dataset ?

1 Answers  

---

What is data access pattern?

0 Answers  

---

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers  

---

Describe ado.net object model in detail.

0 Answers  

---