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

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,

---

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

---

What is Data view?

0 Answers  

---

What is the difference in record set and dataset?

0 Answers  

---

What is shadow copy?

0 Answers  

---

What is the use of parameter object?

4 Answers   CDC, Ksb,

---

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

0 Answers  

---

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  

---

What is a non query?

0 Answers  

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  

---

What is difference between connected and disconnected architecture in ado.net?

0 Answers  

---

What is ado connection?

0 Answers  

---