Help with Formview Please in AspNet 2.0

Discussion in 'ASP .Net Web Controls' started by Roger Stenson, Apr 23, 2010.

  1. Hi
    I am developing a member application with Formview for my bridge club and
    the basic item, editing, inserting modes are working fine within the
    secure part of the system built round the Microsoft membership and role

    Outside the secure system, I have an open web page which displays an
    application form to join the club. The form opens directly in Insert Mode.
    Following the input, the form is edited in an ItemInserting method and the
    insertion cancels OK on routine data edits.
    I have just added to the ItemInserting edit function a check whether there
    is already a member form on the file for the applicant. (Players are
    allowed to play as guests before applying and a 'Guest record can be added
    by another (batch) process when processing the results.

    I have got the code working ok for the check. If the located record is a
    full member the application is redundant and the insertion is cancelled.

    However if the Player record on the file is either an open application form
    or a partly processed one, (i.e approved but on the waiting list) I would
    like the application routine to update the original application with any
    changes that are present on the new application Applicants can't get into
    the secure system to amend their records.

    I have got to the point in the ItemInserting routine where I have
    established with an sql reader command that a record exists and am looking
    for some advise from the community on how to proceed with my objective. I
    need to break out of iteminserting without either cancelling or completing
    the transaction
    If I cancel the control ignores any subsequent code and redisplays the
    insertion record . If I don't cancel it attempts to complete the insertion
    and fails on duplicate input

    I am beginning to think I shall have to abandon FormView and code this
    routine from scratch in Asp but before doing this I would hope for some
    advice from more experienced coders on whether there is a way of achieving
    my objective

    Roger Stenson
    Roger Stenson, Apr 23, 2010
    1. Advertisements

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. Gary Nelson

    Upgrade from aspnet 1.1 to aspnet 2.0

    Gary Nelson, Oct 14, 2005, in forum: ASP .Net
    Gary Nelson
    Oct 14, 2005
  2. KK
    Big Brian
    Oct 14, 2003
  3. Replies:
    Juan T. Llibre
    Mar 23, 2007
  4. Brian Schuth
    Brian Schuth
    Sep 8, 2003
  5. Alfred Sehmueller
    Alfred Sehmueller
    Feb 20, 2004

Share This Page