Databases
StackOverflow2013
Postsdbo
POIssue in Update FormView asp.net.
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIssue in Update FormView asp.net.
    primarykey
    data
    text
    <p>I have sent value through querystring to this Page. After that I am Unable to get Edit Mode on modechanging event. When I click Edit button, simply it postbacks and nothing happens. If Clicked edit second time it gives Error :</p> <pre><code>(Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.) </code></pre> <p>Please tell me where I am wrong.</p> <p>Source Code -</p> <pre><code>&lt;asp:FormView ID="formview1" runat="server" AllowPaging="true" Caption="FireBrigade" DataKeyNames="FireBrigadeID" OnModeChanging="formview1_ModeChanging" OnPageIndexChanging="formview1_PageIndexChanging"&gt; &lt;ItemTemplate&gt; FireBrigade ID :&lt;asp:Label ID="lblFID" runat="server" Text='&lt;%# Eval("FireBrigadeID") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt; Name :&lt;asp:Label ID="Label3" runat="server" Text='&lt;%# Eval("FBName") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt; LatLong:&lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Eval("LatLng") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt; Address: &lt;asp:Label ID="Label2" runat="server" Text='&lt;%# Eval("Address") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt; Contact: &lt;asp:Label ID="Label4" runat="server" Text='&lt;%# Eval("ContactNumber") %&gt;'&gt;&lt;/asp:Label&gt;&lt;br /&gt; &lt;asp:LinkButton ID="EditButton" Text="Edit" CommandName="Edit" RunAt="server"/&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; FireBrigade ID :&lt;asp:TextBox ID="txtFID" runat="server" Text='&lt;%# Bind("FireBrigadeID") %&gt;'&gt;&lt;/asp:TextBox&gt;&lt;br /&gt; Name :&lt;asp:TextBox ID="txtname" runat="server" Text='&lt;%# Bind("FBName") %&gt;'&gt;&lt;/asp:TextBox&gt; LatLong:&lt;asp:TextBox ID="txtlatlong" runat="server" Text='&lt;%# Bind("LatLng") %&gt;'&gt;&lt;/asp:TextBox&gt;&lt;br /&gt; Address: &lt;asp:DropDownList ID="ddlAddress" runat="server" OnDataBound="ddlAddress_DataBound" AppendDataBoundItems="true"&gt; &lt;asp:ListItem Text="Select" Value="0"&gt;&lt;/asp:ListItem&gt; &lt;/asp:DropDownList&gt; &lt;br /&gt; Contact: &lt;asp:TextBox ID="txtcontact" runat="server" Text='&lt;%# Bind("ContactNumber") %&gt;'&gt;&lt;/asp:TextBox&gt;&lt;br /&gt; &lt;asp:LinkButton ID="UpdateButton" Text="Update" CommandName="Update" runat="server" /&gt; &amp;nbsp; &lt;asp:LinkButton ID="CancelUpdateButton" Text="Cancel" CommandName="Cancel" runat="server" /&gt; &lt;/EditItemTemplate&gt; &lt;/asp:FormView&gt; </code></pre> <p>C# Code -</p> <pre><code>public partial class Fifthpage : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblshow.Text = Request.QueryString["q"].ToString(); Dataset ds = new Dataset(); ds = bind(); da.Fill(ds); formview1.DataSource = ds; formview1.DataBind(); } } public DataSet bind() { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=SYSTEM-PC;Initial Catalog=DB;Integrated Security=True"; SqlCommand cmd = new SqlCommand("select * from FireBrigade",con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); return ds; } protected void ddlAddress_DataBound(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = bind(); List&lt;string&gt; ls = new List&lt;string&gt;(); foreach (ListItem lst in ds.Tables[0].Rows) { //lst.Value = ds.Tables[0].Rows[0]["Address"].ToString(); ls.Add(ds.Tables[0].Rows[0]["Address"].ToString()); } DropDownList ddladd = (DropDownList)formview1.FindControl("ddlAddress"); ddladd.DataSource = ls; } protected void formview1_ModeChanging(object sender, FormViewModeEventArgs e) { formview1.ChangeMode(e.NewMode); bind(); } protected void formview1_PageIndexChanging(object sender, FormViewPageEventArgs e) { formview1.PageIndex = e.NewPageIndex; bind(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USIti Tyagi
    1. USPuneet_2696717
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIssue in Update FormView asp.net.
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COTry to bind the formview in Page_Init. It seems to me, that you're doing something too late in page life cycle
      singulars
      1. POIssue in Update FormView asp.net.
      1. USRobert
    2. COAre you adding any control dynamically?
      singulars
      1. POIssue in Update FormView asp.net.
      1. USSuraj Singh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload