Updating database with datagrid
Reviews: "dunfiddlin likes his Data Tables" - jmcilhinney Please be aware that whilst I will read private messages (one day! ) I am unlikely to reply to anything that does not contain offers of cash, fame or marriage! Base Directory & "baza_podatkov.mdb" Dim cnn As New Ole Db Connection(CONNECT_STRING) cnn. ) I am unlikely to reply to anything that does not contain offers of cash, fame or marriage! Base Directory & "baza_podatkov.mdb" ' "Provider=Microsoft.
Should I fill datagridview with two SELECT statements without joined tables? Joining tables shouldn't make any difference as long as you update to exactly the same combination as you originally filled the DGV with the binding should take care of assigning the new values correctly. Load 'TODO: This line of code loads data into the 'Baza_podatkov Data Set.narocilo' table. Dim CONNECT_STRING As String = _ "Provider=Microsoft.
Close() End Sub Your problem is in trying to update single values. As I said you need to make the identical selection and then update the whole lot from the dgv bound table..