SetIndex and dropdownlist errors

[naija naija]

Hi Guys,
I have my .aspx below and i'm using SetIndex with selectedIndex
with DropDownList to retrieve Data from my database!!
My function of SetIndex is as follows:-
Function SetIndex(ByVal TheItem As String)

Dim ItemTypes As ArrayList
Dim i As Integer
For i = 0 To ItemTypes.Count - 1
If TheItem = ItemTypes(i) Then
Return i
End If
Next
End Function

When i compile it using VS.NET it comoiles but when i run it i get error
"Name 'ItemTypes' is not declared"
Do i have to still delcare ItemTypes some how..
Pls help!!

My Asp.Net
------------
<asp:TemplateColumn>
<HeaderTemplate>
Type<br>
<aspropDownList id="ItemType" runat="server"
DataSource='<%# ItemTypes %>'/>
</HeaderTemplate>
<ItemTemplate>
<aspropDownList id="Dropdownlist1" runat="server"
DataSource='<%# ItemTypes %>'
SelectedIndex='<%# SetIndex(Container.DataItem("ItemType"))
%>'/>
</ItemTemplate>
</asp:TemplateColumn>

 

[Greg Burns]

How bout using code akin to this...

Dim TheItem As String="Some Value"

' select that value in drop downlist
Dim MyListItem As ListItem = ddl.Items.FindByValue(TheItem)
ddl.SelectedIndex = ddl.Items.IndexOf(MyListItem)

HTH,
Greg

 

[Guest]

Thanks for the reply Greg but have:-
ItemTypes = New ArrayList
DBConnection = New SqlConnection("")
DBConnection.Open()
SQLString = "SELECT DISTINCT ItemType FROM products1 ORDER BY
ItemType"
DBCommand = New SqlCommand(SQLString, DBConnection)
DBReader = DBCommand.ExecuteReader()
While DBReader.Read()
ItemTypes.Add(DBReader("ItemType"))
End While
DBReader.Close()
DBConnection.Close()

I'm using VS.Net do i have to declare something using Protected WithEvents ?
Now i get the error:-"System.NullReferenceException: Object reference not
set to an instance of an object."
Saying there is na error on the line:- "For i = 0 To ItemTypes.Count - 1"
Any advice?