the good old problem of getting the data from the row that is being currently edited within a Grid View. Accessing the "Controls": This method gets you access to the control in the Grid View, which might be useful based on what you are doing.Obviously the simplest method is to use Data Key Names on the Grid View and then you should have the data in your Grid View Update Event Args as part of e. (In the following example, I cast to a Check Box as I know I have a checkbox at the col Index You Are Interested In - you should cast to whatever control you have in that column).First, I load up some data: After that, I’m doing some work to make my Grid View look beautifull, adding all columns by hand.But for this demo, I’ll show you the simple version, that also doesn’t work 🙂Let’s bind the data to our Grid View and have it autogenerate our columns, as well as an edit button.Free counters Added on January 19,2012 Follow Me @vmsdurano A bit About Me Disclaimer The opinions expressed herein are my own personal opinions and does not represent the opinions of my employers. Contol)Text; it werk just Fine any comment and thx for the code Instead of adding a Customer ID to your table and later pulling the text to get the ID number, a more reliable way to do it is to add a Data Key Names field to the grid example in the page: You can then access this information at any time with the following in code: Grid View1. Row Index]["id"]); You can do this with any field, but I've found customers get confused when they see the ID field and kept asking me why it was there, this also eliminates any issues if you change the display order of your table later (maybe add an edit/update/cancel control) Hey...great article ;)But I got a problem... So here I go with my example:protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) and the debugger says: Exception Details: System. Nor does it represent the opinion of my dog, because I don’t have one. I have a project that I coppied the above code into. Data Keys[Row Index]["Customer ID"]in the Update event it would be something like:int Customer ID = Convert. Format Exception: Input string was not in a correct format. As the values are inserted into an Ordered Dictionary - you can use the field names to access the changed data 2. There are multiple ways in which one can get the data from the current row that is being edited in a Grid View. Using "Extract Values From Cell": This is an easy way to get all the values from the current row.
That means if there are 100 rows to be updated the Sql Data Adapter will execute 100 separate operations against the database.This demo is a continuation of my previous example “Binding Grid View with Data”. When I do an update, and get to the Grid View1_Row Updating, there is no value passed to "ID", and then when I go to the next row for "Company" I get the following error: Specified argument was out of the range of valid values. Text; bit when ichange it to string id =((Text Box) Grid View1. Line 136: Source Error: Line 134: string Um = ((Text Box)Grid View1. If you are not familiar of binding the Grid View the way then I would suggest looking at my previous example first before you proceed to this example. Parameter name: index Any idea what I need to do to fix this issue? As you might have guessed this is not efficient while dealing with large number of rows.Fortunately Sql Data Adapter allows you to execute updates in batches. number of rows to be treated as a single batch via Update Batch Size property.