Hi all,

before I start, I have read the various threads on this topic, followed the advice (as you will see below) but it still hasn't resolved my problems. I'm also creating a simple database application quickly, so data binding is really my best option if I can get it working.

I'm trying to save data to a database (SQLite), but it's just not happening. Onscreen, all looks well, but when you close the application, the data changes are lost.

I have:
A Data Connection
A Data Set with 3 of my tables defined in it
A DataGridView Control, successfully displaying records from the dataset. It's using a Binding Source, which it automatically created.
A small number of text fields bound to the same BindingSource.
A Data Adapter that was automatically created for me.

So now I can click on a row in the DataGridView, and the text fields update correctly. I can edit the text field, navigate away, come back and my new data is still intact.

I thought that data was automatically updated for me. I have read, however, that this isn't necessarily the case. So in the DataGrid RowValidated Event I followed some advice I found that suggests at this point you should EndEdit on the Binding Source, and Update the Data Adapter. The Data Adapter errors, complaining about concurrency and no rows being available to update. I have ignored this error, but the data still doesn't reach the database.

Any .net data geniuses (genii?) out there that can shed some light on where my issue lies?