Need server side SQL commands for Telerik Listbox Update/Insert/Delete
Posted on 2011-09-09
I'm using 2 listboxes to manage add/reorder/delete of records in a linking table.
Table 1 is the feeder table -Table1.ID, Table1.Descrip fills Listbox1
Table 2 is the linking table - Table2.KeyID, Table1ID, Table3ID, Table2SortOrderInt
Table 3 is the other feeder table - Table3.ID, Table3.Descrip
Since it uses a LinkTable, Telerik's basic drag/drop automatic updates don't support it. The listbox on left works fine, showing Table1 info. The listbox2 works fine and refreshes with postbacks but nothing is saved to SQL yet.
I need help writing the code behind, vb.net, to commit the changes in Listbox2 please. Is it something that can be done on Unload each time?