This article discusses how to bind a dropdown control in EditItemTemplate with custom values and update the ItemTemplate field after editing. The functionality can be used in cases in which the developer may want to provide different list of choices than the ones present by default in GridDropDownColumn.
You should locate the dropdown control in the ItemDataBound handler of the grid for each item which is in edit mode and bind it to the data source of your choice. Furthermore, when update is performed you can save the selected by the user value in Session variable and then set that value for the template column cell in regular mode. The same Session variable can be used to select the default item in the dropdown control on subsequent editing.
In the code below we assign array of ListItem objects as data source for the dropdown editor. To visualize clearly the functionality depicted above we generate only one grid item. For more complex scenarios you should adjust the provided logic to suit your case.
|
[ASPX/ASCX]
<radg:radgrid id="RadGrid1" runat="server" AutoGenerateColumns="False"> <MasterTableView> <Columns> <radg:GridBoundColumn UniqueName="ContactName" ReadOnly="True" HeaderText="ContactName" DataField= "ContactName" /> <radg:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Country"> <ItemTemplate> <asp:Label id="Label1" runat="server"> <%# DataBinder.Eval(Container.DataItem, "Country") %> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="List1" runat="server" /> </EditItemTemplate> </radg:GridTemplateColumn> <radg:GridEditCommandColumn UniqueName="EditCommandColumn" /> </Columns> </MasterTableView> </radg:radgrid>
|
And in the code-behind:
|
[C#]
object[] Country_values = {new ListItem("Germany", "German"), new ListItem("England", "English"), new ListItem("Spain", "Spanish"), new ListItem("United States", "American")};
private void Page_Load(object sender, System.EventArgs e) { }
private void RadGrid1_NeedDataSource(object source, Telerik.WebControls.GridNeedDataSourceEventArgs e) { OleDbConnection MyOleDbConnection = new OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/Grid/Data/Access/Nwind.mdb"))); OleDbDataAdapter MyOleDbDataAdapter = new OleDbDataAdapter(); MyOleDbDataAdapter.SelectCommand = new OleDbCommand("SELECT TOP 1 ContactName, Country FROM Customers", MyOleDbConnection); DataTable myDataTable = new DataTable(); MyOleDbConnection. Open(); try { MyOleDbDataAdapter.Fill(myDataTable); } finally { MyOleDbConnection. Close(); } RadGrid1.DataSource = myDataTable.DefaultView; }
private void RadGrid1_ItemDataBound(object sender, Telerik.WebControls.GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem item = e.Item as GridEditableItem; // access/modify the edit item template settings here DropDownList list = item.FindControl("List1") as DropDownList; list.DataSource = Country_values; list.DataBind();
if (Session["updatedValue"] != null) { list.SelectedValue = Session["updatedValue"]; } } else if (e.Item is GridDataItem && !e.Item.IsInEditMode && Page.IsPostBack) { GridDataItem item = e.Item as GridDataItem; Label label = item.FindControl("Label1") as Label; // update the label value label.Text = Session["updatedValue"]; } }
private void RadGrid1_UpdateCommand(object source, Telerik.WebControls.GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; DropDownList list = editedItem.FindControl("List1") as DropDownList; Session[ "updatedValue"] = list.SelectedValue; }
|
|
[VB.NET]
Protected Country_values As Object() = {New ListItem("Germany", "German"), New ListItem("England", "English"), New ListItem("Spain", "Spanish"), New ListItem("United States", "American")}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub RadGrid1_NeedDataSource(ByVal source As System.Object, ByVal e As Telerik.WebControls.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource Dim MyOleDbConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/Grid/Data/Access/Nwind.mdb")) Dim MyOleDbDataAdapter As New OleDbDataAdapter MyOleDbDataAdapter.SelectCommand = New OleDbCommand("SELECT TOP 1 ContactName,Country FROM Customers", MyOleDbConnection)
Dim myDataTable As New DataTable
MyOleDbConnection. Open() Try MyOleDbDataAdapter.Fill(myDataTable) Finally MyOleDbConnection. Close() End Try
RadGrid1.DataSource = myDataTable.DefaultView
End Sub
Private Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.WebControls.GridItemEventArgs) Handles RadGrid1.ItemDataBound If (TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode) Then Dim item As GridEditableItem = e.Item
Dim list As DropDownList = item.FindControl("List1") list.DataSource = Country_values list.DataBind() If (Not Session("updatedValue") Is Nothing) Then list.SelectedValue = Session("updatedValue") End If
ElseIf (TypeOf e.Item Is GridDataItem AndAlso Not e.Item.IsInEditMode AndAlso Page.IsPostBack) Then Dim item As GridDataItem = e.Item Dim label As Label = item.FindControl("Label1")
label.Text = Session("updatedValue") End If
End Sub
Private Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As Telerik.WebControls.GridCommandEventArgs) Handles RadGrid1.UpdateCommand Dim editedItem As GridEditableItem = e.Item Dim list As DropDownList = editedItem.FindControl("List1") Session( "updatedValue") = list.SelectedValue End Sub
|