Update db Only

[Ingrid Williams]

Is there a way to perform only an update to a database table (no insert or delete)  when listbox item is transferred from a souce radlistbox to a destination listbox.  Please supply some code in VB if possible.

Thank you

[Bozhidar]

Hi Ingrid,

The action which is performed on the database when you transfer an item is determined by the InsertCommand that you've set on the destination listbox's datasource (and DeleteCommand on the first one, if the transfer mode is set to move). So if you want to do an update, all you have to do is set an update query to these commands. Here's a small example:

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
    ConnectionString="<%$ ConnectionStrings:Area2ConnectionString %>"
    SelectCommand="SELECT * FROM [Areas]"
    InsertCommand="UPDATE [Areas] SET [update_user] = @update_user, [contactID] = @contactID WHERE [id] = @id">
    <InsertParameters>
        <asp:Parameter Name="id" Type="Int32" />
        <asp:Parameter Name="update_user" Type="String" />
        <asp:Parameter Name="contactID" Type="Int32" />
    </InsertParameters>
</asp:SqlDataSource>

If you want to learn more about the ListBox's automatic database update mechanism, you can refer to the following help article:
http://www.telerik.com/help/aspnet-ajax/listbox-automatic-database-updates.html 
 
All the best,
Bozhidar
the Telerik team