Answer / Ansa Christopher Raj

To call a stored procedure using ADO, you can use the Command object with the command type set to adCmdStoredProc. Here's an example:
1. Create a new Connection object.
2. Open the connection.
3. Create a new Command object based on the open connection.
4. Set the command text to the stored procedure name, and set the command type to adCmdStoredProc.
5. Optionally, add parameters using the Parameters collection of the Command object.
6. Execute the command and process the results."

For RDO, the process is similar:
1. Create a new Connection object.
2. Open the connection.
3. Create a new Recordset object based on the open connection.
4. Set the recordsource property to the stored procedure name.
5. Optionally, add parameters using the Parameters collection of the Recordset object.

Explain the difference between sqlcommand object and command behavior object?

1 Answers  

---

Which parameter of ConnectionString is used to specify the name of the database?

1 Answers  

---

How many major types of connection objects in ADO.NET?

1 Answers   MCN Solutions,

---

What are the types of databinding?

1 Answers  

---

ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?

3 Answers   Zensar,

---

What are ado.net objects?

1 Answers  

---

What is datacolumn and how it is used?

2 Answers  

---

How do you update a dataset in ado.net?

1 Answers  

---

Which object holds only data and does not interact with data source?

1 Answers  

---

Is entity framework better than ado.net?

1 Answers  

---

Define isolation?

1 Answers  

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

1 Answers  

---