Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreNew TokensNew Tokens
Previous
 
Next
New Post
12/10/2009 2:27 AM
 

 Can you show us how to display an additional field with product details (Tokens like product width, height,price) after adding new field to product table of the database. I need to show this field with other details of the product.

 
New Post
12/10/2009 3:07 AM
 

Hi,

It's not enough to add fields to the Products table. You have to modify:

  1. All stored procedures related to this table.
  2. Several classes from the projects DotNetNuke.Store.Catalog (ProductController.cs, ProductInfo.cs, DataProvider.cs) and DotNetNuke.Store.Catalog.SqlDataProvider (SqlDataProvider.cs).
  3. From the project DotNetNuke.Store.WebControls:
    1. The product edit form: ProductEdit.ascx from
    2. Finaly in the ProductDetail.ascx control, look at the processToken method. Add a new case with your token word and return a control or null.

Gilles


We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
12/10/2009 4:31 AM
 

Thanks Gilles,

Actually I want to add an extra property to the product like width and height. This field is just to visible to the visitors to have an idea about the product.It is not using for any calculation or any of things. But I can see there are lots of tables. I appricaiate if you can tell me appropitate StoredProcedures as you mentioned about project files. I will use only product details table.

 

EDIT: I fogot to tell you one thing. At the moment I want only show data from the table. Not to insert or edit. My table is updating from another database via a web servise. So at the moment I want to know only about the displaying data.

Edit Again: I have done changes in productdetails page and productinfo page. My question is where is it assign database field value to the controls value.I know how assign a string from ProductDetail.ascx.resx file to a label value.Please help me for this.

Thanks.

 
New Post
12/10/2009 5:34 AM
 

Appriciate if you can answer my question.

tnx

 
New Post
12/10/2009 11:17 AM
Accepted Answer 

Hi,

The stored procedures related to the Products table have their name starting by Store_Products_xxx. It's easy no? Because you synchronize the db from another db, then you should have to change only those starting by Store_Products_Getxxxx, like Store_Products_GetFeaturedProducts, Store_Products_GetNewProducts, and so on (12 sproc).

All my previous advices remain valid except the point 3.a. You have to apply changes to all other points specified. Since the beginning, DNN recommends using a 3 tiers architecture (UI, BL, DAL) to develop a module. If you are not aware of this, you should read the official DotNetNuke programming guides or buy a book about dnn programming. Several are availables at Amazon depending of the dnn version you use. It's too long to explain such kind of programming stuff in a forum.

Gilles


We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreNew TokensNew Tokens


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out