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
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