Example of Updating a Database using a DataTable
Posted on 2011-09-12
I was recently advised that I should NOT use DataSet and TableAdaptors to preform Updates and Inserts to a individual table within my database. They strongly suggested I use a DataTable to perform these sort of updates.
I've hunted Google for a good example of how one does this but, believe it or not, I'm not finding anything worth following.
I'm hoping one of you here on the Exchange could provide me with a very simple example of your UPDATE DAL and you BLL function that would call the Update.
The simipler the better. I'm really trying to wrap my head around using DataTables for Updates rather than DataSet. I really want to do it the right way.
Thanks in advance for your help.