• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 875
  • Last Modified:

dropdownlist in gridview in edit mode?

Hi,

I have this dropdownlist in gridview in edit mode.
It is telling me that the selectedvalue is not one of value in the list.

In my database, I have the folliwing values, active, inactive, reject.
My template looks OK to me.

Do you think the value in the database has some blank spaces after the value?
How to trim the space before I can bind it??  <%# Bind("status") %>  =>> <%# Trim(Bind("status") ) %> or something??
<asp:TemplateField HeaderText="TAType">
                    <EditItemTemplate>
                        <asp:DropDownList ID="ddTAType" runat="server" SelectedValue='<%# Bind("status") %>'
 <asp:ListItem>active</asp:ListItem>        
 <asp:ListItem>inactive</asp:ListItem>  
 <asp:ListItem>reject</asp:ListItem>  
                </asp:DropDownList>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblTAType" runat="server" Text='<%# Bind("status") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>

Open in new window

0
dkim18
Asked:
dkim18
  • 14
  • 11
1 Solution
 
Bob LearnedCommented:
That just means that there isn't an exact match between the 'Status' column in the datasource, and the list items.
0
 
dkim18Author Commented:
record I selected to edit has a value of active.

So I don't know if the database has extra space at the end of the value, active___.
How can I trim that??
0
 
Bob LearnedCommented:
How are you adding items to the DropDownList?  Are they statically, or dynamically added?  Is there a post-back involved when you experience this problem?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
dkim18Author Commented:
Sorry I forgot about the detail view.

Basically, I have a gridivew and when selected a record, you will get a detail view.
From the detail view, you click a edit link to get into the edit mode.
I am trying to add a dropdownlist in edit mode. This error message comes out when I try to get into the edit mode.

0
 
Bob LearnedCommented:
Ok, my friend, that is a completely different story, and yet it doesn't answer my question.  I'll repeat it--"How are the items added to the DropDownList?"
0
 
dkim18Author Commented:
Sorry.
I don't follow your quesiton, "How are the items added to the DropDownList?"

I am using the sqldatasource to bind the detailview.
So the dropdownlist's status will get the value from the sqldatasource.
Like here,
asp:DropDownList ID="ddTAType" runat="server" SelectedValue='<%# Bind("status") %>'
 <asp:ListItem>active</asp:ListItem>        
 <asp:ListItem>inactive</asp:ListItem>  
 <asp:ListItem>reject</asp:ListItem>  
                </asp:DropDownList>

Sorry if I am not answering your question.

0
 
Bob LearnedCommented:
Are you saying that you are getting values from the same SqlDataSource that the other data elements are bound to?
0
 
dkim18Author Commented:
Yes.
The detailsview will bind the data from my sqldatasource and status label in the detailsview has 'active' value.
Now I want to edit this detailsView and when i click edit, i want to create a dropdownlist and this dropdownlist should bind the 'active' value since that's the value of it from the sqldatasource.
Isn't that what I did here?? I am getting confused now..hhhh.


asp:DropDownList ID="ddTAType" runat="server" SelectedValue='<%# Bind("status") %>'
 <asp:ListItem>active</asp:ListItem>        
 <asp:ListItem>inactive</asp:ListItem>  
 <asp:ListItem>reject</asp:ListItem>  
                </asp:DropDownList>

0
 
Bob LearnedCommented:
Since you have these:

<asp:ListItem>active</asp:ListItem>        
 <asp:ListItem>inactive</asp:ListItem>  
 <asp:ListItem>reject</asp:ListItem>  

I am guessing that you went to the designer for the DropDownList, and manually added those items.  And, you are binding the DropDownList to the same SqlDataSource to get the value.

This should work as advertised, so the only thing that I can think of, is that the values are not matching from the database.  Maybe, it is "Active", "Inactive", and "Reject", and not "active", "inactive", and "reject".
0
 
dkim18Author Commented:
They are not all lower case. So I don't know why it is saying the selectedvalue doesn't exit in the list of items.
0
 
dkim18Author Commented:
I meant to say they are all in lower case.
0
 
Bob LearnedCommented:
When run the web site, and that page is displayed in the browser, how is that section rendered (View Source in browser)?
0
 
