for (int i = 0; i < myArr.Count; i++)
ddl_main.Items.Add(myArr[i]);
Большое спасибо за помощь, но мне нужно исп-ть метод addrange
Вот че я сама наваяла:
Public Shared Function ObjectToListItem(ByVal pf As System.Object) As ListItem
Return New ListItem(pf.ToString)
End Function
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
Dim strMyConn As SqlConnection = New SqlConnection(strMyConnString)
Dim myCmd As SqlCommand = New SqlCommand(strMyQuery, strMyConn)
strMyConn.open()
Dim dReader As SqlDataReader = myCmd.ExecuteReader()
Dim myArr As ArrayList = New ArrayList()
Do While dReader.Read()
myArr.Add(New ListItem(dReader.GetString(0)))
Loop
ddl_main.Items.AddRange(Array.ConvertAll(myArr.ToArray, New Converter(Of System.Object, ListItem)(AddressOf ObjectToListItem)))