«

What I want to do is to populate multiple dropdowns when editing.
Presumably...
a) I should use a DataReader so that I can get each ResultSet for each
dropdown control, and that should cut down round trips to the server.
b) I should populate these dropdowns in the DataGrid_EditCommand?
What I am having problems with is actually referencing the dropdowns on the
template.
e.g. I have a dropdown called drpAccessLevels, but I cannot find this
anywhere.
Where am I going wrong?

Many thanks in advance.
Andy

> a) I should use a DataReader so that I can get each ResultSet for each
> dropdown control, and that should cut down round trips to the server.

Only as long as you're building a batch SQL statement (like "select * from
foo; select * from bar") and not calling ExecuteReader twice. Each ExecuteReader
makes a trip to the DB.

> b) I should populate these dropdowns in the DataGrid_EditCommand?
> What I am having problems with is actually referencing the dropdowns
> on the
> template.
> e.g. I have a dropdown called drpAccessLevels, but I cannot find this
> anywhere.

Typically you'd do any additional modifications of the row in ItemDataBound
event off the grid. So then when the DataGridItemEventArgs.Item.ItemType
== ListItemType.EditItem then you know you're working with the editable row.

-Brock
DevelopMentor
http://staff.develop.com/ballen