Forms Data Controls :: Show FormView In Edit Mode With Specific Table Columns Depending On Their Genre?
Sep 8, 2010
I have a table in my database called "Profiles". This holds data on Female and Male personal characteristics.On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select methodwhich retrieves data from the "Profiles" Table via a DAL.The "Profiles" table has some columns which relates to females only and some just males and some are generic to both.See example below
UserId - / of Type GUID
GenreId / of Type BOOL.
Hip Size (For females)
Dress Size ( For Females)
ChestSize (For Men )
TrouserSize (For Men)
Weight ( For both )
When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists whichare binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc.bjectiveIf a female user logs in I just want to show them the (Hip Size) DDL and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or TrouserSize DDL.At present the GetProfileByUserId returns all colums from the tableMy question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the usermay not have selected an item in the previous form so they could also be NULL.Am i on the right path by writing a Select Query that checks to see if the User is Male or Female by checking the Genre column in Profiles first.Do I also need 2 panels, 1 to hide Female DDLS and the other to Hide MaleDDLs subject to logged in user genre.
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
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?
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'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?
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.
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 SQL DB with just 2 fields, ID and TEXT.What i was trying to do, was placing a Detailsview in EDIT MODE, then selecting from the DB like SELEC TOP 1 Text FROM DB.Then i placed a Ajax HTML Editor in the template field.How can i, keep the HTML Editor on the page, and use it for INSERT and/OR EDITING ?e.g.: on the first time the user opens the site management page, it will be blank, so it will show the HTML with no text on it. but the bottom button will be UPDATE and CANCEL. So when he enters the TEXT he clicks on UPDATE.
I have a user requirement to hav the ability to directly edit the gridview without having to click the edit link. I was thinking of showing dropdown lists for each column-to-row so that the user can select the values for each record. Then the table will be updated accordingly (no update link).
Is this possible or do I still need the edit template and specify the item template with the dropdown list?
I have a listbox in the formview. The listbox has selectionmode = multiple. The previous programmer has setup such a way when a user selects multiple items in the listbox, the data are stored with comma delimiter. For example, Listbox have values A, B, C, D, E. If user selected A, C, E and the data are stored in a field as A,B,C. Now the business requirement has changed and the user should be able to edit the data they entered. I want to able to show user which data they selected when they inserted data i.e. In the edit mode, the listbox should have A,C,E as highlighted. How can I do that? I can not use Eval("fieldname") because the listbox can not find the data "A,C,E" in the available listitems.
I have a page where I have a tab container and four tabs. the problem is on the first tab "manage quote request" I have a Gridview with the quote request general informatin listed and have a template field created with a link button to databind to the formview quote details. the porblem comes in when after I click on the select linkbutton. the Formview loads right. Then Whe I try to click on the edit linkbuttin in the form view I have to click it twice to change the mode to edit.