Webshop adding tables.

Rebel · October 5th, 2007, 04:29 AM

I am working on the Webshop project.

I want to add a column in the product database (actualy 2)
A "Author" Colomn
And a "Grade" Column

But what code do i have to add to make this work i just want to show this information in the products gridview and detailed view.

(Sorry for my bad English)
(I'm really new to asp.net so sorry for the n00b question)

Imar · October 5th, 2007, 12:51 PM

Hi there,

The best way to do this is to see how the current Product class works. You can, for example, search the whole web site for PictureUrlSmall. Everywhere you see this property, duplicate the code for the Author and Grade columns. This involves pages in the site and in the Management folder and classes in the App_Data folder.

Then make the same changes in the various stored procedures that are used in the database.

Does this help?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Rebel · October 8th, 2007, 03:49 AM

Hello imar
Thank you for the fast reply

i've edited all the files and scanned them for the pictureUrlSmall

and also al the Database files

But i get the following error:

Quote:

quote: Author

Quote:

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.IndexOutOfRangeException: Author

Source Error:

Line 162: Catch ex As Exception
Line 163: ' Pass up the error; it will be caught by the code in the Global.asax and the generic error page set up in web.config.
Line 164: Throw
Line 165: End Try
Line 166: Return productList

Source File: C:\Documents and Settings\Christian\Mijn documenten\Visual Studio 2005\WebSites\Nieuwe map\WebShop\App_Code\DataAccess\ShopManagerDB.vb Line: 164

Imar · October 8th, 2007, 04:10 AM

Hi there,

Sounds like you haven't modified the stored procedures in the database to include the new columns. Without those columns in the procedures, GetOrdinal in GetProducts will throw the error you mentioned.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Rebel · October 8th, 2007, 04:23 AM

Hey indeed you where right

but now i have the following problem

I am trying to insert a new product
so ive copied the function of the price textbox and delete the range validator.
and pasted a author field here.

so i am filling in some data and i get send to the default page without errors the only thing is he doesn't send the data?

you have any id why not?

And youre book is so asome it really helped me out

Imar · October 8th, 2007, 04:28 AM

Hard to tell without seeing any code. Could you post the *relevant* parts of the code file?

Groeten,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Rebel · October 8th, 2007, 04:30 AM

i've added the following code:

Quote:

quote:<tr>

Quote:

        <td class="Label" valign="top">
          Author:
        </td>
        <td>
          <asp:TextBox ID="AuthorTextBox" runat="server" Text='<%# Bind("Author") %>' Width="300px" />
          <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="AuthorTextBox" ErrorMessage="Please enter the author" Display="Dynamic"></asp:RequiredFieldValidator>
        </td>
      </tr>

And now it doesn't add any product.
Wich code do you want to see more?

Imar · October 8th, 2007, 04:36 AM

I don't know. This looks like it should; I see no reason why this wouldn't work.

Try setting a breakpoint in FormView1_ItemInserting, debug the app and see what code gets called.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Rebel · October 8th, 2007, 05:11 AM

I cant add a breakpoint?

Ive double checked all the files but can't find any reason why it doesnt work all of a sudden :S

i was trying to add a breakpoint in the addproduct.aspx file but i dont have the breakpoint function here?

EDIT:
ive commeted the author insert function but it still doesnt validate?

really weard actually

Imar · October 8th, 2007, 05:19 AM

You need to set breakpoints in the code behind.....

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004