Re: size limit on datagrid?

From: Curt_C [MVP] (software_AT_darkfalz.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 12:52:05 -0600

step through the code... what line kicks the login box to appear? 

-- 
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
<me@privacy.net> wrote in message
news:uH8mIh5BEHA.1128@TK2MSFTNGP11.phx.gbl...
> I am confused also.  I don't think that it should have to prompt me for
> username & password, but it seems that only when I have the big list
> displayed is when it prompts me with the username & password thing.  It
> doesn't anywhere else.
>
> Here's what happens - first the Normal, then the way that it barks at me
> when I have the 5000 records.
>
> First I load my page, and then I pick a distribution channel in my
dropdown
> list - a big one - with 1900 records in it.  I click on the sort, and sort
> it by state order, then by customer name, etc.  then export the list to
> Excel.  All works fine.
>
> If I do it the way that gives me trouble, I click on a radio button that
has
> the "All Items" on it.
>
> I have it disabled to where they cannot sort this list, but then, if I
click
> on any of the controls on the web page, it prompts me with a box that
> resembles the NT Challenge response box that has:
>
> Connect to mycomputer.mydomain.com
>
> and in the grey part of the box, above where it has already populated my
> domain\username, and prompts for my password, it says "Connecting to
> mycomputer.mydomain.com".
>
> I'll enter my password, and click Remember Password, and it'll prompt me 2
> more times before giving me a 401.1 Unauthorized:  Logon Failed page, that
> says "You are not authorized to view this page".
>
> I know the page works, as the sql I'm using is executing against a
database
> that isn't even on my local machine, and all the other queries work fine.
> It's just that when I have this big datagrid loaded, it yaks at me doing
> anything at all to it with the controls I have on the screen.  The code
for
> displaying everything is here:
>
> RadioButtonList1.SelectedIndex = -1
>
> cmbChannel.SelectedIndex = -1
>
> lblDC.Visible = False
>
> cmbChannel.Visible = False
>
> DataGrid1.Visible = True
>
> ss = "select ssoldto, sshipto, ssalesgrp, ssalesrep, sdistrchnl,
scustname1,
> sstreet, scity, sstate, szip_code, stelephone from tblmaster_shipto "
>
> ss = ss & rSQL
>
> ss = ss & " group by ssoldto, sshipto, ssalesgrp, ssalesrep, sdistrchnl,
> scustname1, sstreet, scity, sstate, szip_code, stelephone "
>
> ss = ss & "order by " & sortfield & " " & sortdirection
>
> DataGrid1.AllowSorting = False
>
> BindGrid()
>
>
> Sc
>
>
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:uu4Bpi4BEHA.628@TK2MSFTNGP10.phx.gbl...
> > SAP <shudder> I built enough custom interfaces to SAP that I know it's a
> > pain... Anyway...
> >
> > Ok.... why do you think the username/password has anything to do with a
> size
> > issue? I'm confused. If the site is asking for user/pass then you have
> auth
> > turned on. Either enter a valid user or turn of the Auth.....otherwise
you
> > will need to clarify exactly what the problem/error is a bit more
> >
> > -- 
> > Curt Christianson
> > Owner/Lead Developer, DF-Software
> > www.Darkfalz.com
> >
> >
> > <me@privacy.net> wrote in message
> > news:Ou979d4BEHA.1456@TK2MSFTNGP09.phx.gbl...
> > > We do not have paging turned on on the listing.
> > >
> > > We actually use that listing to "dump" a customer database into Excel,
> > which
> > > we can't do with paging on.  We'll then use Excel to move it around,
and
> > > make the changes that get passed back to the SAP users who'll make
> changes
> > > based on what the user has requested (i.e. account changes, name
> changes,
> > > sales rep assignments, etc), or to follow-up on those requested
changes.
> > >
> > > Why is it then asking me for a username & password when I try to do
> > anything
> > > to that datagrid?
> > >
> > > SC
> > >
> > >
> > >
> > >
> > > "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> > > news:udSrCW4BEHA.1544@TK2MSFTNGP09.phx.gbl...
> > > > only in the amount of time/memory to generate.
> > > > But PLEASE tell you have paging on? 5000 is WAY to many to actually
> look
> > > > through
> > > >
> > > > -- 
> > > > Curt Christianson
> > > > Owner/Lead Developer, DF-Software
> > > > www.Darkfalz.com
> > > >
> > > >
> > > > <me@privacy.net> wrote in message
> > > > news:e6mzxL4BEHA.2600@TK2MSFTNGP09.phx.gbl...
> > > > > Is there any size limit to a datagrid?  I have one that has 11
> columns
> > > and
> > > > > around 5,000 rows that I want to display.
> > > > >
> > > > > Reason I'm asking is that I get a challenge/response type of input
> if
> > I
> > > > try
> > > > > to do anything to this datagrid once it's displayed.
> > > > >
> > > > > Anyone know?
> > > > >
> > > > > SC
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Loading