[Solved] How to update a record from RadGrid's GridTemplateColumn that includes a DropDownList

[Kem Arda]

I retrieve data and bind it to my RadGrid. Rather then showing foreign key values (such as 1, 2, 3 etc.), i wantto show the names of data on my RadGrid. Thus i add  a DropDownList in my RadGrid's GridTemplateColumn as follows. While selecting and showing the names(name field) of   foreign key values ( 1, 2, 3 etc.), there is no problem. But when i update it there is no change.

<

telerik:GridTemplateColumn HeaderText = "Donem" DataField="DonemId" UniqueName = "DonemId" DataType="System.Int16" SortExpression = "DonemId" >

 

 

<ItemTemplate>

 

 

<asp:DropDownList ID="ddlDonem" runat="server" DataSourceID = "LLBLGenProDataSource22Donem" DataTextField = "DonemAdi" DataValueField = "DonemId" SelectedValue='<%# Bind("DonemId") %>' >

 

 

</asp:DropDownList>

 

 

</ItemTemplate>

 

 

</telerik:GridTemplateColumn>

Here is the full code:

 

<%

@ Control Language="C#" Inherits="Toys.Modules.Tahakkuk.ViewToysTahakkuk"

 

 

 

 

AutoEventWireup="true" CodeBehind="ViewToysTahakkuk.ascx.cs" %>

 

<%

@ Register assembly="Telerik.Web.UI, Version=2009.1.527.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" namespace="Telerik.Web.UI" tagprefix="telerik" %>

 

<%

@ Register assembly="SD.LLBLGen.Pro.ORMSupportClasses.NET20" namespace="SD.LLBLGen.Pro.ORMSupportClasses" tagprefix="llblgenpro" %>

 

 

 

 

<

telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

 

<

AjaxSettings>

 

<

telerik:AjaxSetting AjaxControlID ="RadGridHizmetler" >

 

<

UpdatedControls>

 

<

telerik:AjaxUpdatedControl ControlID ="RadGridHizmetler"/>

 

</

UpdatedControls>

 

</

telerik:AjaxSetting>

 

</

AjaxSettings>

 

</

telerik:RadAjaxManager>

 

<

telerik:RadGrid ID="RadGridHizmetler" runat="server"

 

 

AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes = "true"

 

 

 

 

AllowFilteringByColumn="True" AllowMultiRowSelection="True" AllowPaging="True"

 

 

AllowSorting="True" AutoGenerateColumns="False"

 

 

DataSourceID="LLBLGenProDataSource21" GridLines="None"

 

 

onitemupdated="RadGridHizmetler_ItemUpdated"

 

 

onneeddatasource="RadGridHizmetler_NeedDataSource"

 

 

onupdatecommand="RadGridHizmetler_UpdateCommand" ShowFooter="True"

 

 

ShowGroupPanel="True" ShowStatusBar="True"

 

 

ondeletecommand="RadGridHizmetler_DeleteCommand" >

 

<

MasterTableView datasourceid="LLBLGenProDataSource21" CommandItemDisplay = "Top"

 

 

 

DataKeyNames

="HizmetId" EditMode ="InPlace" RetrieveDataTypeFromFirstItem = "true" >

 

<

RowIndicatorColumn>

 

<

HeaderStyle Width="20px"></HeaderStyle>

 

</

RowIndicatorColumn>

 

<

ExpandCollapseColumn>

 

<

HeaderStyle Width="20px"></HeaderStyle>

 

</

ExpandCollapseColumn>

 

<

Columns>

 

<

telerik:GridEditCommandColumn UniqueName="EditCommandColumn">

 

 

 

 

</telerik:GridEditCommandColumn>

 

 

 

<telerik:GridBoundColumn DataField="HizmetId" DataType="System.Int16"

 

 

HeaderText="HizmetId" SortExpression="HizmetId" UniqueName="HizmetId">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="KisaKodu"

 

 

HeaderText="KisaKodu" SortExpression="KisaKodu" UniqueName="KisaKodu">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="HizmetAdi"

 

 

HeaderText="HizmetAdi" SortExpression="HizmetAdi" UniqueName="HizmetAdi">

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

<telerik:GridTemplateColumn HeaderText = "Donem" DataField="DonemId" UniqueName = "DonemId" DataType="System.Int16" SortExpression = "DonemId" >

 

 

 

 

<ItemTemplate>

 

 

