Solved

dropdownlist in gridview in edit mode?

Posted on 2008-10-06
25
852 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

920 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

16 Experts available now in Live!

Get 1:1 Help Now