When to use DataAdapter?

[Haunter]

I am using MySQl to develop and simple app that stores inputted data and then dumps it to a formated text document once the submission is completed. Most of the data is and INSERT on the data base. Although UPDATEs are always needing to be done but not really frequently. Are there guide lines on when to use the dataAdapter and when not too. It seems that is just is a lot of overhead programming. I dont really have the need for disconnected data, but who ever knows how the user will use your software. Any thoughts?


haunter@battlestrata.com

 

[sbdSolna]

I'm using DataAdapter, when I working along with a DataGrid. When I init the program I set up one DataAdapter to each Table used by the DataGrid, with select, insert and update commands.
Then when the user edit the Grid, I have a button for update of the edited rows, I also have a button to Reject Changes.
When the user hits update I do DataAdapter Update Command. And when the user hits Reject I do DataAdapter RejectChanges Command.