So the problem I am having is that when I get the Datakey value I am trying to get the values in the controls in the Edit Mode of the current row I am trying to update. I am using the Find Control function to get the values from the editing row so I specifically name the dropdownlists and textboxes so I can access them here.
Scenario: I am using the Row Updating Event of the Gridview to do updates because I need more flexibility than the SQLDatasource Update provides.
Close() End If End Sub Private Shared Sub On Row Updated( _ sender As Object, args As Sql Row Updated Event Args) If args.
Fill(data Set, "This Table") Private Shared Sub Fill Error(sender As Object, _ args As Fill Error Event Args) If args.
Dim cust Adapter As Sql Data Adapter = New Sql Data Adapter( _ "SELECT Customer ID, Company Name FROM Customers", connection) ' Add handlers. Row Updating, New Sql Row Updating Event Handler( _ Address Of On Row Updating) Add Handler cust Adapter. Row Updating, _ New Sql Row Updating Event Handler(Address Of On Row Updating) Remove Handler cust Adapter.
Row Updated, New Sql Row Updated Event Handler( Address Of On Row Updated) ' Set Data Adapter command properties, fill Data Set, and modify Data Set. Update(cust DS, "Customers") ' Remove handlers. Row Updated, _ New Sql Row Updated Event Handler(Address Of On Row Updated) Private Shared Sub On Row Updating(sender As Object, _ args As Sql Row Updating Event Args) If args.
I've tried not to bind the grid in Row Updating event,but then the editing row does not close and the row is not being updated.
When all you've got is a Hammer, Every Problem looks like a Nail. protected void Page_Load(object sender, Event Args e) protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) protected void Grid View1_Row Editing(object sender, Grid View Edit Event Args e) protected void Grid View1_Row Canceling Edit(object sender, Grid View Cancel Edit Event Args e) Superguppie. Edit, True) Dim field2Text Box As Text Box = Direct Cast(row.This can be beneficial to other community members reading the thread.When all you've got is a Hammer, Every Problem looks like a Nail. Since you are already getting a Row Updating event, I'll work from there. Text = my Text1 Dim update Description As String new Brief Descrip = row. If that is "brief_Descrip", you can use the Extract Data From Cell method of the Data Control Field on the Cell to get the value. Add("prev_Lang String", update String) item Data Source. Add("brief_Descrip", update Description) item Data Source. Find Control("brief_Descrip"), Text Box) I can see the sort Expression in field1Field, line 2 of code above, Values returns Nothing though. Description: An unhandled exception occurred during the execution of the current web request. I understood about the lack of an update command and the labels to display the data, thanks. Cells(6), Data Control Field Cell) Dim field1Field As Bound Field = Direct Cast(field1Cell. If that is a Bound Field, cast to that and you will have access to the Data Field property. Update ' Notify the user that the update was successful. Extract Values From Cell(values, field1Cell, Data Control Row State. Text = Direct Cast(values("Field1"), [String]) Dim field2Text Box As Text Box = Direct Cast(row. When I wrote that demo, I also wanted to show that columns could be selected by examining Data Field. So i think I am giong to change back to boundfields since it did not error, and try to figure out why I was not getting the value that had been entered. Row Index) Dim field1Cell As Data Control Field Cell = Direct Cast(row.In the code below I do get the Country ID and Region ID but they are the original values not the new ones selectedfrom the Edit Mode row.