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

Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  

---

Which is better ole db or odbc?

0 Answers  

---

How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

---

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

---

Which is faster ado.net or linq?

0 Answers  

---

Can we load multiple tables in a dataset?

0 Answers  

---

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

5 Answers   HCL,

---

What is XML serialization

0 Answers   Digital GlobalSoft,

---

How to find the count of records in a dataset?

6 Answers  

---

How to store data in memory?

0 Answers  

---

Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.

3 Answers   Directi,

---