Questions on UI for ASP.NET AJAX Forum

2 questions

1 answer

305 views

Saving selected items in MultiSelect (Template Column in a Grid) to SQLDataSource

I have a Grid with a template column with a MultiSelect as the EditItemTemplate. The MultiSelect displays fine with all of the available values, but I can't figure out how to save the selected items to the database.

When I use a ComboBox, I used SelectedValue='<%# Bind("Team_ADS_Person_IDs") %>' to bind and the selected value is saved in the Team_ADS_Person_ID field correctly, but I'm not sure what to use for the MultiSelect.

<MasterTableView DataKeyNames="Record_ID" EditMode="InPlace" DataSourceID="sql" AutoGenerateColumns="false" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" AllowAutomaticDeletes="true">
    <Columns>
        <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" HeaderStyle-Width="110px"></telerik:GridEditCommandColumn>
        <telerik:GridTemplateColumn HeaderText="Team" SortExpression="Team_ADS_Person_IDs" HeaderStyle-Width="275px">
            <ItemTemplate>
                <%# Eval("Team_ADS_Person_IDs")%>
            </ItemTemplate>
            <EditItemTemplate>
                <telerik:RadMultiSelect ID="selTeam" runat="server" DataSourceID="sqlEmployee" DataTextField="Display_Name" DataValueField="ADS_Person_ID" Filter="Contains" Width="100%" AutoClose="False"></telerik:RadMultiSelect>
            </EditItemTemplate>
        </telerik:GridTemplateColumn>
        <telerik:GridButtonColumn Text="Delete" CommandName="Delete" ConfirmText="Are you sure you want to delete this record?" HeaderStyle-Width="50px" UniqueName="DeleteCommandColumn">
        </telerik:GridButtonColumn>
    </Columns>
</MasterTableView>
</telerik:RadGrid>


<asp:SqlDataSource ID="sql" runat="server" ConnectionString="<%$ ConnectionStrings:csCHPServiceDesk %>" SelectCommand="Release.usp_Product" SelectCommandType="StoredProcedure" InsertCommand="Release.usp_Product" InsertCommandType="StoredProcedure" UpdateCommand="Release.usp_Product" UpdateCommandType="StoredProcedure" DeleteCommand="Release.usp_Product" DeleteCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="Action" DefaultValue="Select" Type="String" />
    </SelectParameters>
    <InsertParameters>
        <asp:Parameter Name="Action" DefaultValue="Insert" Type="String" />
        <asp:Parameter Name="Team_ADS_Person_IDs" Type="String" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="Action" DefaultValue="Update" Type="String" />
        <asp:Parameter Name="Record_ID" Type="Int32" />
        <asp:Parameter Name="Team_ADS_Person_IDs" Type="String" />
    </UpdateParameters>
    <DeleteParameters>
        <asp:Parameter Name="Action" DefaultValue="Delete" Type="String" />
        <asp:Parameter Name="Record_ID" Type="Int32" />
    </DeleteParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="sqlEmployee" runat="server" ConnectionString="<%$ ConnectionStrings:csCHPServiceDesk %>" SelectCommand="usp_Lookup" SelectCommandType="StoredProcedure">
    <SelectParameters>
        <asp:Parameter Name="Action" DefaultValue="Select Employee" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>