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

What are the uses of Stored Procedure?

0 Answers  

---

how can implement dropdownlist in particular of dataset when try to update?

0 Answers   TCS,

---

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

3 Answers   TCS,

---

What are the steps in connecting to database ?

2 Answers   Microsoft,

---

What is the use of SqlCommandBuilder?

0 Answers  

---

How is entity framework different from ado.net?

0 Answers  

---

What are the two fundamental objects in ADO.NET?

8 Answers   Ksb, TCS,

---

What are advantages of microsoft-provided data provider classes in ado.net?

0 Answers  

---

Which is better ole db or odbc?

0 Answers  

---

What is sqldatasource?

0 Answers  

---

What are the important features of ado.net 2.0?

0 Answers  

---

What is the difference in an abstract class and an interface?

0 Answers  

---