Yes, you can use the list as a parameter to the
ModifyTable
as you have already defined. The problem you would have is, what is the state if a single
Emp
? Is it added, modified, deleted or unchanged. You have to know this in order to decide the SQL statement.
I noticed that you have used a data table from which you pull out the list. Data table has a mechanism to track the state of a row (well actually each data row has this). So why not use the data table and make the modifications directly to it and use a
SqlDataAdapter[
^] to actually carry out the modifications.