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