Solved

dropdownlist in gridview in edit mode?

Posted on 2008-10-06
25
857 Views
Last Modified: 2012-05-05
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
Comment
Question by:dkim18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 14
  • 11
25 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22650474
That just means that there isn't an exact match between the 'Status' column in the datasource, and the list items.
0
 

Author Comment

by:dkim18
ID: 22650579
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22650621
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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:dkim18
ID: 22650746
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22650767
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
 

Author Comment

by:dkim18
ID: 22651121
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22651163
Are you saying that you are getting values from the same SqlDataSource that the other data elements are bound to?
0
 

Author Comment

by:dkim18
ID: 22651287
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22651355
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
 

Author Comment

by:dkim18
ID: 22651578
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
 

Author Comment

by:dkim18
ID: 22651592
I meant to say they are all in lower case.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22651612
When run the web site, and that page is displayed in the browser, how is that section rendered (View Source in browser)?
0
 

Author Comment

by:dkim18
ID: 22651759
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
 

Author Comment

by:dkim18
ID: 22651779
If you are talking about the edit page, it has the error messages instead.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22651799
No, I am talking about right-clicking on the page in the browser, and selecting 'View Source'.
0
 

Author Comment

by:dkim18
ID: 22651821
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
 

Author Comment

by:dkim18
ID: 22651866
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22652144
After clicking the "Edit".
0
 

Author Comment

by:dkim18
ID: 22652268
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22652338
You know what would help me understand your problem?  Can you give me a small test .aspx page that highlights your error?
0
 

Author Comment

by:dkim18
ID: 22652722
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22658916
I haven't a clue as to why you are having that problem.
0
 

Author Comment

by:dkim18
ID: 22659287
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
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 22659349
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
 

Author Closing Comment

by:dkim18
ID: 31503431
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question