VB.NET - Updating information back in SQL table without Datagrid view

Asked By Tony Reilly-Cooper on 28-Nov-14 08:24 AM
Wonder if someone can help with a coding query. 
I have a Win forms application that connections to an SQL database. A user performs a search for a product in the database and the results are displayed in the datagridview. Then the user can double click on the item and it opens a win forms window with all the information from the datagridview clearly displayed (see below). I am struggling to get my head around being able to save any changes in the winform back to the SQL table. E.g. if I changed the product name and wanted to update its entry in the database? Hope this makes sense, appreciate any help I can get. Cheers

Code to populate the winforms application:
http://www.dreamincode.net/forums/topic/358866-editing-information-via-datagridview-and-winforms/#viewSource
http://www.dreamincode.net/forums/topic/358866-editing-information-via-datagridview-and-winforms/#printSourcehttp://www.dreamincode.net/forums/topic/358866-editing-information-via-datagridview-and-winforms/#about
01 Try
02   Dim i As Integer
03   i = DGV_SearchResults.CurrentRow.Index
04   Current_Selected_Product.Show()
05   Current_Selected_Product.cmb_ProductType.SelectedValue = DGV_SearchResults.Item(1, i).Value
06   Current_Selected_Product.txt_ProductAvailablity.Text = DGV_SearchResults.Item(2, i).Value
07   Current_Selected_Product.txt_ProductPriceText = DGV_SearchResults.Item(3, i).Value
08 Catch ex As Exception
09   MsgBox("Error: " & Err.Description, MsgBoxStyle.Critical, Title:="Information Load Error")
10 End Try