Binding MS Access data to DropDownList
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
objDataReader2 = objCommand2.ExecuteReader(CommandBehavior.CloseCon nection)
DropDownList5.DataSource = objDataReader2
DropDownList5.DataTextField = "orgname"
DropDownList5.DataValueField = "orgname"
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?