Send Form Data Changes To Database

I have a form that gets its data through datasets but gets filtered down to only one record via the following code:

 Dim tempView As Data.DataView
        tempView = New Data.DataView(myDataSet.Tables("main"))
        tempView.RowFilter = "ctl_num = " + mycombobox.SelectedValue.ToString
        name.Text = tempView(0).Item("nameonform").ToString()
        systemdate.Text = tempView(0).Item("date_added").ToString()
        fullname.Text = tempView(0).Item("full_name").ToString()
        active.CheckState = tempView(0).Item("active").ToString()

After the user edits the record I am trying to send those changes to update the database.  I thought that this could be done by writing an update command to the adapter.  How can this be done??
LVL 1
H-SCAsked:
Who is Participating?
 
armoghanConnect With a Mentor Commented:
once the user edits the record, you should again assign things back to dataset,

e.g. on Save method

do something like
tempView = New Data.DataView(myDataSet.Tables("main"))
        tempView.RowFilter = "ctl_num = " + mycombobox.SelectedValue.ToString
        tempView(0).Item("nameonform") = name.Text
        tempView(0).Item("date_added") = systemdate.Text ' If date is also changing
        tempView(0).Item("full_name") = fullname.Text
        tempView(0).Item("active") = active.CheckState.ToString()


and then do update  


0
 
H-SCAuthor Commented:
armoqhan,

Perfect!  That works great  many thanks
0
All Courses

From novice to tech pro — start learning today.