How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
- 1 Answers
- 1038 Views
- SwanSoft Technologies, I also Faced
- E-Mail Answers
Answer / Ramandeep Singh
To use a stored procedure in ADO.NET, you create a Command object and set its CommandType property to CommandType.StoredProcedure, and CommandText property to the name of your stored procedure. Parameters can be provided by adding Parameter objects to the Parameters collection of the Command object, setting their values before execution.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the ado.net objects?
How can we load multiple tables in to dataset?
What are all components of ADO.Net data provider?
What are the steps to connect to a database?
How to work with disconnected data - the dataset and sqldataadapter?
Define data adapter?
What is Data view?
How to store data in memory?
About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?
What is execute reader in ado.net?
What are the major difference between classic ADO and ADO.NET?
How many major types of connection objects in ADO.NET?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
