I have just started using VB.NET having come from an Access background. I'm sure this is a simple question ....
I have created a form, on which there is a datagrid control (dataGridView1) which gets it's data from a DataSet (AddressSQLDataSet) linked to a SQL database. The data appears on the datagrid control as I expect.
I want to Add, Delete and Edit the data in the datagrid and to change the corresponding data in the SQL database, but any changes I make in the datagrid are not kept. If possible I would like to manipulate data with commands and methods similar to what is found in VBA. e.g. Addnew, Edit, Update etc. but this is not essential.
In addition I would like to search the underlying dataset as I would a recordset in VBA, i.e.
'I know this doesn't work...
Dim rec as Recordset
Set rec = AddressSQLDataSet.OpenRecordSet
rec.movefirst "LastName = Jon*"
Msgbox "Can't find that"
Msgbox "AddressID for the record is..." & rec!AddressID
Suggestions would be gratefully received.