This is a migrated thread and some comments may be shown as answers.

Problem updating Itemtemplate Colum with RAD Drodownlist

1 Answer 37 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Alberto
Top achievements
Rank 1
Alberto asked on 25 Nov 2013, 11:06 PM
Hello, im using a RAD Grid - Batch Edit Mode, all fields are updating OK, also delete and insert operations, but the only column that isnt working or updating is a ItemTemplateColumn with a RAD Dropdownlist,  the information its saved on the database, but when refresing or retrieving rows the dropdown doesnt select any value. Below its my code


                    SelectCommand="SELECT [SHOP NUMBER] AS SHOP_NUMBER, NUMBER, [MANF# NUMBER] AS column1, DESCRIPTION, [QTY REQD] AS QTY_REQD, BILLBACK, [PULLED KSS] AS PULLED_KSS, [PULLED K-MLC] AS column2, [DATE ENTERED] AS DATE_ENTERED, [DATE PULLED] AS DATE_PULLED, MARKCHECK, ID, [LABOR?] AS column3 FROM USAGE WHERE ([SHOP NUMBER] = @SHOP_NUMBER) ORDER BY NUMBER"
...
UpdateCommand="UPDATE [USAGE] SET [NUMBER] = UPPER(@NUMBER), [MANF# NUMBER] = @column1, [QTY REQD] = @QTY_REQD, [BILLBACK] = @BILLBACK, [PULLED KSS] = @PULLED_KSS, [PULLED K-MLC] = @column2, [DATE ENTERED] = @DATE_ENTERED, [DATE PULLED] = @DATE_PULLED,  [LABOR?] = @column3 WHERE [ID] = @original_ID AND [SHOP NUMBER] = @original_SHOP_NUMBER">
...

                    <UpdateParameters>
                        <asp:Parameter Name="SHOP_NUMBER" Type="Double" />
                        <asp:Parameter Name="NUMBER" Type="String" />
                        <asp:Parameter Name="column1" Type="String" />
  ....

<asp:SqlDataSource ID="sdsPartlist" runat="server"
                    ConnectionString="<%$ ConnectionStrings:DRJConnectionString %>"
                    SelectCommand="SELECT DISTINCT [MANF# NUMBER] AS column1, [DESCRIPTION] FROM [PARTLIST] ORDER BY [DESCRIPTION]"></asp:SqlDataSource>
....

<telerik:GridTemplateColumn HeaderText="Mnf. #" DataType="System.String" HeaderStyle-Width="180px" UniqueName="column1" DataField="column1">
                            <ItemTemplate>
                                <%# Eval("DESCRIPTION")%>
                            </ItemTemplate>
                            <EditItemTemplate>
                                <telerik:RadDropDownList runat="server" ID="column1box" DataValueField="column1"
                                    DataTextField="DESCRIPTION" DataSourceID="sdsPartlist" >
                                </telerik:RadDropDownList>
                            </EditItemTemplate>
                                <HeaderStyle Width="180px" />
                        </telerik:GridTemplateColumn>

Thanks for your help

1 Answer, 1 is accepted

Sort by
0
Alberto
Top achievements
Rank 1
answered on 26 Nov 2013, 02:06 AM
Already fixed this issues, thank you anyway.

Regards,
Alberto
Tags
Grid
Asked by
Alberto
Top achievements
Rank 1
Answers by
Alberto
Top achievements
Rank 1
Share this question
or