I have a aspx page which has no problem to show multiple records from a db table as selected items in list box control ASP.net 2.0. After user change their selection in list box, how can I effectively and correctly post the user selections back to db table?
Is DELETE current records and INSERT new records a better solution? How can I roll back transaction correctly if something wrong happen when executing the sql commands?
Please give your suggestion.
Thanks in advance.