I am trying to add a row to a database, i am able to put the row into the database and view it ina datagrid while the VB program is running, but when the program closes that row dissapears. What code am i missing to update the database table instead of just the working dataset?
Code:Dim saverow2 As DataRow If saverow = 0 Then saverow2 = MainDBDataSet.Assesments.NewRow() saverow2.Item("Customer") = CustomerName . . . MainDBDataSet.Tables("assesments").Rows.Add(saverow2) Me.TableAdapterManager.UpdateAll(Me.MainDBDataSet) endif




Reply With Quote