set dropdownlist selectedindex in datagrid

[pleaseexplaintome]

Hi all,

I have a datagrid with a dropdownlist and would like to have the
dropdownlist display a database value correctly while the grid is in
edit mode.

I have a templatecolumn as follows:

<asp:TemplateCo lumn HeaderText="New Route">
<HeaderStyle Width="0.5in"></HeaderStyle>
<ItemTemplate >
<asp:DropDownLi st id="DropDownLis t3" runat="server"
AutoPostBack="T rue" OnSelectedIndex Changed="ddlsel ect">
<asp:ListItem Value="A">A</asp:ListItem>
<asp:ListItem Value="B">B</asp:ListItem>
<asp:ListItem Value="C">C</asp:ListItem>
<asp:ListItem Value="D">D</asp:ListItem>
</asp:DropDownLis t>
</ItemTemplate>

with an edit column as:
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate"
HeaderText="Edi t" CancelText="Can cel" EditText="Edit" ></
asp:EditCommand Column>

I would like to set the dropdownlist to the value found in the
database. my code behind uses ItemDataBound as follows:

public void myDataGrid_Item DataBound(objec t sender,
System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
DropDownList dd;
if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
dd = (DropDownList)e .Item.Cells[7].FindControl("D ropDownList3");
dd.SelectedInde x =
dd.Items.IndexO f(dd.Items.Find ByText(e.Item.C ells[3].Text));
}
}

upon loading the dropdownlist has the values as in the database.
However, when I press edit the selected index becomes 0. I cannot
figure how to set the value correctly.

my edit code looks like:
public void myDataGrid_Edit Command(object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
DropDownList dd;
dd = (DropDownList)e .Item.Cells[7].FindControl("D ropDownList3");
dd.SelectedInde x =
dd.Items.IndexO f(dd.Items.Find ByText(e.Item.C ells[3].Text));
<--- dd.SelectedInde x looks fine here --->
....
}

dd.SelectedInde x looks ok in debug mode, but something changes it
before the dropdownlist is displayed. the values in the dropdownlists
not being edited are ok, it's only the one being edited that shows the
wrong selectedindex.

any help would be appreciated. thanks.

[Riki]

pl************* **@yahoo.com wrote:

Hi all,

I have a datagrid with a dropdownlist and would like to have the
dropdownlist display a database value correctly while the grid is in
edit mode.

I have a templatecolumn as follows:

<asp:TemplateCo lumn HeaderText="New Route">
<HeaderStyle Width="0.5in"></HeaderStyle>
<ItemTemplate >
<asp:DropDownLi st id="DropDownLis t3" runat="server"
AutoPostBack="T rue" OnSelectedIndex Changed="ddlsel ect">
<asp:ListItem Value="A">A</asp:ListItem>
<asp:ListItem Value="B">B</asp:ListItem>
<asp:ListItem Value="C">C</asp:ListItem>
<asp:ListItem Value="D">D</asp:ListItem>
</asp:DropDownLis t>
</ItemTemplate>

There is a much easier way (at least in ASP.NET 2.0)

Set the property SelectedValue on the DrowDownlist
declaratively like this:

SelectedValue=' <%# Bind("myDBField ") %>'

This will take care of everything: showing the data and
updating the data after postback.

--

Riki