locked
Update RRS feed

  • Question

  • User1575589722 posted

    I have no IT training. I am trying to update an access database in asp. net. from an item selected from a dropdownbox. The code for the dropdownbox is

    [<asp:AccessDataSource runat="server" ID="AccessDataSource1" DataFile="Billie.mdb"
    UpdateCommand="UPDATE CheckTable SET CofC = @CofC_Value WHERE Id = Id
    ">
    <UpdateParameters>
                        <asp:FormParameter FormField="DropDownListCofC" Name="Type_Value"  Type="String"/>    
                          </UpdateParameters>         
    </asp:AccessDataSource>]

    The update query I am trying to use is

    [<asp:AccessDataSource runat="server" ID="AccessDataSource1" DataFile="Billie.mdb"
    UpdateCommand="UPDATE CheckTable SET ([CofC]) = (@Certify_Value) WHERE Id = 3
    ">
    <UpdateParameters>
                        <asp:FormParameter FormField="DropDownListCofC" Name="Type_Value"  Type="String"/>    
                          </UpdateParameters>         
    </asp:AccessDataSource>]

    Obviously it doesn't work can someone please help me? Thanks Much

    Billie

    Thursday, January 6, 2011 5:56 PM