dkim18Author Commented:
Exact error message is
DDL1 has a selectedvalue which is invalid because it does not exist in the list of items.
Parameter name: value.
0
 
dkim18Author Commented:
If you are talking about the edit page, it has the error messages instead.
0
 
Bob LearnedCommented:
No, I am talking about right-clicking on the page in the browser, and selecting 'View Source'.
0
 
dkim18Author Commented:
by the way,
without the selectedvalue property. it works fine.
But it always defaults to the active no matter what true value might be.


asp:DropDownList ID="ddTAType" runat="server" > <asp:ListItem>active</asp:ListItem>        
 <asp:ListItem>inactive</asp:ListItem>  
 <asp:ListItem>reject</asp:ListItem>  
                </asp:DropDownList>
0
 
dkim18Author Commented:
I understand that.
Are you asking for the detailview page prior to clicking the edit or after??
If you are talking about the after, the source view has the error page source instead.
If you are asking for the before you click the edit, it looks file as you expect since it doesn't have the dropdownlist yet.
0
 
Bob LearnedCommented:
After clicking the "Edit".
0
 
dkim18Author Commented:
I only see the error page. Nothing gets rendered except you get the error message.
You only the error page html codes.

Sorry if I am wasting too much time of yours.
It seems to be a simple control but I am not getting it correctly.
Again thanks for your time
0
 
Bob LearnedCommented:
You know what would help me understand your problem?  Can you give me a small test .aspx page that highlights your error?
0
 
dkim18Author Commented:
Unforutnately I cannot copy my error page since I don't have internet access from that system.

But I found a similar page online.

'DropDownList1' 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: 'DropDownList1'
has a SelectedValue which is invalid because it does not exist in the
list of items.
Parameter name: value

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.


Stack Trace:


[ArgumentOutOfRangeException: 'DropDownList1' has a SelectedValue which
is invalid because it does not exist in the list of items.
Parameter name: value]
System.Web.UI.WebControls.ListControl.PerformDataB inding(IEnumerable
dataSource) +1777763
System.Web.UI.WebControls.ListControl.OnDataBindin g(EventArgs e)
+104
System.Web.UI.WebControls.ListControl.PerformSelec t() +31
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.Control.DataBindChildren() +216
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32
dataSourceIndex, DataControlRowType rowType, DataControlRowState
rowState, Boolean dataBind, Object dataItem, DataControlField[] fields,
TableRowCollection rows, PagedDataSource pagedDataSource) +221
System.Web.UI.WebControls.GridView.CreateChildCont rols(IEnumerable
dataSource, Boolean dataBinding) +3004

System.Web.UI.WebControls.CompositeDataBoundContro l.PerformDataBinding(IEnumerable
data) +59
System.Web.UI.WebControls.GridView.PerformDataBind ing(IEnumerable
data) +11

System.Web.UI.WebControls.DataBoundControl.OnDataS ourceViewSelectCallback(IEnumerable
data) +111
System.Web.UI.DataSourceView.Select(DataSourceSele ctArguments
arguments, DataSourceViewSelectCallback callback) +29
System.Web.UI.WebControls.DataBoundControl.Perform Select() +149
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound() +82

System.Web.UI.WebControls.CompositeDataBoundContro l.CreateChildControls()
+69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+1360


================
It is kind of strange. If I just put a lable and use the same <%# Bind('staut') %> it attaches the right value.
So I don't get it..
0
 
Bob LearnedCommented:
I haven't a clue as to why you are having that problem.
0
 
dkim18Author Commented:
This shouldn't be this diffcult. This is very common controls but I can't believe I can't find a solution.
I will have to do some behind the code operations to get this work.
I googled around found some people having similar issues but can't find clear solution to it.
Thanks for your time.
0
 
Bob LearnedCommented:
Well, you have to remember that I am sitting here, and I can't come look over your shoulder, so I have to rely on your descriptions of the problem.  A lot of problems with ASP.NET, are about misunderstanding the page life-cycle, or not handling post backs correctly.
0
 
dkim18Author Commented:
Thanks TheLearnedOne for your help.

I worked it out. You R right. I just didn't know how to use the dropdownlist's property in the detailsview.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 14
  • 11
Tackle projects and never again get stuck behind a technical roadblock.
Join Now