CodeVerge.Net ^Beta
Explore Item Entry Register Login

Novell Forums

Zone:

> NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit

Tags:

Item Type:

NewsGroup

Date Entered:

11/14/2005 9:32:59 PM

Date Modified:

Subscribers:

Subscribe Alert

Rate It:

(NR, 0)

XPoints:

N/A

Replies:

Views:

Favorited:

Favorite

Can Reply: No

Members Can Edit: No

Online: Yes

2 Items, 1 Pages 1 |< << Go >> >|

	Stoater
	Asp.Net User

Add more fields to product details

11/14/2005 9:32:59 PM

0/0

Hi Guys, I am using the ecommerce starter kit and have just updated the products table and the stored procedure to include an additional field, which I have done successfully, I modified the 3 pages that deal with the product details to include the field "category" as listed below, but when I run the script I get an error, which I have listed at the bottom of this posting.

ProductDetails
<img height="15" src="images/1x1.gif"><span class="Category"><b>Category</b> <asp:label id="Category" runat="server" /></span>

ProductDetails.aspx.vb

Protected WithEvents Category As System.Web.UI.WebControls.Label

Category.Text = myProductDetails.Category

ProductDB.vb

Dim parameterCategory As SqlParameter = New SqlParameter("@Category", SqlDbType.NVarChar, 50)
parameterCategory.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterCategory)

myProductDetails.Category = CStr(parameterCategory.Value)

ERROR MESSAGE

Server Error in '/Commerce' Application.

Procedure 'CMRC_ProductDetail' expects parameter '@Category', which was not supplied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure 'CMRC_ProductDetail' expects parameter '@Category', which was not supplied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Procedure 'CMRC_ProductDetail' expects parameter '@Category', which was not supplied.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
   ASPNET.StarterKit.Commerce.ASPNET.StarterKit.Commerce.ProductsDB.GetProductDetails(Int32 productID)
   ASPNET.StarterKit.Commerce.ProductDetailsPage.Page_Load(Object sender, EventArgs e)
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750

Any help would be much appreciated.

Cheers

	jakeburkey
	Asp.Net User

Re: Add more fields to product details

12/18/2005 6:36:56 AM

0/0

Not having seen the stored procedure, this is kind of a guess, but it appears that the SP is expecting an input parameter and Category has been defined as an output parameter. If you mean for Category to be an output parameter, try checking the SP to make sure that the declaration for Category includes the OUTPUT keyword.

best, jake

2 Items, 1 Pages 1 |< << Go >> >|

Free Download:

Books:

Beginning ASP.NET 2.0 E-commerce in C# 2005: From Novice to Professional Authors: Cristian Darie, Karli Watson, Pages: 681, Published: 2005

Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 Authors: Amanda Murphy, Shane Perran, Pages: 552, Published: 2007

PayPal Hacks: 100 Industrial-Strength Tips & Tools Authors: Shannon Sofield, Dave Nielsen, Dave Burchell, Pages: 343, Published: 2004

Salesforce.com For Dummies Authors: Tom Wong, Liz Kao, Pages: 432, Published: 2006

Excel: The Missing Manual Authors: Matthew MacDonald, Pages: 770, Published: 2005

Using Microsoft Access 2000 Authors: Roger Jennings, Pages: 1296, Published: 1999

GoldMine 8 for Dummies Authors: Joel Scott, Pages: 364, Published: 2007

Dreamweaver MX 2004: The Missing Manual Authors: David Sawyer McFarland, David Pogue, Pages: 836, Published: 2004

GoldMine 6 for Dummies Authors: Joel Scott, Pages: 384, Published: 2003

Client-Side Reporting with Visual Studio in C# Authors: Asif Sayed, Pages: 465, Published: 2007

Web:
Add more fields to product details - ASP.NET Forums Crying [:'(] Add more fields to product details. 11-14-2005, 4:32 PM ... Re: Add more fields to product details. 12-18-2005, 1:36 AM ...
GetAFreelancer.com - Add fields to Product page OScommerce. Jun 6, 2007 ... 3)I would also like to add a Logo Instructions: field area also seen on the: http://www.americanfloormats.com/product/detail.cfm/nid/1/pid/ ...
Nabble - Bugzilla - Users - Need to add one more field into the ... Need to add one more field into the products table ie productid. Need to add one more field into the products table ie productid I can change the template.
Need to add one more field into the products table i.e productid ... Need to add one more field into the products table i.e productid ... Subject: Need to add one more field into the products table i.e ...
Jacksons Fencing - Timber Product Details Product Code, Product, Price exc. V.A.T., Quantity, Add to Basket ... More Heavy Metal Field. Family Image Agricultural Gates ...
Is it even possible to add new fields to product details Is it even possible to add new fields to product details. ... Read more... Advanced search Only this Topic. 121454 Posts in 31818 Topics- by ...
RE: Need to add one more field into the products table i.e ... I am using bugzilla 3.0.5 on perl 5.10.0 Want to add project id into the product table. So what I did is 1. I added one more column in product table.
Add more fields to flights Add more fields to flights. If you'd like to see more fields available when ... is a community that helps people to get the most from the products they use, ...
Zoho CRM - Working with Products For more details refer to the Specifying List View Criteria section. ... Refer to the List of Standard Product-related Fields section for more details. ...
Add a New Field to Products in Joomla! VirtueMart | New Circle Blog Jun 10, 2008 ... Find a place for your new field, and add the form input. ... Now, you will need to modify the front-end product details page to display the ...

