I have datagridviews where I've removed the ability for users to edit them directly. I have made add and delete buttons for users to add rows and remove selected rows.
Occasionally, and I'm not sure why, I get the "Prepare: CommandText..." error, as well as "Update requires a valid ___Command..."
Function AddRow(ByVal input As String, ByVal ds As DataSet, ByVal tablename As String, ByVal dgv As DataGridView)
Dim NewRow = ds.Tables(tablename).NewRow()
Dim Table = ds.Tables(tablename)
NewRow.Item(1) = input
Table.Rows.Add(NewRow)
Return False
End Function
Function DeleteRow(ByVal selectedrows As DataGridViewSelectedRowCollection, ByVal ds As DataSet, ByVal dgv As DataGridView)
For Each r As DataGridViewRow In selectedrows
If Not r.IsNewRow Then
dgv.Rows.RemoveAt(r.Index)
End If
Next
Return False
End Function
There's my code for adding and removing rows. Heres my code for updating.
Function UpdateAccountTable()
frmMain.AccountsTableAdapter.Update(frmMain.DsAccounts)
Return False
End Function
Function UpdatePURLTable()
frmPURL.ProfileURLsTableAdapter.Update(frmPURL.DsProfileURLs)
Return False
End Function
Function UpdatePLocationTable()
frmPLocation.ProfileLocationsTableAdapter.Update(frmPLocation.DsProfileLocations)
Return False
End Function
Function UpdatePDescriptionTable()
frmPDesc.ProfileDescriptionsTableAdapter.Update(frmPDesc.DsProfileDescriptions)
Return False
End Function
Let me know if I'm missing something. Thanks!
btw, is there any way to define a tableadapter as a type so I can make 1 function for updating?