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 sqlconnection and sqlcommand?

0 Answers  

---

What is the provider and namespaces being used to access oracle database?

4 Answers   Microsoft,

---

Which property is used to check whether a DataReader is closed or opened?

0 Answers  

---

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example.

5 Answers   Softcon, Tecra,

---

How can we check that some changes have been made to dataset since it was loaded?

0 Answers  

---

What are all the different authentication techniques used to connect to MS SQL Server?

0 Answers  

---

Which provider is used to connect ms access, oracle, etc…?

0 Answers  

---

Name which operations can you not perform on an ado.net dataset?

0 Answers  

---

What are the different ado.net namespaces are available in .net?

0 Answers  

---

Which is the feature of ado.net?

0 Answers  

---

What is a data control clerk?

0 Answers  

---

What are the namespaces used in ado.net for data access?

0 Answers  

---