I am using a stored procedure for a sqldatasource to update a formview. I believe that I am passing the Obligation_Status value correctly to the stored procedure but the oblgation status field is always updated AS NULL in the database. Does anyone know what I am doing wrong?
One of the fields on my formview is a dropdownlist. When I go into edit mode the dropdownlist gets set to the correct value and works fine up to this point. Problem is I just can't see how to get the newly selected value of the dropdownlist to persist to the database when update is clicked. The DDL is a category list and I want to allow changing of the category for each record. Like I said I have it working so it displays the correct category for the record but if I change the DDL (change category) the new selected value doesn't get updated in the database. It just keeps using the binded value that was originally assigned to the selected value of the DDL. see code snippit
The above snippet is how I am binding the DDL. Now to not bore you with a ton of code paste I use various events of the formview to make sure the value displayed in the DDL is correct for the record that I am viewing at the time. All that works just fine. Where I need some pointers is the when I enter edit mode and change the DDL from say fire to ice it isn't getting persited to the database, all other info in the record gets updated just fine but the DDL never changes. I have tried several angles to getting this working and TBH my brain is yelling BREAK TIME.
I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.
I have a web page with a gridview & formview (master/detail relationship) combo. On page load the gridview shows all records from a SQL table. On my page I have a button that when clicked shows the formview in Insert mode to allow users to add a new record to the data. I have also added a column to my gridview that has a link. When a user clicks this link it hides the gridview and shows the formview in edit mode with the detail from the record selected from the gridview.
In my formview I am using a listbox control to allow users to select multiple values. The choices in the listbox are populated by a SQL data table. I have successfully written code to post the selected listbox values to my SQL data field during Insert. When the user selects a record to edit I have code in the databound event to select values in the listbox from the choices based on the value in the sql data field. This works as well. My problem is that I cannot figure out the correct code to update my SqL data when a user is editing the record and makes changes to the selected listbox value. I have included my design code for my listbox in my formview edittemplate and also my behind code that I have attempted.
I have a strange issue with the FormView. After working through some issues getting the update to work (as this is my first experience with FormViews) I now have a new issue. After I perform an update, and the FormView updates and returns to read mode, if I hit F5 (refresh) the FormView performs another update to the datasource, despite the fact it is read-only mode and none of the fields on the screen are editable.
I would think that a refresh in read mode for the FormView after an edit would simply refresh the data from the database, not perform another update. Again, the FormView is in Read Only Mode, but a refresh is creating another Update event (which I can debug and see if I break in the ItemUpdating event). This only happens after I perform an edit, not when the page initially loads.
I have an access database where when the record is updated I would like to automatically check a box and update the date to the current date in an Access 2002-2003 database. I've tried this for several days without any resolution and can't find anything that works on the net. ...I'm new at this.
I have this problem everytime I change the select command to a custom command, and I do not know what is causing it.
My Formview will not update when i hit the update button, page refreshes but I get the same info, not the updated info. I set up my DataSource to CRUD only one table, then change the select statement just for the ItemTemplate of the Formview, leaving the rest, but it will not update
One of my pages shows all of our customer information from a customer table. I want the user to choose whether to see all customer records, or select a specific record from a list. So, my webpage has two radio buttons (show all customers, show specific customer), a listbox (full of customer names), and a formview control. The problem I'm having is getting the formview to update when I change modes via radio buttons or listbox selection (see code below).
i have the following scenario: one formview. when in editmode there is a child formview linked to the other by a column value. i need to take the value of one of the values of parent formview controls and set it to a textbox of child formview in insert mode. I wish to know which event should I use in codebehind to bind both controls? (that escenario will have paging and must keep the binding as if it was master detail)
I am using a form view control which has two binded textbox. Now at this level it works fine and the textboxes show the values from database. But when i insert a panel inside the form view and move these two textboxes inside the panel, they dont show any values. What could be the reason for this?
I am attempting to show/hide a control (txtInpatientType) when a user views individual records on a FormView (frmData) depending on the value stored in another control (txtPatientType). For example, if txtPatientType.Text = "Inpatient" then txtInpatientType.Visible needs to be True. Very simple code follows.
txtPatietType and txtInpatientType are both ReadOnly. txtInpatientType.Visible = false by default.
I have a formview with an insert item template. I have added two dropdown controls that are databound to two different database tables to this insert template. However, when I click the 'InsertQuery' for the Accessdatasource neither of these controls are available as 'Parameter source options'.Out of interest, if I take these dropdown controls out of the formview and put them on the page they then become available to use.
I have a calendar control where a user selects a date and then inputs info into a FormView control. Underneath the FormView is a GridView that shows all data from the SelectedDate on the calendar control. However, when the date is selected, all the information from the table ( from all dates ) is displayed.
I am using fileuploader control in gridview template control's edittemplate but the problem is when i press edit button fileuploader control and update other controls such as textboxes and press update button there is no value for Fileuploader control so i need the value of image control that is in itemtemplate so i pass it as a parameter.
I use a GridView control to select the row to display within the FormView. The FormView contains a RadioButtonList to facilitate the selection of one of its values. My C# codebehind contains a "selected_index changed event to grab the values from any of the modified FormView controls. My problem is that it is not picking up the selected radio button. Here's some code:
Couple quick questions:What's the difference between FormView1_ItemUpdating and FormView1_OnUpdating? Do they occur at different times in the update process?Still can't get my code to upload the file...what am I missing?
I've been searching on this question for hours and not finding a solutionI simply want to access a FileUpload control in the EditItemTemplate of a FormView.When the FileUpload control is outside of the FormView, I can access it like this:
Visual Studio says:"The name 'UploadImage1' does not exist in the current context" It says this about any controls I've put in the FormView.How do I access these controls in my c# code behind?
I have a textbox in Formview inserttemplate and I want it be invisible on click of a button.In Visual Studio the intelligensense for this textbox does not show up at all - meaning it is not accessible. However, the control eg textbox OUTSIDE the Formview is accessible.How to modify the code so that we can modify property of a textbox WITHIN inserttemplate WITHIN the formview ?