populate dropdownlist in datagrid

[lleemon]

Really struggline with how to populate a dropdownlist in a datagrid when i click the edit link:

Sub dgrdResults_PageIndexChanged (s as Object, e as DataGridPageChangedEventArgs)
    dgrdResults.CurrentPageIndex = e.NewPageIndex
    BindDataGrid
End Sub
 
Sub dgrdResults_CancelCommand(s as Object, e as DataGridCommandEventArgs)
    dgrdResults.EditItemIndex = -1
    BindDataGrid
End Sub
 
Sub dgrdResults_UpdateCommand(s as Object, e as DataGridCommandEventArgs)
    Dim TempList as DropDownList
    Dim TempValue as String
    
    TempList = e.Item.FindControl("drpUnitRating")
    TempValue = TempList.SelectedItem.Value
    
    dgrdResults.EditItemIndex = -1
    BindDataGrid
End Sub
 
Function BindRating()
    'Dim colArrayList as  New ArrayList
    'colArrayList.Add("5")
    'colArrayList.Add("4")
    'colArrayList.Add("3")
    'colArrayList.Add("2")
    'colArrayList.Add("1")
    'drpUnitRating.DataSource = colArrayList
    'drpUnitRating.DataBind()
End Function
 
Sub dgrdResults_EditCommand(s as Object, e as DataGridCommandEventArgs)
    dgrdResults.EditItemIndex = e.Item.ItemIndex
    BindDataGrid
End Sub
 
......
 
<asp:DataGrid 
                ID="dgrdResults" 
                AllowPaging="true"
                AutoGenerateColumns="false"
                PagerStyle-Mode="NumericPages" PagerStyle-PageButtonCount="5" PagerStyle-Position="Bottom"
                PageSize="25" 
                OnPageIndexChanged="dgrdResults_PageIndexChanged"
                OnEditCommand="dgrdResults_EditCommand"
                OnUpdateCommand="dgrdResults_UpdateCommand"
                OnCancelCommand="dgrdResults_CancelCommand"
                CellPadding="0"
                BorderWidth="0" 
                GridLines="None" CssClass="../fmcss.css"
                runat="server" >
                  <columns>
                  <asp:TemplateColumn>
                    <itemTemplate>
                      <%# Container.DataItem("PRD_BRAND") %>&nbsp;<%# Container.DataItem("PRD_MODEL") %>&nbsp;<%# Container.DataItem("PRD_NAME") %>&nbsp;<%# Container.DataItem("PRD_CATEGORY_CD") %>
                    </itemTemplate>
                  </asp:TemplateColumn>
                  <asp:TemplateColumn>
                    <itemTemplate>
                      <%# Container.DataItem("UNIT_RATING") %>
                    </itemTemplate>
                    <edititemtemplate>
                        <asp:DropDownList ID="drpUnitRating" DataTextField='<%# Container.DataItem("UNIT_RATING") %>' DataValueField='<%# Container.DataItem("UNIT_RATING") %>' DataSource='<%# BindRating %>' runat="server"></asp:DropDownList>
                    </edititemtemplate>
                  </asp:TemplateColumn>
                  <asp:EditCommandColumn EditText="E" UpdateText="U" CancelText="C" />
                  </columns>
                </asp:DataGrid>

I can do it either by connecting to a database or by just typing in say 5 values 1-5. I will be doing it both ways once I figure out how to do this. Right now I am just trying to just do it without the connecting to a database.

Thanks in advance to any replies.

[Kevin_S]

try this link:

http://aspnet.4guysfromrolla.com/articles/051904-1.aspx

hth,
Kev

[lleemon]

Kevin,

Nice link.

Anyone know how to translate this to vb.net?

private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
   // see if we are working with the row being edited
   if (e.Item.ItemType == ListItemType.EditItem)
   {
      // populate the division DDL
      DropDownList ddlDivision = (DropDownList) e.Item.FindControl("ddlDivision");
      
      // connect to Access DB
      OleDbConnection myConnection = new OleDbConnection(ConfigurationSettings.AppSettings["connString"]);
      myConnection.Open();
 
      const string SQL = @"SELECT DivisionID, Name FROM Divisions ORDER BY Name";
      OleDbCommand myCommand = new OleDbCommand(SQL, myConnection);
 
      ddlDivision.DataSource = myCommand.ExecuteReader();
      ddlDivision.DataBind();
 
      myConnection.Close();
 
      // now, select the appropriate division
      int currentDivisionID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "DivisionID"));
      ListItem li = ddlDivision.Items.FindByValue(currentDivisionID.ToString());
      if (li != null) li.Selected = true;
 
      // finally, populate the department DDL based on the selected division
      int currentDepartmentID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "DepartmentID"));
      if (li != null) li.Selected = true;
 
      DropDownList ddlDepartment = (DropDownList) e.Item.FindControl("ddlDepartment");
 
      PopulateDepartmentBasedOnDivision(ddlDepartment, ddlDivision, currentDepartmentID);
   }
}