dropdownlist size limit?

Hi

I'm using a DataReader to pull items into a DropDownList from an SQL
database. Everything works fine, but my client has started to nice that newly
added database entries aren't appearing in the DDL.

I've tested locally with exactly the same new record and it shows up fine in
the DDL, so I'm wondering if perhaps the DataReader or DropDownList has some
sort of maximum record/listcount limit?

The client db has about 400 entries going into the DDL. Is this something
like a limit, or is there something else it might be?!

Cheers



Dan

re: dropdownlist size limit?

No, there is not a limit.

Andi f there was, you would of course be able to reproduce it locally. Since
it all works fine in your testing environment, the issue must be elsewhere.

"dhnriverside" <dan@musoswire.com> wrote in message
news:0DFB3ED5-A0FD-4810-908D-AE85B7275708@microsoft.com...[color=blue]
> Hi
>
> I'm using a DataReader to pull items into a DropDownList from an SQL
> database. Everything works fine, but my client has started to nice that
> newly
> added database entries aren't appearing in the DDL.
>
> I've tested locally with exactly the same new record and it shows up fine
> in
> the DDL, so I'm wondering if perhaps the DataReader or DropDownList has
> some
> sort of maximum record/listcount limit?
>
> The client db has about 400 entries going into the DDL. Is this something
> like a limit, or is there something else it might be?!
>
> Cheers
>
>
>
> Dan[/color]

re: dropdownlist size limit?

Not necessarily.... the live db has a lot more records than the dev version
I'm trying to reproduce it on... hence the thought about limits.

Thanks for dispelling that idea though... I shall continue to investigate!


Dan

"Marina" wrote:
[color=blue]
> No, there is not a limit.
>
> Andi f there was, you would of course be able to reproduce it locally. Since
> it all works fine in your testing environment, the issue must be elsewhere.
>
> "dhnriverside" <dan@musoswire.com> wrote in message
> news:0DFB3ED5-A0FD-4810-908D-AE85B7275708@microsoft.com...[color=green]
> > Hi
> >
> > I'm using a DataReader to pull items into a DropDownList from an SQL
> > database. Everything works fine, but my client has started to nice that
> > newly
> > added database entries aren't appearing in the DDL.
> >
> > I've tested locally with exactly the same new record and it shows up fine
> > in
> > the DDL, so I'm wondering if perhaps the DataReader or DropDownList has
> > some
> > sort of maximum record/listcount limit?
> >
> > The client db has about 400 entries going into the DDL. Is this something
> > like a limit, or is there something else it might be?!
> >
> > Cheers
> >
> >
> >
> > Dan[/color]
>
>
>[/color]

re: dropdownlist size limit?

May be a bit simplistic, but you're not caching the page or any
controls are you?

On Tue, 28 Jun 2005 02:25:03 -0700, dhnriverside <dan@musoswire.com>
wrote:
[color=blue]
>Hi
>
>I'm using a DataReader to pull items into a DropDownList from an SQL
>database. Everything works fine, but my client has started to nice that newly
>added database entries aren't appearing in the DDL.
>
>I've tested locally with exactly the same new record and it shows up fine in
>the DDL, so I'm wondering if perhaps the DataReader or DropDownList has some
>sort of maximum record/listcount limit?
>
>The client db has about 400 entries going into the DDL. Is this something
>like a limit, or is there something else it might be?!
>
>Cheers
>
>
>
>Dan[/color]

re: dropdownlist size limit?

Not that I'm aware of.... how would I know if I was?

It's not throwing an error either, its just not showing the latest records
added to the db. Very bizarre. Couldn't be anything to do with timeouts could
it?

"Sosh" wrote:
[color=blue]
> May be a bit simplistic, but you're not caching the page or any
> controls are you?
>
> On Tue, 28 Jun 2005 02:25:03 -0700, dhnriverside <dan@musoswire.com>
> wrote:
>[color=green]
> >Hi
> >
> >I'm using a DataReader to pull items into a DropDownList from an SQL
> >database. Everything works fine, but my client has started to nice that newly
> >added database entries aren't appearing in the DDL.
> >
> >I've tested locally with exactly the same new record and it shows up fine in
> >the DDL, so I'm wondering if perhaps the DataReader or DropDownList has some
> >sort of maximum record/listcount limit?
> >
> >The client db has about 400 entries going into the DDL. Is this something
> >like a limit, or is there something else it might be?!
> >
> >Cheers
> >
> >
> >
> >Dan[/color]
>
>[/color]

re: dropdownlist size limit?

You have to declare this explicitly, so you would probably know.
Look for the <%@ OutputCache %> at the top of your aspx file, (and
ascx files if you have any user controls)/

If the output is being cached you might expect new data not to show
(at least not straight away).

On Tue, 28 Jun 2005 09:54:08 -0700, dhnriverside <dan@musoswire.com>
wrote:
[color=blue]
>Not that I'm aware of.... how would I know if I was?
>
>It's not throwing an error either, its just not showing the latest records
>added to the db. Very bizarre. Couldn't be anything to do with timeouts could
>it?
>
>"Sosh" wrote:
>[color=green]
>> May be a bit simplistic, but you're not caching the page or any
>> controls are you?
>>
>> On Tue, 28 Jun 2005 02:25:03 -0700, dhnriverside <dan@musoswire.com>
>> wrote:
>>[color=darkred]
>> >Hi
>> >
>> >I'm using a DataReader to pull items into a DropDownList from an SQL
>> >database. Everything works fine, but my client has started to nice that newly
>> >added database entries aren't appearing in the DDL.
>> >
>> >I've tested locally with exactly the same new record and it shows up fine in
>> >the DDL, so I'm wondering if perhaps the DataReader or DropDownList has some
>> >sort of maximum record/listcount limit?
>> >
>> >The client db has about 400 entries going into the DDL. Is this something
>> >like a limit, or is there something else it might be?!
>> >
>> >Cheers
>> >
>> >
>> >
>> >Dan[/color]
>>
>>[/color][/color]