Grid inplace editing populate dropdowns with db class

[Timothy Stanton]

Hello!   could you please direct me to a great example of how (on editing a row) to hook up a drop down on the row to a database class.  It can't be a static list on the page.  So far, I've not been able to find an example or figure this out on my own!

thanks in advance! Tim

[Princy]

Hello Tim,

Try the following code snippet.
C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
 if (e.Item is GridEditableItem && e.Item.IsInEditMode)
 {
     GridEditableItem item = (GridEditableItem)e.Item;
     DropDownList ddl = (DropDownList)item.FindControl("ddl");
     ddl.DataValueField = "EmployeeID";
     ddl.DataValueField = "EmployeeID";
     ddl.DataSourceID = "SqlDataSource1";
 }
}

-Princy.

[Timothy Stanton]

Princy - thanks.

So you have to populate the dropdown as the grid is bound? (per row?)    I had tried that code in the EditCommand of the grid, but the 'FindControl' returns a null value.

Interesting.  I may have to do this a different way. 

[Princy]

Hello,

You can access controls in ItemDataBound event because controls are only bound during this event.

Thanks,
Princy.