I'm having a problem. I'm getting this error and I don't know how to fix it. It keeps throwing the error where the red is. Can someone help me.

System.IndexOutOfRangeException: Index was outside the bounds of the array.


Private Sub BindState2(ByVal ddl As DropDownList)
        connFTS = New SqlConnection(Application("connFTS"))
        Dim cmdSelect As SqlCommand = New SqlCommand("Select vchCompany from tblFWPurchaseCompany Inner join tblFWBusiness on tblFWPurchaseCompany.vchFWRecid = tblFWBusiness.vchFWRecid where vchcompany <> ''", connFTS)
        Dim dtrState As SqlDataReader

        Try
            connFTS.Open()
            dtrState = cmdSelect.ExecuteReader

            While dtrState.Read
                Dim newListItem As New ListItem
                newListItem.Value = dtrState.GetString(0)
                newListItem.Text = dtrState.GetString(2)
            ddl.Items.Add(newListItem)
            End While

            dtrState.Close()
            connFTS.Close()

        Catch er As Exception
            LogError(er.ToString, "BindState2")
            Exit Try
        Finally
            connFTS.Close()
        End Try
    End Sub

This error: System.IndexOutOfRangeException: Index was outside the bounds of the array

means just what it says: Your index was outside the bounds of the array. I suggest changing newListItem.Text = dtrState.GetString(2) to newListItem.Text = dtrState.GetString(1). (As a side note: I prefer referring to a DataReader's elements by column names as opposed to numerical index's as this can cause you problems if, in the future, you add more columns to your query.)

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

I did have one right there at first but that didn't work. How would you use the columns instead of indexes. could you give me an example?

Something like this: Convert.ToString(dtrState("<columnName">))

Reference Material:
http://www.google.com/search?source=...t+-+datareader

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

thanks