Start Rowupdating which

Rowupdating which

I've configured the Grid to allow Multiple updates by replacing the default Label Controls with Template Fields using the approach described here: Bulk Updates to Rows Bound to a Grid View Everything was working fine, until I made a change to bind the Gridview query programmatically on page load (With the aim of making the Gridview display different data depending on the user currently viewing the page) as described here: Bind Gridview programmatically. Page Protected Sub Page_Load(By Val sender As Object, By Val e As System. Load If Not Is Post Back Then gvbind() End If End Sub Public Sub gvbind() Dim Sql Data Source1 As New Sql Data Source() Sql Data Source1.

You access the values stored in the event by index or name: e. So, to update, you might set the parameters as id = e. of course, if I have 20 columns I could define 20 data keys but I just wondered if there is another way instead of: Sql Data Source Locations.

PS: location name is not an integer You don't access the table cells by name. So, basically, instead of looking for table cells, look for the appropriate e. New Values Hi mckrecker, thanks for your reply but I dont need to differ between old and new values since I set a datakey which is the unique ID in my db and I update where unique ID = @unique IDselected of column.

New Values -- it will have all the values, as does e. There are two in that event so data source controls can differnitate bewteen the two.

Update() End Sub one of my other fields does not work either.

Select Command = "SELECT [ID], [Project], [Description], [CAPEX], [Team] FROM [CAPEX]" 'Add Conditional Statements to change view for users/Teams 'Sql Data Source1.

Data Row Then If Not table Copied Then original Data Table = CType(e.

Sql Command command Type=2 records Affected=1 row=System.