ASP.NET 1.0 and 1.1 BasicsASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
I am calling a strored procedure from my asp .net application. How do I get the value of the result into the application back ? What are the classes to use for this..can any body show me the code examples pls
What I required to do is, I want to pass a parameter to the procedure which is an Itemcode. And from 5 related tables I want to fetch 8 information and display them on a form in 7 textBox controls and in 1 image control. So basically I need 8 output parameters. I cannot use the datareader because I will not be able to bind them to this control. How can I write code to get all these info from the tables and present it on the form.
In that case you do not use return parameters. Simply create a sql select statment. I would use a sqldataadapter and fill a dataset. The textboxes and image controls can then be bound to columns in the dataset table.