Hi

I bound data from a database using the format:

    Dim strSQL2 as string = "select * from org order by orgname"

    Dim objCommand2 as New OdbcCommand(strSQL2, myConnection2)
    Dim objDataReader2 as OdbcDataReader

        myConnection2.Open()

    objDataReader2 = objCommand2.ExecuteReader(CommandBehavior.CloseCon nection)

        DropDownList5.DataSource = objDataReader2
        DropDownList5.DataTextField = "orgname"
    DropDownList5.DataValueField = "orgname"

        DropDownList5.DataBind()

This works fine if I select < 30 record but anything above and the page OnClick event I have stops working.

Basically I have a form and the dropdownlist provides a list of companies held in a MS Access database. There about 800 companies but I cannot get the DropDownList to handle anything >= 30. Is there a configurable limit? Is there an alternative method to cope with larger results set?

Thanks

You are using .net? Try the .net area of this forum, this is the classic ASP area.

Wind is your friend
Matt