How do I preselect the current database value in a populated datagrid dropdown list when in edit mode.

First off thanks to Rafayali for his code which I am using.  
I have a editable datagrid incorporating a dropdownlist pouplated with data from the database. The function in the attached code sippet is part of the edit template which populates the dropdownlist. (thanks again Rafayali).  The problem is I cannot manage to select the current cell value in the dropdownlist so that the user sees the currently stored database value selected in the dropdownlist.  I have tried many searched solutions but so far not able to find one that works.  Can someone please help me out (VB code would be great as my C insn't great)  Thank you all.

<EditItemTemplate>
<asp:DropDownList
ID="DDLPI"
AutopostBack = "False"
Runat="server"
DataTextField = "NameInitial"
DataValueField = "ID"
Datasource='<%# BindDDL2()%>'/>
</asp:DropdownList>
</EditItemTemplate>
</asp:TemplateColumn>

Open in new window

dolbsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
samtran0331Connect With a Mentor Commented:
Your main datasource has the proper value for each row for this field correct?
So for instance, if this DDL is supposed to get the value from a field named "PI_ID" from the datagrid's datasource, try:


<EditItemTemplate>
<asp:DropDownList
ID="DDLPI"
AutopostBack = "False"
Runat="server"
DataTextField = "NameInitial"
DataValueField = "ID"
Datasource='<%# BindDDL2()%>'
SelectedValue='<%# DataBinder.Eval(Container.DataItem,"PI_ID")%>' />
</asp:DropdownList>
</EditItemTemplate>
</asp:TemplateColumn>

Open in new window

0
 
dolbsAuthor Commented:
Thanks.  Easy answer that I should have thought of myself.  Great service and reply.
0
All Courses

From novice to tech pro — start learning today.