Forms Data Controls :: Formview Update Mode Not Capturing Control Values?
Jul 22, 2010
I've been spending two days on this. My page formview is in a tab container and I need it to update, insert and display data. Insert and display are ok as long as the default mode is Insert. The problem here is edit mode, it's able to get values from the db(oracle) and display them in edit mode, but when I click save, any values I typed out on the textboxes do not get captured. When I call on my db update class, it just sends old db values. Here is the process: formview shows data selected from gridview, then an update button is clicked to edit the data. there is also a SAVE button to send updated data to db. Example: description textbox = "test", then I type out a different value, and in debug mode, the textbox.text still shows "test" after clicking save.
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
I'm having a hard time solving what should (I think) be an easy problem. I have a formview defaulting to Editmode. One of my data fields is a binary image. How can I change the editItem template to allow a user to upload a new image into the binary image field?
In web config file I have add key values specified.
In the formview I have labels on edit , item and insert mode that I want to display all the time by getting those values from web config. I'm able to do that with no problem but when I change the modes between edit to insert or item view, I lose those label values until I hit the "select" twice from the Gridview, those values re-appear. Below is the snippet of the code. What do I need to do to retain the category values all the time?
I am simply trying to get a querystring value and pass it to a textbox in a formview with the default view set to edit mode.
Protected Sub fv_Detach_Engine_DataBound(ByVal sender As Object, ByVal e As EventArgs) Handles fv_Detach_Engine.DataBound If fv_Detach_Engine.CurrentMode = FormViewMode.Edit Then Dim tbx_IDProfileAccount As TextBox = TryCast(fv_Detach_Engine.FindControl("tbx_IDProfileAccount"), TextBox) If tbx_IDProfileAccount Is Nothing Then tbx_IDProfileAccount.Text = Request.QueryString("IDProfileAccount") End If End If End Sub
I have a listbox inside a formview in a details page(master/details). The values for the listbox will come from a lookup table and when the user select one or more values it should be inserted in a table. The process sould be like the following:
The user will select one or multiple values and click on a Select button. Then a label should show the selected values. Then the user will click on the Insert button in the formview to insert it in the database.
I have a web app I'm creating and a form that has a formview control on it. The form's default is set to insert and when the user enters data and clicks save, the data gets saved to the database; only problem is that the form then clears all the data out of the controls.
Upon saving after updating or inserting, I'd like to set the form mode to edit and also have it retain the values they input into the form. I've tried a few things and have not had any luck.
e.g.
Code:
Protected Sub frmCustomerInformation_ItemInserted(sender As Object, e As FormViewInsertedEventArgs) ' Make sure record inserted properly. If e.Exception Is Nothing Then If e.AffectedRows > 0 Then litMessage.Text = "Customer Information saved." 'GETTING THE NEW quoteCustomerInformationId FROM THE SAVED RECORD AND PLACING IT INTO A SESSION VAR.
[Code] ....
What mode does the formview control have by default after it executes the ItemInserted method? Also, what is the prper way to do this?
I have created a formview with 4 dynamic controls fields that LINQ to a database.
rentfoodutilitytotal
There's an event handle for each of the first three fields whenever a text change with following codes:
' extract textbox from both SubTotal and the modified field tboxSubtotal = FormViewAssistance2.FindControl("totalTextBoxEdit") tboxModifier = FormViewAssistance2.FindControl("foodTextBoxEdit") 'extract string from those textboxes txtSubtotal = tboxSubtotal.Text txtModifier = tboxModifier.Text 'convert text to double and add them together Double.TryParse(txtModifier, dblModifier) Double.TryParse(txtSubtotal, dblSubtotal) dblSubtotal = dblSubtotal + dblModifier 'post the changes back to SubTotalTextBoxEdit 'totalTextBoxEdit 'EditorPart.ReferenceEquals("totalTextBoxEdit", dblSubtotal) 'PostBackTrigger.ReferenceEquals("SUBTOTRECTextBoxEdit", dblSubtotal) 'EditorZone.ReferenceEquals("SUBTOTRECTextBoxEdit", dblSubtotal)
I'm stuck on how to post/update totalTextBoxEdit to reflex changes in first three fields without having user clicking Update button to save the information into database. I've tried above 3 statements but none of them is working.
I'm trying to populate a datasource for a dropdownlist (which is actually in an insertitem template field within a detailsview on the same page) with a selectedvalue from a gridview. When I select a row in my Gridview 1, I get the "no value for a required parameter" message. ( and I have tried various alternatives... setting the selectedvalue of the grid to a variable... setting the selected value of the grid to a textbox nothing seems to work. It seems like this should be a pretty simple thing. I think I'm missing something obvious! Here is my code:
Field in Details view to be populated by the datasource:
This is what i have using VS and VB: formview that is bound to a sqldatasource. In the formview i set up three panels and the visibilty is controlled by three buttons. I want to be able to click the edit link button and have the panel that is visible in readonly mode be the one visible in editmode
I have created a FormView whose defaultmode = "insert". When loaded the FormView displays the InsertItemTemplate. At the top of the page is a DropDownList used to select Clients. I have added a list Item to the DropDownList with value = "0" and text= "Select Client" option. So the Page is in Insert Mode. SO FAR EVERYTHING IS AS EXPECTED.
When I select a Client from the DropDownList, the page remains in Insert Mode (Don't understand why? ) Could it be the default Mode setting? So I added the following vb code.
Protected Sub ddlSelectClient_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlSelectClient.SelectedIndexChanged
If ddlSelectClient.Text <> "(Select Client)" Then If FormView1.CurrentMode = FormViewMode.Insert Then FormView1.ChangeMode(FormViewMode.Edit) End If End If End Sub
So after an existing Client is selected, the FormView Mode should be changed to EDIT. AND INDEED THE EDIT ITEM TEMPLATE IS DISPLAYED.
Ah but life is not so simple (after all this is a Microsoft Application). So I enter data in some fields and click the [Update] Button.
Then I get the following message:
FormView 'FormView1' must be in edit mode to update a record.
THe FormView displays the Edit Template, the Update and Cancel Buttons are displayed. All this should mean I am in edit mode.
Just call me FrankenSoft !@#$%^^& or is it MicroStein?
Oh by the way I'm using Linq to SQL data sourcess. Should I be? I'm having a lot of problems with the FormView using Linq.
Formview1 datasource ID is SQLTest. When I click New on the form and go into insertmode, is there an easy way to auto file textboxID to the value of the NextIDNumber field ( field 9) from SQLTest datasource?
there are 2 pages (SummaryGridviewPage.aspx and FormviewPage.aspx) there are insert, item and update templates in the FormviewPage 1st case - there is no problem to insert new record, select and update action in the FormviewPage
2nd case - However, there is problem when i select a record in GV and direct to FormviewPage for edit this code is added in Formviewpage to open the record at readonly mode, no problem
Private Sub RF_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init If Session("RecordID") <> "" Then ' to check New or Old record SqlDataSourceRF.SelectParameters.Item("New_ID").DefaultValue = Session("RecordID") FormViewProject.ChangeMode(FormViewMode.ReadOnly) End If End Sub
however, no record if go further from readonly to edit mode then Code is added to the Edit button
Protected Sub BtnEdit_Click(ByVal sender As Object, ByVal e As EventArgs) FormViewProject.ChangeMode(FormViewMode.Edit) SqlDataSourceRF.SelectParameters.Item("New_ID").DefaultValue = Session("RecordID") FormViewProject.DataBind() End Sub
Now edit problem is solved but when go back to the 1st case (new record, and then edit) Now new record can be inserted, and then show it in readonly mode. but then try to go to edit mode, no record show i think BtnEdit_Click code is conflicted with the built-in "Edit" command Could anyone show me some info how formview retrieve specific record in a proper way?
So, I'm trying to use form view in insert mode on a dedicated aspx page. So when a user clicks "Add New" from the main GridView page, it will take the user to an Insert.aspx page that will be in Insert mode ready to collect information.
Here's what I have so far, and all I get is a blank page when I try to run it.
I have a FormView at the very bottom of the page in insert/edit mode. When I click insert/update button, the whole page reload and the pointer does not keep within the Formview but go to the very top of the page far away from the desired FormView.
What can I do here to prevent cursor going outside the Formview ? Is it I can use update panel ? What and where I should use the tags ? Or there are other better way ?
I have a combobox that is used as a control for Formview, so when the user selects a name from the combobox the data in formview displays in edit mode. However, some if the data that is displayed in formview needs to be empty. For example if the Date is being pulled in, it needs to be empty or null in edit mode.
I created a formview that I am using for data input (DefaultMode=Insert)
One of the objects I have is a text box (see below)
[code]....
When I click submit I get a message that I cannot insert a Null into the field IntershipNumAvailable. This makes sense since I made this field a required field in the database.
How do I get the form to recognize that the user selected item is the one I want to write to the database?
What changes do I need to make here? Do I need to make changes to my parameter list?
The following code successfully displays a record in a FormView and sets the FormView mode to 'Edit' when the user clicks on a LinkButton within a Repeater, however the record is not Updated. If I don't change the .SelectCommand and call .DataBind, I'm able to update the first record that is displayed. Naturally that's a moot point because the idea is to be able to update the record that the user selects in the Repeater.Because of the design of the FormView and Repeater, the record *must* be updated via the FormView. Updating the record via the Repeater is not an option.
