|
Hi Everybody,
I have a ASP program that displays a combobox with nearly 50000 records. I have used MS-Access database. It takes nearly 4 minutes to 7 minutes to display the page over the net. Binding all the records to the combobox takes this much time. In order to solve this problem, I have used rsfast library of learnasp.com. That also takes very long time. Can any help me to solve this problem?
Thanks in advance.
ramesh subbiah
E-Commerce India,
Coimbatore
|
|
|
|
|
How about encapsulating the generation code in a COM object that contains compiled code(C++ or VB), which is faster than the scripting code.
Mohammed Derbashi
Web Developer
|
|
|
|
|
Mohammed Derbashi wrote:
How about encapsulating the generation code in a COM object that contains compiled code(C++ or VB), which is faster than the scripting code.
There is a design flaw in the application, even if you were to create a COM component in VB or C++ to allow early binding to objects which does increase speed he is still going to see a lot of time degradation in the load process. 50,000 entries into a Select box is way too many, even if the file were to be loaded directly on the LAN. I would deeply suggest refactoring the application and look at ways in which you can isolate or group specific numbers, then post back to the server to get another subcategory of numbers. There is not a lot that you can do to see any dramatic decreases in load time for an application loading 50,000 entries into one page.
HTH
Nick Parker
|
|
|
|
|
Nick Parker wrote:
There is not a lot that you can do to see any dramatic decreases in load time for an application loading 50,000 entries into one page.
Especially in Access. I once worked for a company who was trying to use 1,000,000+ record tables in Access (the whole table, not just a few indexed records), that took HOURS to process.
Paul
|
|
|
|
|
Paul Riley wrote:
Especially in Access. I once worked for a company who was trying to use 1,000,000+ record tables in Access (the whole table, not just a few indexed records), that took HOURS to process.
All I can say is "Oh boy...." 
Nick Parker
|
|
|
|
|
Nick Parker wrote:
All I can say is "Oh boy...."
 That's not quite what I said when they told me. We have a smiley for that round here somewhere. Hold on, here it is: 
Paul
|
|
|
|
|
Paul Riley wrote:
We have a smiley for that round here somewhere.
We need a *!Are You Out Of Your Mind!* emoticon. 
Nick Parker
|
|
|
|
|
Hi,
I wrote a subclass of DataGrid in which I can fill the grid the way I want it to happen on each page.
In this grid I also create some dynamic comboboxes and bind a SelectedItemChanged event to it. When this event fires, I want to put different data in the grid.
Now, I've implemented this event by creating a new dataset and dataview and binding that to the Grid. If I step through the code, you can see the right effect. After the DataBind, the numer of items in the grid is exactly the way it should be..
So far, everything is as you would expect. But if I put a breakpoint in the PreRender event and look at the items in the grid, nothing has changed! The content of grid is exactly the way it was BEFORE my BindGrid....
When does this happen, who is doing this, and how do I shut it off? 
Structured programming vs. chaotic mind boggling
|
|
|
|
|
Hello,
I've created a class which inherits system.web.ui.page (the default inherits of an aspx page). In this class I can use session object but I can't use request object nor server object  .
1. Which class shall I inherits to use this object ?
2. How can I simply add a little code to all my page_load sub. I want to check on each page load if the session is still active and if the current user as enough right to load this page. I thought about writing a new class which will inherits default aspx web page class but as I say in point 1, I can't use request and server object. If you have any solution, it will be very welcome.
Thanx
Sybux
|
|
|
|
|
sybux2000 wrote:
n this class I can use session object but I can't use request object nor server object
Thats odd. Just as a quick thought (I have not tried this) but in your class have you referenced using System.Web at all? Might need to, not sure.
|
|
|
|
|
Sorry but It's not possible to reference the full namespace.
Has some an idea ?
|
|
|
|
|
sybux2000 wrote:
Sorry but It's not possible to reference the full namespace.
Not sure what you mean. Do you mean when you code in that using statement it tells you no such namespace exists? In that case you need to add the DLL to your project as a reference.
Otherwise I am not sure, post some code and then maybe we can help
|
|
|
|
|
Hi,
how can I change programaticaly the bgColor of my page for example ?
Thanx
|
|
|
|
|
Try using HTML Control and CSS like this:
<script language="VB" runat="server">
Private Sub Page_Load(obj as Object, e as EventArgs)
objBody.Style("background-color")="#cccccc"
End Sub
</script>
<html>
<body id="objBody" runat="server">
<h1>Hello World</h1>
</body>
</html>
Enrico
|
|
|
|
|
Apologies if this is an old question.
My website is hosted on a fairly standard NT setup with ASP (not ASP.net - though I think that is supported as well). The question is, I'd like to permission off a particular area of the web site, how do I do it? I don't have any kind of rights on the box.
The only thing I do have control over is an access db file, and listing the contents of directories. I've looked at the help from my hosts and there doesn't seem to be anything in there 
Thanks.
B.
|
|
|
|
|
Barry,
I had met similar problem before. In a hosted environment, we have limited control over securing a portion of the website.
ASP.NET has the solution to secure a folder using setting in web.config, but again some hosting servers only allow web.config file to resides in root folder. 
What I did in classic ASP and ASP.NET is to provide login/logout facility to authenticate user. The user credentials are stored in the database. Once the user is authenticated, I stored the authentication info in cookies. Then in the beginning of each web page I want to secure, I call a function to check the cookie and find out whether the current user is authenticated.
This is a hard way but worth to try. If you need some sample codes, just drop me an email.
Enrico
|
|
|
|
|
Enrico,
Thanks for that I've already started doing something similar (when I get the time!)  It's only to really protect parts of the site from the casual user so it doesn't have to be perfect!
Thanks,
Barry.
B.
|
|
|
|
|
How can I change the position of controls in my code behind file?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Mazdak wrote:
How can I change the position of controls in my code behind file?
Do you mean the visual position of the HTML elements on the page?
|
|
|
|
|
Paul Watson wrote:
Do you mean the visual position of the HTML elements on the page?
Yes.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Mazdak wrote:
Paul Watson wrote:
Do you mean the visual position of the HTML elements on the page?
Yes.
Ok couple of things (sorry if you know some of this, just going over it to make sure.)
HTML element positioning is not like a Windows app where you can just set the left and top and have it sit wherever you want. By default it is in "flow" mode where each element flows on from the last.
You can however absolutely position elements by using CSS, so overriding the flow behavouir. When you do this to an element it is taken out of the flow of the document and other elements which are not absolutely positioned will act as if that absolute element does not exist when determining their position.
To get an element to position on a left and top basis you need the following CSS styling applied to it: style="position: absolute; top: 100px; left: 100px;"
Also remember that there is a distinct Server side and Client side to a web app. So you cannot have a for loop in the onload event of your ASPX page which moves an element across the page, it won't work as at that point the HTML has not been sent back to the client. You have to use JavaScript on the client-side to do that (or SVG, SMIL etc., but still all on the client-side.)
Of course in your ASPX onload event you can position a control and that position will be displayed to the client. e.g. Label1.top = 20; Label1.left = 20;
In most cases using the CSS method is best and the easiest (and remember rather use a CSS external file rather than the inline style I showed.) However if you need some calculations to determine the position then you can use JavaScript on the client-side or whatever ASP.NET language you choose on the server-side.
If none of the above is what you are looking for, post your code and what you want to do and I can help more
|
|
|
|
|
Thank you Paul.
Paul Watson wrote:
To get an element to position on a left and top basis you need the following CSS styling applied to it: style="position: absolute; top: 100px; left: 100px;"
I use this part and work for me.I find the top and left in the string and change the value of them.So I can change the position.
Paul Watson wrote:
Of course in your ASPX onload event you can position a control and that position will be displayed to the client. e.g. Label1.top = 20; Label1.left = 20;
How can I overriden onload in my ASPX and can I written it in C#?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
How Can I pass TWO parameters two my ASP.NET in Redirect() function? When I put ? in my URL it see all character after it as one parameter.How can I add another one?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Find it out.I have to use &.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