Videos:

http://www.youtube.com/v/ldJhMDuOGxY&fs=1&source=uds&autoplay=1

Lec 4 | MIT 8.02 Electricity and Magnetism, Spring 2002 Electrostatic Potential Electric Energy eV Conservative Field Equipotential Surfaces View the complete course at: http://ocw.mit.edu/8-02S02 Licens...

http://video.google.com/googleplayer.swf?docId=-4236642803632939839&hl=en&fs=true&source=uds&playerMode=simple&autoPlay=true

How to get rid of a *MIGRAINE* Headache using EFT Technique http://www.emofree.com/ Provided by Maria Andros from http://www.MyGoldmineVideo.com How to get rid of a Migraine or at least make it bearable with ...

http://www.youtube.com/v/qaZQzIXv2RQ&fs=1&source=uds&autoplay=1

Lec 5 | MIT 8.02 Electricity and Magnetism, Spring 2002 E = -grad V More on Equipotential Surfaces Conductors Electrostatic Shielding (Faraday Cage) View the complete course at: http://ocw.mit.edu/8-02S02...

http://video.google.com/googleplayer.swf?docId=2099297691132107520&hl=en&fs=true&source=uds&playerMode=simple&autoPlay=true

Dan Lok's Turnkey Affiliate Program - How To Promote Using Forums Part 2 A step-by-step tutorial showing you how to promote products for Dan Lok's Turnkey Affiliate Program.

http://video.google.com/googleplayer.swf?docId=2251921501218537050&hl=en&fs=true&source=uds&playerMode=simple&autoPlay=true

Using e-Lybra and WDS products This DVD includes a demonstration and information on many of the products from World Development Systems.

http://www.youtube.com/v/UbjZgxIjQfk&fs=1&source=uds&autoplay=1

Lec 5 | MIT 3.091 Introduction to Solid State Chemistry The Shell Model (Bohr-Sommerfeld Model) and Multi-electron Atoms Quantum Numbers: n, l, m, s View the complete course at: http://ocw.mit.edu/3-091F...

http://www.youtube.com/v/q_v2NpgEpws&fs=1&source=uds&autoplay=1

Lec 15 | MIT 8.02 Electricity and Magnetism, Spring 2002 Ampere's Law Solenoids Revisit the Kelvin Water Dropper Midterm Evaluation View the complete course at: http://ocw.mit.edu/8-02S02 License: Creativ...

http://video.google.com/googleplayer.swf?docId=-5330121659570932167&hl=en&fs=true&source=uds&playerMode=simple&autoPlay=true

Structuring Personal Information When Everything Can Be Saved and Searched... Google TechTalks May 17, 2006 William Jones William Jones is an Research Associate Professor in The Information School at the University of Washingt...

http://www.youtube.com/v/ab0czJ6_OF8&fs=1&source=uds&autoplay=1

Lec 29 | MIT 8.02 Electricity and Magnetism, Spring 2002 Snell's Law Refraction Total Reflection Dispersion Prisms Huygens's Principle The Illusion of Color The Weird Benham Top Land's Famous Demo View the...

http://www.youtube.com/v/UhtI6el1gPw&fs=1&source=uds&autoplay=1

Lec 25 | MIT 3.091 Introduction to Solid State Chemistry Solutions: Solute, Solvent, Solution, Solubility Rules, Solubility Product View the complete course at: http://ocw.mit.edu/3-091F04 License: Creati...

Search This Site:

Invite

History

Resources

Members

SiteMap

DeclaringType Property

ToDateTime Method (Boolean)

GetCustomAttribute Method (ParameterInfo, Type, Boolean)

GetConnectionPointContainer Method

StackFrame Members

moving web solution to a collegues machine

datetime.now

menu controll

custom help builder

get current user name

running javascript from an asp.net object method

remoting/web book

download a file and save to local disk

updating db from text feilds

fixed size of first web page

want to show no decimals in reader

document.selectnodes

can file uploading using asp.net just by click browse?

how to round to 2 decimal places

upgrading to web developer 2008

sharing application state in web farm/web garden

in asp.net 2.0 does each page compile to a separate dll?

how to creates https page?

png imagebutton in firefox doesn't render correctly

cant databind gridview with generic collection

how to empty a querystring in asp.net

i'm interested in making a php game in aspx

index was out of range. must be non-negative and less than the size of the collection.

http/1.1 new application failed

validation/design question

unix timestamp conversion

smtpclient email problem

can i produce a file with no html from an .aspx file...

advice/opinions needed on application

hyperlink within listbox

Privacy | Contact Us
All Times Are GMT