Hi,

This probably has been asked before but I haven't found an answer ...

So again then: I've created a FormView with Insert mode as default. The form works, the data gets saved. And now I'd like to display the data that just got entered in a read-only FormView so the user can print it out. How would I do that?

I tried it with this:

Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As FormViewInsertedEventArgs)

        If e.Exception Is Nothing Then
   
            If e.AffectedRows = 1 Then
     
                FormView1.ChangeMode(FormViewMode.ReadOnly)
                FormView1.DataBind()
                MessageLabel.Text = "Record inserted successfully."
     
            Else
     
                MessageLabel.Text = "An error occurred during the insert operation."
       
                e.KeepInInsertMode = True
     
            End If
   
        Else
   
        MessageLabel.Text = e.Exception.Message
     
            e.ExceptionHandled = True
            e.KeepInInsertMode = True
   
        End If
       
    End Sub

For some reason the text of the MessageLabel gets displayed correctly but the FormView remains in Insert mode.

Any ideas what went wrong?

Thanks a lot!
 

Hi, Subliminal Void :

 Try to put you changeMode code into Prerender event.

if (FormView1.CurrentMode == FormViewMode.Insert)

{//put the changemode here

}

Thanks for answering, but that creates the same problem:

The page then gets ALWAYS displayed in Read-Only mode instead of only AFTER INSERTING the data.

Again:

Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As FormViewInsertedEventArgs)
   
                FormView1.ChangeMode(FormViewMode.ReadOnly)
                FormView1.DataBind()
                MessageLabel.Text = "Record inserted successfully."
         
 End Sub
 

The MessageLabel.Text command gets executed correctly. But not the two commands above it.

What I need, and this has to be possible!?, is to display the data I've just inserted via FormView.

Any help is greatly appreciated,

Jerome 

I'm still faced with the same problem and I'd like to know how to do this at last ...

Any new ideas? Why does it show the label but not change the mode?

Thanks a lot. 

Write a button click event for new link button, which is present in the insert mode of the FormView Control - as below :

//Call Insert method here

FormView1.Databind( );

} 

I'm not sure here, but try calling dataind() before switching modes.

FormView1.DataBind() 
FormView1.ChangeMode(FormViewMode.ReadOnly)
MessageLabel.Text = "Record inserted successfully."

I had the same problem. I could resolve this issue by following code:

Write a button click event for "Insert" Link button present in the Insert Template of the Formview control :

protected void Insert_Click(object sender, EventArs e)

{

    //Call your Insert method 

    FormView1.ChangeMode(FormViewMode.Readonly);

    FormView1.DataBind();

} 

It worked fine for me!!  

I'm also facing the problem of displaying an inserted record using FormView.

The problem occurs when there is at least one record already in the database table. After I click on the Insert button, the record is saved but is not displayed. The other record in the database is displayed instead. I will need to click on the paging link to retrieve the new record. This can be confusing to a user.

I've tried all the suggested solutions mentioned in this post but none works for me.

Has anyone else found a workable solution?

Thanks.

I have been searching for a solution in the forum but there's none available. After an insert on a formview, how do you ensure that same page is displayed with the newly inserted data and not another page. In other words, how do you keep the paging to the current state? I gleaned the following bits of code but as a total newbie, not sure if it's related. 

Any help would be terrific.

Thanks

Jeewai

public int CurrentPage
      {
         get
         {
            // look for current page in ViewState
            object o = this.ViewState["_CurrentPage"];
            if (o == null)
               return 0;   // default to showing the first page
            else
               return (int) o;
         }

         set
         {
            this.ViewState["_CurrentPage"] = value;
         }
      }
 

I was having the same issue as this, I seem to have got around it by setting the default state of the formview to ReadOnly, then in the pageload included this code:

OK, Having the formview in insert mode by default and then changing automatically on read mode after an insert is quite easy and was well explained on one of the previous post on this thread:

<script runat="server">
Sub Page_Load()
If Not IsPostBack Then
If FormView1.DataItemCount = 0 Then
FormView1.ChangeMode(FormViewMode.Insert)
End If
End If
End Sub 'Page_Load

Now the hic is that let's say I'm creating a new record (7) on my formview, when I hit the insert button, the form INVARIABLY return to record 1 and display in read mode (as per the code above). I want to be able to display the newly inserted record (which shoud be paging 7 )

Can you guys give me a lead, in VB.net preferrably. Should I use the this.  attribute to refer to the new page I've been inserting

Thanks for clarifying

Hi, Did anyone solve this in VB, I'm also looking for an answer to this!