Forms Data Controls :: Detailsview EditMode / 'DropDownList1' Has A SelectedValue Which Is Invalid
Jul 23, 2010
i have a detailstview and sql datasource I am retrieveing the data so far no problems but afteradding a dropdownlist in edit mode and clicking edit button I get this error"
'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
We use gridview for showing a data from table.It show fine in certain case like in table field dispostion is data and test but in table we put the string Ineligible Member/Member No Longer Enrolled - Spoke to Target and Wrong Number After Skip Tracing then it gives error. 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
The following is snippest my code ,tell me where i am wrong.
I've got a gridview which displays records from a table in SQL Server. Next I've got a details view which displays the details from the selected record. This works fine.
When the user selects a record, which then gets displayed in the details view, I'd like to make it possible for the user to edit the record. I've done searchs for this online, and found lots of responses, but none quite displaying an answer to the question I've got. I'm sure it is a simple thing I've done wrong, but at this point I don't know what it is I've done wrong. I've getting this error,"'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value".
I've got a SqlDataSource to display the data in the details view. And then I specified another SqlDataSource to use for the dropdownlist control in the details view. I converted the field, in the details view, to a template field and have been replacing it. Here's the SqlDataSource controls definitions:
I have a dropdownlist in DetailsView to which items are added programmatically during DataBound event. It is working fine in InsertItemTemplate, but in EditItemTemplate i am getting this error "'branchDDL' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value".
The question has probably been raised many times, but I could not find an answer so far.The error is: ropdownlist has SelectedValue which is invalid because it does not exist in the list of items.However, I have debugged the values and the list has the correct list of values which includes the SelectedValue.
In my asp.net page I have a formview. In the formview's InsertItemTemplate I declare a dropdown list as below:
<td> <asp:DropDownList ID="DropDownList6" runat="server" text='<%# Bind("District") %>' DataSourceID="SqlDataSource6" DataTextField="District" DataValueField="District"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [District] FROM [tblDistricts]"></asp:SqlDataSource> </td> and this works perfectly fine. In the EditItemtemplate I declare a similar dropdownlist as below to edit district values: <td> <asp:DropDownList ID="DropDownList6" runat="server" selectedvalue='<%# Bind("District") %>' DataSourceID="SqlDataSource6" DataTextField="District" DataValueField="District"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [District] FROM [tblDistricts]"></asp:SqlDataSource> </td>
But whenever I try to edit the data I get the error:
'DropDownList6' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value And the values I am trying to edit were entered into the table by the dropdownlist declared in the insertitemtemplate dropdownlist6 listed above. And no values were deleted from the table.
How to solver this error? I am getting error for "DropDown"
Error: 'DStation' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value on line: DStation.DataBind();
My .cs code is below
string CommandText = ("select distinct StationName from stations where DeletionDate is null"); DStation.DataSource = DataManager.DatabaseManager.GetOrCreateConnection (DataManager.DatabaseManager.ConnectionType.MySQL).GetData(CommandText); DStation.DataTextField = "StationName";
I got this error when select a row from a grid view to update
'ddl_ctegOf_Product_update' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentOutOfRangeException: 'ddl_ctegOf_Product_update' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value
Source Error: Line 265: txt_prodID_update.Text = gridTo_updateFrom.SelectedRow.Cells[1].Text; Line 266: txt_prod_name_update.Text = gridTo_updateFrom.SelectedRow.Cells[2].Text; Line 267: ddl_ctegOf_Product_update.SelectedValue = gridTo_updateFrom.SelectedRow.Cells[3].Text; Line 268: txt_cateIn_hardCopy_update.Text = gridTo_updateFrom.SelectedRow.Cells[4].Text.Replace(" ", ""); Line 269: txt_prodID_update.ReadOnly = true;
The code of update:
private void PopulateDropDownList() { string constr = ConfigurationManager.ConnectionStrings[1].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT CategoryProd_ID,Cate_Pro_Name FROM CategoryOfProduct", con)) { using (SqlDataAdapter da = new SqlDataAdapter(cmd))
I have a standard gridview and detailsview. My detailsview has some fields which are templates, with dropdownlists. The user selects a record in the gridview, then can go down to the detailsview, select Edit, and change some values (using dropdownlists).I am getting the error, "DDL has a selectedvalue which is invalid because it does not exist...." when I click Edit in the detailsview.
I know the problem has something to do with the dropdownlists not being instantiated or bound until I enter Edit mode. Is that right? In what event should I databind my dropdownlists? I've tried several things but could not get it to work. Do I have to loop through all the rows of my details view looking for the dropdownlists, or can I access them directly from some event?
I have a dropdown list that has a bind on it and I get this error. Why am I getting this error and what can I do to fix it. here is the code for the dropdown I currently have:
I have a page with some bound DropDownLists (DDLs) for a Call Logging system. The Calls are categorised on three levels for example:
Call: 3069, Category 1: Incident, Category 2: Microsoft Application, Category 3: Word would be used to organise calls for problems with Microsoft Word. On testing the system, I noticed that there was no handling for opening a call if the category had been deleted - say for reorganisation/systems no longer supported whatever. So I set about trying to make the program behave in the following manner:
Check category ID exists in DDL before bindingIt doesn't: set the displayed text of the DDL to Category Name + "(Deleted)"Disable the control to prevent user changingMove on to next control Seemed simple enough, however no matter which way I try and do it I always get the messase ddl_Cat1 has a SelectedValue which is invalid because it does not exist in the list of items. What's really puzzling me is that the exception doesn't seem to be being thrown in the code behind. I've gone through line by line from Page_Init and it never throws and exception. Just when the page loads this appears.
Does anyone know of a reason as to why this wouldn't work? (I've already tried setting the selected value to an existing item, adding a new list item with the value and setting DataSource property to Nothing - in all different combinations.)
I have a listview and inside the listview I have a gridview. I'm binding data to the listview, then on the listview itemdatabound I'm binding the gridview. I want to make the gridview editable so I have an edit template and an edit command button. I have the event rowediting and inside there I set the edit index. Now normally I rebind the control and everything works. But if I rebind this gridview, nothing happens.
I can trace through the rowediting and everything is working. It's setting the edit index, it goes through the databind and gets the right data and binds it to the control. What is happening? Why isn't my rebound edit mode gridview showing up?
I'm using a Gridview in VS2008 framework 2.0 to edit a field with standard edit/save/cancel buttons on each row. I have a textbox named TextBox1 in an EditItemTemplate tag, it's value is binded to my field with '<%#Bind("LOGIN_NM")%>'. This is a simple form a took from an old project. My problem is when I try to read the textbox in the GridView1_RowUpdating event, it keeps returning the original value and not the modified value. I spent some time figuring the cells, controls and all so I'm sure I'm reading the right textbox, I have only one. I also tried using:
CType(row.FindControl("TextBox1"), TextBox).Text but I can't get the modified text to store in the database. The exact same thing works in the old project.
I am problem with gridview pager template,i have a dropdownlist in my pagercontrol butdl.selectedindexchange is not getting fired up if i am trying to bind gridview at code behind.But if iam using sqldatasource instead its working fine.
I think this needs to be a sticky since this is not solved anywhere that I have been looking... I have been googling this for a while now and came across the answer by shear luck and a simple typo when I was writing the code...
Problem: I have 2 dropdown lists...
ddllist1 and ddlist2... Both are code-behind populated via a sql DB.
they are cascading lists via the ajax control.
I am trying to dynamically populate them with values from a DB for edit reasons.
When I try to get them populated I kept getting the error...
"dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items"
Solution:
1) get the values from the DB or from where ever...
2) create a sql select to get the values from the ddl db
3) set the ID of the first DDL control to cddcontrol1.SelectedValue = id (this is a number)
4) set the value of the DDL to the string value ddlist2.SelectedValue = value (this is a string)
by default, my formview loads up to Editmode and it looks like this:
[Code]....
My Page_load looks like this:
[Code]....
Problem is if binding is not ran during postback here, buttons on the ItemInsert mode DO work, but the button on the ItemEdit mode DON'T work. However, if I don't bind the fv1 here during postback, controls will not load on the formview ItemEdit mode and databinding will not occur.
I have a GV that is populated via a reader: Using reader As SqlDataReader = cmd.ExecuteReader() I have autogenerate edit button=T but it will not go into editmode. Must I create template to handle this?
I have a GridView in MultiView and everything works fine. When page load everything looks good,but then when i try to edit something in my gridview it does postback and the whole gridview disappear from the multiview.
I am gettng the above error when I am using the Cascading Dropdown list in a DNN application. Everything works 100% until I try to post the form to the db then the error is thrown.I have attached the relevent code
I have a Gridview that shows my data, I allowed it to have Editing and Sorting. I have achieved refreshing my GV with <META HTTP-EQUIV="Refresh" CONTENT="15">. however, when I Edit and it hits the time to refresh, I loose the Edit mode and starts at the beginning of the grid (I need to find the data again.) Is it possible to still have the refresh (15secs) then when Iam in EditMode, the Refresh stops, then after I have clicked UPDATE. the refresh time starts to count again. (i use VB)
I have a simple FormView (fvDespatchPart) which updates the status of an order and it's despatch date; the despatch date being retrieved from a textbox (txtRentalDespatchDate) held within the FormView. The FormView's DefaultMode is set to Edit.
I have been trying to set the default entry for txtRentalDespatchDate to today's date in the code behind, using:
Dim dtNow As Date = Today()
Dim txtRentalDespatchDate As Webcontrols.Textbox = fvDespatchPart.FindControl("txtRentalDespatchDate") [code].....
I have had no trouble doing this in the past with FormViews whose default mode is set to Insert or Item, but in Edit mode it just does not seem to want to co-operate. I have read a few help posts, and have tried:
Putting that code in LoadComplete, PreRender, PreRenderComplete Page events, as well as the FormView's databound event. I've also tried nesting it within a ...
If fvDespatchPart.CurrentMode = FormViewMode.Edit Then
End If
... just to make sure if is in the right mode.
Nothing yet has resulted in anything but the same old error.
i try to fetch the data from the database and display text in the dropdownlist
i got the error message
'cmbslot' has a selectedvalue which is invalid because it does not exist in the list of items parameter name value cmbslot.Text = obj.getdata(dr["slotcode"].ToString()); //here is my code to retrive the data from the database