Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 25th, 2005, 06:49 AM
Authorized User
 
Join Date: Jul 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Binding MS Access data to DropDownList

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
 
Old April 25th, 2005, 06:02 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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

Wind is your friend
Matt





Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access: Data Access Page sevp95 Access VBA 0 July 14th, 2008 11:07 AM
MS Data Grid control in ms access application roshla_p Access VBA 5 October 16th, 2006 02:37 AM
Please Help! Ms Access Data Access Pages Iashia06 Access 0 May 4th, 2006 03:29 PM
Exporting data from MS Excel sheet to Ms Access ajindal General .NET 1 January 17th, 2005 03:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.