I've hunted around quite a bit on this one. There seem to be as many potential solutions as there are folks who have asked the question. I'm rewriting a vb6 app in .net and rather than use the conversion process i felt that the app could do with a complete redesign
I have an access database being displayed by a datagrid in vb.net 2003. Works fine I can search and sort and edit and add but i can't delete.
Dim mySurname As String
mySurname = txt_SearchSurname.Text & "%"
OleDbDataAdapter1.SelectCommand.Parameters("SURNAME").Value = mySurname
I can update rows in the datagrid and update the database with
I can add new rows and get them added in the database but as for deleting i'm stuck.
I would appreciate help to get a simple way to add delete functionality.