Part Table or Procedure not updating

  • Hi all,

    I'm fairly new at all this but I know a little, I've recently taken over our database from a guy who designed it and I've been tasked with adding a part name to our database. It is aspx format and I've managed to add the line item to the aspx file:

    <asp:ListItem Value="24">Wipers</asp:ListItem>

    I've also added Wipers to the table in sql. That part seems OK.

    Now when I open a ticket for a repair the part name Wipers is not shown against the part name field but the value 24 is shown and I cannot work out why it is not picking up the value I added Wipers. The code in the form is:

    <td class="formLabel">Part:

    </td>

    <td class="formData"><asp:label id="partName" runat="server"></asp:label></td>

    I'm not sure if it is hardcoded or a stored procedure and I'm currently stuck with no hair left!

    I hope this makes sense and I'm sure it is something really simple but I'm tearing my hair out here :O

    Thanks

  • First, welcome to SSC.

    I suggest you re-post this under the programming - general forum and be prepared to provide a little extra detail; you will have better luck. What you are describing is more of an asp.net question.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • Hi Alan,

    Thank you for the warm welcome 🙂

    You could well be correct regarding the asp side so before I re-post I'll do a bit more reading.....

    Thanks again for your reply mate.

    -Gav

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply