Edit with templates in datagrid

[svatasoiu]

Hi,

I have a page with a datagrid, and inside the data grid I want to edit with templates some columns.
In the templates I use dropdownlist to let the user to select the new value.
My questuion is where and how to set the initial selected value of the dropdownlist so it will match the value that exist for that cell.
I tried with this code, where I can get existing value in lblActive, but I don't have the Edit field (dropdownlist) available to set the initial selected field.
Which will be the proper event to do this?

Sub DataGrid1_EditCommand(ByVal s As Object, ByVal e As DataGridCommandEventArgs)
Dim lblActive As Label
lblActive = e.Item.FindControl("lblActive")


DataGrid1.EditItemIndex = e.Item.ItemIndex
BindDataGrid()

Dim oneItem As ListItem
Dim ddlActive As DropDownList
ddlActive = e.Item.FindControl("DropDownListActive")
For Each oneItem In ddlActive.Items
If oneItem.Value.ToLower = lblActive.Text.ToLower Then
oneItem.Selected = True
End If
Next

End Sub

Thank you,

svatasoiu

[fungi]

I handle this type of situation with late-binding.

<EditItemTemplate>
    <asp:DropDownList runat="server" SelectedIndex='<%# GetIndex(Container.DataItem("<field>")) %>' id="ddlStates">
    </asp:DropDownList>
</EditItemTemplate>

[svatasoiu]

fungi,

Thank you for your answer.
when I tried in the way you propesed, I get an error related to GetIndex
=========================================
<EditItemTemplate>
<aspropDownList id="DropDownListActive" runat="server" SelectedIndex='<%# GetIndex(Container.DataItem("Active")) %>'>
<asp:ListItem Value="False">False</asp:ListItem>
<asp:ListItem Value="True">True</asp:ListItem>
</aspropDownList>
</EditItemTemplate>
I get this error:
Compiler Error Message: BC30451: Name 'GetIndex' is not declared.
=======================================
When I tried the basic:
<EditItemTemplate>
<aspropDownList id="DropDownListActive" runat="server" SelectedIndex='1'>
<asp:ListItem Value="False">False</asp:ListItem>
<asp:ListItem Value="True">True</asp:ListItem>
</aspropDownList>
</EditItemTemplate>
I get this error:
Parser Error Message: The 'SelectedIndex' property is set only by the runtime. It cannot be declared.
========================================
If the example you send does work, I'm sure I'm missing something. Any ideea?

Thank you,

svatasoiu

[svatasoiu]

fungi,

Is GetIndex a custom function used to retrieve the index, or it is a method of some .net object (I can not found which)

Thank you,
svatasoiu

[fungi]

Sorry for not being more specific svata.

My list items are loaded from a SortedList and "GetIndex" is a function that returns the IndexOfKey for the row value.

[svatasoiu]

fungi,

now make sense.
I tried to implement this, but I'm stuck when I try to load the dropdownlist from the sortedlist.
I try to do this into the aspx page with inline script code but this is not allowed.
Can you tell be where you define the sortedList (I tried in a separate class) and how & where do you load the sorted class into the dropdownlist from the template.

thank you,

svatasoiu

[fungi]

Give me a day or so to find that code and I'll post it...

[fungi]

Here's that code. My dropdown is for a list of state codes.

Declare the list and the function in the WebForm

Public slStates As SortedList
 
Public Function GetIndex(ByVal s As String) As Long
    Return (slStates.IndexOfKey(s))
End Function

Load up the list in the Page_Load:

slStates = New SortedList()
slStates.Add("AL", 0)
slStates.Add("AK", 1)
slStates.Add("AR", 2)
slStates.Add("AZ", 3)
slStates.Add("CA", 4)
...

Load up the dropdown inline in the asp:

<asp:TemplateColumn HeaderText="State">
  <ItemTemplate>
    <asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "state") %>' ID="lblState" NAME="lblState"/>
  </ItemTemplate>
  <EditItemTemplate>
    <asp:DropDownList runat="server" SelectedIndex='<%# GetIndex(Container.DataItem("state")) %>' id="edit_State">
      <asp:ListItem>AL</asp:ListItem>
      <asp:ListItem>AK</asp:ListItem>
      <asp:ListItem>AR</asp:ListItem>
      <asp:ListItem>AZ</asp:ListItem>
      <asp:ListItem>CA</asp:ListItem>
    </asp:DropDownList>
  </EditItemTemplate>
</asp:TemplateColumn>

Not the best solution but it served my needs at the time...
Good luck!

[svatasoiu]

fungi,

Thank you very much for this answer.
I was thinking to almost the same solution, but I belived it may be a solution to feed the dropdownbox from the same SortedList.
If you can do that, then any change require only one place to be done.

Thank you,

Svatasoiu

[svatasoiu]

Fungi,

This is the code I finally implemented: it is a combination of your ex + a datatable that allow me to build the dropdown list from the same sorted list. In this way I have only one place where I describe the values from the dropdown list

Thank you,

svatasoiu

<EditItemTemplate>
<aspropDownList id="ddlExpMonth" runat="server" DataSource='<%# GetDDL_Month()%>' DataTextField="Month" DataValueField ="MonthValue" SelectedIndex='<%# GetIndexMonth(left(Container.DataItem("CCExp"),2)) %>'>
</aspropDownList>
</EditItemTemplate>


Public Function GetDDL_Month() As DataTable
Dim dt As New DataTable()
Dim dr As DataRow
dt.Columns.Add("Month", GetType(String))
dt.Columns.Add("MonthValue", GetType(String))
Dim i As Integer
For i = 0 To slMonth.Count - 1
dr = dt.NewRow
dr("Month") = slMonth.GetKey(i)
dr("MonthValue") = slMonth.GetKey(i)
dt.Rows.Add(dr)
Next
Return dt
End Function