size limit on datagrid?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
I have a hard time, except maybe in reports, which you should not have to
"do" anything with after display, seeing a reason for displaying 5,000 rows
at a time. Users cannot work with that much data in one sitting, so it is
largely a waste. If there is a good reason, I am not against the idea, but
would find it hard to justify in anything other than a report. If it is a
report, consider making it downloadable as Excel (or output as Excel) for
manipulation.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
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
 
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
 
This is precisely what it is - a report.

Once I have the datagrid displayed, if it's the whole list - if I click on
any of the controls to either export it to excel or to reset the form, etc,
it'll give me the 3 prompts for my username & password and then give a 401.1
Unauthorized page.

SC
 
If I click on the button to export it to excel, it kicks the box up the
instant I click on the radio button to put it in excel, even before it'll go
back to the ASP code for the trace. Ditto for the reset button as well.

I've got stop points at the beginning of the all items place, and I'll F5 it
to the next stop - the bindgrid at the bottom of that sub.

Then I'll F8 and wait until the grid is displayed.

If I click on either the reset button or the export to excel button, it
gives me the 3 strikes on the password. It seems that any control is able to
generate it.

Steve
 
If you're talking about inside the HTML code on the aspx page, no it does
not. The
reports button does have something defined for it, below:

onclick="btnReports_OnClick"


The reset button does not have anything inside the <asp: > block either.

Steve
 
It should be noted though, that the export to excel is a radio button list
that is set to Web (it does nothing). Only if it's checked to excel or word
does it have anything assigned to the selected index being changed. I don't
know whether radio buttons have onclick events like regular buttons would.

The reset button though is just a button.

Steve
 
Curt:

The radio button in question doesn't have a server side click event - only a
selected index changed event.

What I've found though, is that the problem with the Challenge Response
problem comes from clicking on any control on the page.

SC
 
without looking at the actual code I'm not sure what more I could say on
this one.

Let me just see if I have this right though...
You have a page that generates an Excel (xls? csv?) file and this works fine
until you try to get a larger recordset? Now you said that in order to get
the "large" set you have a control on the page that you click on? correct?
When you click this it prompts you for user/pass?
Have you tried having the page_load call the "large" dataset? what EXACTLY
does the control have attacked to it (code wise)?

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
 
Back
Top