I have an app in WPF that has numerous controls that are bound to datatables that are filled from sqlserver.
I now need to add the code for updates, inserts and deletes
Where should I put the code to implement this?
I found code
._adapter.UpdateCommand.CommandText = "tool generated update command
in an auto-generated section of the source file that VS created
it looks almost correct but I have never before seen an update statement with an order by clause.
I also found multiple instances of:
.Adapter.UpdateCommand != null
.Adapter.UpdateCommand.Connection = value
But I cannot find where value is defined or assigned
I have a tabbed interface with a selection list to move back and forth through the datatable.
I want to update the data base with all changes to the current selection when a user changes selection or selects a different tab
So what is the preferred method to initiate the update and where should
View Complete Post