Solved

dropdownlist in gridview in edit mode?

Posted on 2008-10-06
25
844 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
  • 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
 

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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now