Thanks a bunch to you and the Regards Hema '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''' reply From Brianbk [email protected] The code it update Datagridview believe me was running try this one Dim constr As String = "Data Source=localhost; Integrated Security=True" Dim sqlstr As String = "select * from Customers" Dim dt As New Data Table() Private Sub btn Load_Click(By Val sender As System. Clear() 'fill the datatable with data in the Database Dim dpt As New Sql Data Adapter(sqlstr, constr) dpt. Dispose() 'display the Table in the datagrid datagridview1. i have a problem with this code which i used it before and it really works. Now the code of Grid View rowupdating events is: Text Box txt City = (Text Box)Grid View1.(Text Box)Grid View1. Text was the updated value but the old value returns. i compared also my source code into the other which is working but there is no difference from it. Related to this problem, but much worse: I have a Grid View, which isn't bound in the ways mentioned above; I need to use a custom data source, and create the data grid cells programmatically from it. But within the Row Update event handler, everything goes null. Sorry for the wrapping in the second snippet, I just don't think there's a way to make it more eye-friendly, even if I'd raze the leading spaces. protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) please help me.
I am using below lines to do the same.protected void Grid View1_Row Editing(object sender, Grid View Edit Event Args e) but getting error for Row Index which is as below. 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. 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. Six of those paramaters basically comes from the Text Box values that were entered in the page. Invalid Cast Exception: Unable to cast object of type 'System. The last parameter is a boolean value which tells the method whether to execute an Insert (false) or Update (true). In-order to perform Edit and Update in Grid View we need to use three events ( Grid View_Row Editing, Grid View_Row Canceling Edit , Grid View_Row Updating).