Connecting Tech Pros Worldwide Forums | Help | Site Map

Save changes to textboxes bound to Dataview?

jasmith@bigriver.net
Guest
 
Posts: n/a
#1: Feb 5 '06
I can't seem to get this to work! Basically, I have filterd a dataview
and have bound the text boxes on my form to the dataview:

dvEqDetails.Table = dsUpdateEq.Tables("tblControlData")
dvEqDetails.RowFilter = "txtControlNumber = '" &
Me.txtControlDisplay.Text & "'"
Me.txtLoc.Text = dvEqDetails(0)(1) '<-- Row 1,
Col 2
Me.txtManufacturer.Text = dvEqDetails(0)(3)

The form populates the textboxes with the filtered values from the
dataview just fine. Now, the users edits the changes to the filtered
record and then clicks the save button to save the changes:

daUpdateEq.Update(dsUpdateEq, "tblControlData")
MessageBox.Show("Update complete.", conAppTitle)

When I check the actual values in the database, they are not changed.
How can I save the changes to the database after the user edits the
original populated values in the dataview?

Am I going about this in the wrong way?

Thanks,

Jason


jasmith@bigriver.net
Guest
 
Posts: n/a
#2: Feb 5 '06

re: Save changes to textboxes bound to Dataview?


Got it. I was able to do it by using the command objects parameter
collection instead of using the dataview.

Closed Thread