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

IF we have lot of records in Database. How we can handle them?

5 Answers   Honeywell,

---

How do you implement locking concept for dataset?

0 Answers  

---

What is two way data binding android?

0 Answers  

---

What is ado circle?

0 Answers  

---

What are the ado.net objects?

0 Answers  

---

What are the methods of XML dataset object?

0 Answers  

---

What are the Different layers in ADO.Net?

7 Answers  

---

What are good ado.net object to replace to ado recordset object.

0 Answers  

---

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

5 Answers   IBM, Veegyapan Impacts,

---

Describe the command object and its method.

0 Answers  

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

---

What is dao and ado?

0 Answers  

---