formview not updating record

Discussion in 'ASP .Net' started by Jon Paal, Dec 11, 2006.

  1. Jon   Paal

    Jon Paal Guest

    The form and buttons all display correctly and I can page through the records but when I try to update a record the change does not
    take effect.

    What's missing ??



    in my formview <EditItemTemplate ..> I have the button:
    ================================================
    ....
    <asp:Button SkinID="ASPButton" ID="Button6" CommandName="Update" CausesValidation="True" Text="Update" Runat="Server"/>
    ....

    I have this for the datasource:
    =====================================
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_data/northwind.mdb"
    SelectCommand="SELECT DISTINCT [EmployeeID], [LastName], [FirstName], [Title], [TitleOfCourtesy], [BirthDate], [HireDate],
    [Address], [City], [Region], [PostalCode], [Country], [HomePhone], [Extension], [ReportsTo] FROM [Employees]"

    UpdateCommand="UPDATE Employees SET FirstName = @FirstName, Title = @Title, Address = @Address WHERE EmployeeID = @EmployeeID">

    </asp:AccessDataSource>
     
    Jon Paal, Dec 11, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. MasterChief

    FormView not updating

    MasterChief, Feb 23, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    4,618
    Christopher Reed
    Mar 2, 2006
  2. =?Utf-8?B?RGFiYmxlcg==?=

    FormView update not updating with ObjectDataSource

    =?Utf-8?B?RGFiYmxlcg==?=, Apr 13, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    9,359
    =?Utf-8?B?RGFiYmxlcg==?=
    Apr 13, 2006
  3. MRW
    Replies:
    0
    Views:
    393
  4. Cirene
    Replies:
    0
    Views:
    588
    Cirene
    May 23, 2008
  5. John Mason
    Replies:
    0
    Views:
    424
    John Mason
    Jul 22, 2008
Loading...

Share This Page