<asp:DropDownList ID="ddlDonem" runat="server" DataSourceID = "LLBLGenProDataSource22Donem" DataTextField = "DonemAdi" DataValueField = "DonemId" SelectedValue='<%# Bind("DonemId") %>' >

 

 

 

 

</asp:DropDownList>

 

 

 

 

</ItemTemplate>

 

 

 

 

</telerik:GridTemplateColumn>

 

 

 

 

 

<telerik:GridBoundColumn DataField="Tutar" DataType="System.Decimal"

 

 

HeaderText="Tutar" SortExpression="Tutar" UniqueName="Tutar">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="TutarDegisiklikEh" DataType="System.Boolean"

 

 

HeaderText="TutarDegisiklikEh" SortExpression="TutarDegisiklikEh"

 

 

 

UniqueName

="TutarDegisiklikEh">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="Adet" DataType="System.Int32"

 

 

HeaderText="Adet" SortExpression="Adet" UniqueName="Adet">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AdetDegisiklikEh" DataType="System.Boolean"

 

 

HeaderText="AdetDegisiklikEh" SortExpression="AdetDegisiklikEh"

 

 

 

UniqueName

="AdetDegisiklikEh">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="GecikmeFaiziEh" DataType="System.Boolean"

 

 

HeaderText="GecikmeFaiziEh" SortExpression="GecikmeFaiziEh" UniqueName="GecikmeFaiziEh">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="GecikmeZammiEh" DataType="System.Boolean"

 

 

HeaderText="GecikmeZammiEh" SortExpression="GecikmeZammiEh" UniqueName="GecikmeZammiEh">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="HesapId" DataType="System.Int16"

 

 

HeaderText="HesapId" SortExpression="HesapId" UniqueName="HesapId">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="HizmetTipi" DataType="System.Int16"

 

 

HeaderText="HizmetTipi" SortExpression="HizmetTipi" UniqueName="HizmetTipi">

 

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="AidatTipi" DataType="System.Int16"

 

 

HeaderText="AidatTipi" SortExpression="AidatTipi" UniqueName="AidatTipi">

 

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridButtonColumn UniqueName="DeleteColumn" Text="Delete" CommandName="Delete" />

 

 

 

 

 

 

</

Columns>

 

<

EditFormSettings>

 

<

EditColumn UniqueName = "EditCommandColumnH">

 

</

EditColumn>

 

</

EditFormSettings>

 

</

MasterTableView>

 

 

 

 

<ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True"

 

 

AllowRowsDragDrop="True">

 

 

 

 

<Selecting AllowRowSelect ="true" EnableDragToSelectRows ="true"/>

 

 

 

 

</ClientSettings>

 

</

telerik:RadGrid>

 

<

llblgenpro:LLBLGenProDataSource2 ID="LLBLGenProDataSource21" runat="server"

 

 

AdapterTypeName="Toys.Data.Mali.DatabaseSpecific.DataAccessAdapter, Toys.Data.MaliDBSpecific"

 

 

AllowDuplicates="False" DataContainerType="EntityCollection"

 

 

EnablePaging="True"

 

 

 

EntityFactoryTypeName="Toys.Data.Mali.FactoryClasses.HizmetEntityFactory, Toys.Data.Mali"

 

 

onperformgetdbcount="LLBLGenProDataSource21_PerformGetDbCount1"

 

 

onperformselect="LLBLGenProDataSource21_PerformSelect"

 

 

onperformwork="LLBLGenProDataSource21_PerformWork" >

 

 

 

 

 

 

 

</

llblgenpro:LLBLGenProDataSource2>

 

 

 

 

 

<

llblgenpro:LLBLGenProDataSource2 ID="LLBLGenProDataSource22Donem"

 

 

runat="server" AllowDuplicates="False"

 

 

 

 

AdapterTypeName="Toys.Data.Mali.DatabaseSpecific.DataAccessAdapter, Toys.Data.MaliDBSpecific"

 

 

DataContainerType="EntityCollection"

 

 

EntityFactoryTypeName="Toys.Data.Mali.FactoryClasses.DonemEntityFactory, Toys.Data.Mali">

 

</

llblgenpro:LLBLGenProDataSource2>

 

 

 

Thanks in advance...

[Rosen]

Hello Kem,

You should use GridTemplateColumn's EditItemTemplate instead of ItemTemplate in order to take advantage of automatic value extraction.

Also if I may ask is there any particular reason for not using the build-in GridDropDown column?

Regards,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.