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

How to retrieve the user id which is provided while windows authentication?

0 Answers   Cap Gemini,

---

types of Store procedure in Sqlserver2000?

4 Answers  

---

What is ado full form?

0 Answers  

---

Which architecture does Datasets follow?

0 Answers  

---

What are the Different layers in ADO.Net?

10 Answers   eXensys,

---

What are the advantages of using datalist?

0 Answers  

---

Define connection string?

0 Answers  

---

What is the main difference between ADO and ADO.Net

4 Answers   HCL,

---

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

3 Answers   Directi,

---

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

---

What are basic methods of dataadapter?

0 Answers  

---

how would i implement dropdownlist in gridview using c#

2 Answers  

---