Answer / srikant dwibedi

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");

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

0 Answers  

---

What are the usages of the command object in ado.net?

0 Answers  

---

What is the hierarchy of data in databases?

0 Answers  

---

How to retrieve the third table value from the data set?

2 Answers   Network Solutions,

---

What are the methods of XML dataset object?

0 Answers  

---

What is reference by value how does it works in .net?

2 Answers   SQL Star,

---

What is linq and entity framework?

0 Answers  

---

What is the role of data provider in ado.net?

0 Answers  

---

What is ado full form?

0 Answers  

---

What is ole data type?

0 Answers  

---

What is the difference between executenonquery () and executescalar ()?

0 Answers  

---

What is Data Provider?

0 Answers  

---