Solved

Got error when retrieving the current text value out of a gridview control during gridview Updating event.

Posted on 2014-12-21
11
234 Views
Last Modified: 2014-12-22
Hi, I'm using vs2012.
I used the code form msdn, http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowediting%28v=vs.110%29.aspx

However, I'm getting out range error in run time.    Attached is my code snipet.  The error happens at
 "var sam = ((TextBox)(editRow.Cells[1].Controls[0])).Text;"

I think that the code is taking the row that is being edited (editRow is correct when I examine the property).  Cell 0 I think is the Edit button on my grid, it shows as the first column.  So cells[1] is the column that I want.  Examine the property of Cells show it has count of 6 and that is correct, 1st one is the Edit button generated by gridview control  however, the error is with Controls[0] being out of range.  

In the aspx file, the 1st cell is a boundfield, code as below
<asp:BoundField DataField ="sAMAccountName" HeaderText="User ID" ReadOnly="True" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle"></asp:BoundField>

Appreciate help here to fix the problem.  Thank you.

I add editRow.Cells to the Watch and there is a cells[1] object.  But I don't know how to expand to see where is the Controls[0] because that's where I get the error.  I'm attaching the screen shot for this too.

further examination by adding to the Watch panel, I found the error is caused because Cells[1].Controlls.count is 0.  I'm also attaching a screen shot for this.  Why is that so?  It does display the data that it's bound to.  How can I fix this?
Thank you.
snipet.txt
grid-err-1.png
grid-err-2.png
0
Comment
Question by:lapucca
  • 7
  • 4
11 Comments
 
LVL 35

Expert Comment

by:Miguel Oz
ID: 40511976
Please post your grid view mark up and/or sample page you are using. (and any other code setting change that differs from sample MSDN)
0
 

Author Comment

by:lapucca
ID: 40512006
Attached is the gridview snipet code from the aspx page.
rowUpdating.txt
grid.txt
0
 
LVL 35

Expert Comment

by:Miguel Oz
ID: 40512121
Any particular reason for not using Text property:
            editUser.GivenName = editRow.Cells[2].Text;
            editUser.Surname = editRow.Cells[3].Text;

Open in new window

0
 

Author Comment

by:lapucca
ID: 40512133
Because that's the example form msdn, in the row upating event.
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowediting%28v=vs.110%29.aspx 

It does work for all other columns except the User ID column that I get the out of range error.  It's odd that it shows no controls at all for this cell.  I am able to get data back for other columns except this one and the last column which I think it's a date conversion problem.  Any idea on how t fix this?
0
 
LVL 35

Expert Comment

by:Miguel Oz
ID: 40512242
Your user id column is not being mapped into the grid mark up, thus it is not visible and it does not have an associated control.

For data conversion, check if my  proposed solution fix your issue.
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:lapucca
ID: 40512321
The userid column is  displaying correct data that is bind to the gridview.  If it isn't mapped then how can it display the data? How to tell that it isn't mapped to the grid?  Thank you.
0
 

Author Comment

by:lapucca
ID: 40512327
In the gridview smart tab I also see this column configured properly already.  Attached is the screen shot.
smart-Tab.png
0
 

Author Comment

by:lapucca
ID: 40512334
This column is the only ReadOnly column.  I set ReadOnly property to false and now I can retrieve the value.  How to get around this?  I don't want user to edit this column but user id is the key for me to find which record in the collection the user is editing.
0
 
LVL 35

Accepted Solution

by:
Miguel Oz earned 500 total points
ID: 40512340
Just use editRow.Cells[1].Text to access the value.
0
 

Author Comment

by:lapucca
ID: 40512359
editRow.Cells[1].Text returns an empty string, ""
0
 

Author Closing Comment

by:lapucca
ID: 40513962
That works perfectly but I had to first change back that column to Read Only.  Thank you Miguel.
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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

948 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

19 Experts available now in Live!

Get 1:1 Help Now