|
How can I retrieve 1700 or more rows of data from SQL server to a Classic ASP page in an Efficient way?
I have a management royality report which uses multi-dimensional arrays, but the script is very slow it takes 4 to 5 minuts to load.
Can someone suggest a best practice for this problem.
Thank you.
|
|
|
|
|
Naeem ul Haq wrote: How can I retrieve 1700 or more rows of data from SQL server to a Classic ASP page in an Efficient way?
By not displaying 1700 rows of data on a single page.
Naeem ul Haq wrote: I have a management royality report which uses multi-dimensional arrays, but the script is very slow it takes 4 to 5 minuts to load.
Ensure you are letting SQL Server do the data work for you, and only display a small portion of it at a time.
|
|
|
|
|
Naeem ul Haq wrote: Classic ASP
This is the ASP.NET forum. As Damian said, the best practice is to design your page to be sane, but either way, this is the ASP.NET forum.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
You need to do several things.
1 - the user needs to select an image
2 - the user needs to push the button
3 - the page needs to post back
4 - you need to save the image somewhere
5 - you need to send the page back with the source of the image control being set to where-ever you saved the image.
You can save it in the file system, under the application root ( use Server.MapPath to find the file system equivalent ), or to a database, and then you'd need to write a page which returns the bytes of the image and the correct MIME type, taking the id of an image on the URL, and set the control to that.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
Why do you need it ? What are you trying to do ? Which bit are you stuck on ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
You are an idiot. You asked how to do something very trivial, I explained it, then you demanded I give you source code. If this is homework, you need to understand it in order to learn. I was trying to help you to understand the problem.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
modified on Tuesday, November 3, 2009 3:43 PM
|
|
|
|
|
And finally he deleted his post....  
|
|
|
|
|
AND gave me a 1 vote for trying to help him..
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
We can't have that. 5'd
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Yes... 
Gave you 4 like Mark. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
I hope this is the right area, but I was working on this project and I'm a little stuck and wanted to know if I get can some help. We have a page in our site that we just added that allows some of our customers to add new users to their programs by filling out a form and submitting it, all of the fields are saved in a Database and used to create the agent record and fill out those fields in there. But before the agent can be added there is a four part review that needs to take place and within each step there's different options for approval/decline/more information. Here's my problem, or where I'm stuck:
How to you get a table to have it's own buttons that correspond to each row of a database. If I use the GridView I'm stuck using only the buttons they allow (such as the Edit button and Delete button) but I wanted to have a View button that would either open a PDF File or Pop Up window displaying all of the information entered on the form that's stored in a Database. I would also want a button that could be used to either Approve (which would update the Status field in the Database to the next step) or Decline (which will allow the reviewer to enter a message that can be seen in the Notes section of the Table and Database).
I was thinking that maybe a JavaScript type table could be used, this way the table can expand to show the documents if they click a button and there may be a time where supporting documents could be added to a user but I don't know how that will play into the design of this area. I don't know if I'm looking in the right area or if I should be looking at something else, since I've been having trouble with the Gridview in Visual Studio 2005, or maybe it is possible and I just don't know how to set it up correctly. Thanks.
|
|
|
|
|
I believe what you are asking for can be done, however, it will require some coding on your part and you won't be able to use the Drag and Drop functionality of the Gridview.
What you want to research is building your Gridview at run time instead of design time.
This means that you will need to dynamically add controls to the basic Gridview control based on the columns that you are attempting to bind to that control.
I don't have an example on hand, but I've seen it done before. Search around for Gridview and Dynamic columns or controls.
Good luck. 
|
|
|
|
|
Thanks, I'll take a look around for controlling a Grid View Dynamically. I knew there was a way I just couldn't think of how it's done.
|
|
|
|
|
Hi,
I am new to software project time estimation.
I came to know that people are using some techniques such as ‘Function point analysis’ , ‘Cocomo model’ etc.
May I know the latest and best technique? Also would you please let me know the best tutorial links for these models so that I could go through them and understand?
Many Thanks,
Regards.
Anusha.
|
|
|
|
|
How long have you been programming for ? What sort of paid projects have you done in that time ? These are the things that decide the best answer to this question.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
Hello All;
I have got a task regarding parameter passing to Crystal Report via Crystal Report, I would like to find best way to achieve it.
Imagine that I have got parameterized and non reports-parameterized. I am developing a report manager that will enable users to subscribe to the reports and schedule them with their parameters. I have got a subscription web page with the list of reports. When a user wants to subscribe to a report and schedule it, if there is no parameter in the report, it is fine but if there is any parameter that needs to be passed to the report(which we can find from rpt file), user should be able to enter these parameters values via a panel in the page. and I will save those parameters' values to the database.
Effectively, I need to create a parameter entry panel to get the parameters and save them to the database with their type, value and so on, then I need to use these parameters programmatically for exporting reports to the different file formats.
Basically, I must develop parameter entry panel run time in accordance with the parameter types that the corresponding report has.
Does anyone have any idea what the best way is to achieve it?
Thanks for your help from now on and please ask for further clarification if needed/
Kind Regards.
|
|
|
|
|
Mesut KOSUCU wrote: Does anyone have any idea what the best way is to achieve it?
Of course by code. Just generate the Dynamic Html from your code to get values for your parameters.
This is no big deal.
If you create an object of Textbox and render it to the client, it will be added to the page. Even you can create custom html using StringBuilder and paste any container control to produce the same output.
Dont worry about all these, just start your coding. You will definitely find the wayout yourself.
Cheers.
|
|
|
|
|
Dear Abhishek
Thanks for your reply, I appreciated really.
But the problem is I could not figure out, if the parameters are primitive types, this is fine I can use the way you have told.
I there any way to get list of the parameter values of a parameter of a report via code behind? Why I need to do is that, for instance, let's say reports need EmployeeID for generating report, then I will have to create a dynamic dropdown list and populated with the employees. So, that would be good if there is any way to get possible values of a parameter via c#. or will I have to do it statically?
What would you think about it? thanks for your help.
Cheers.
|
|
|
|
|
I think you need to somewhat figure out what are the parameters that it should be passed.
Other than premitive types how could you send data. I dont know if a complex type could be send as parameters to crystal report, but AFAIK it cant be.
I think the better way to create a list of all the available Reports that the crystal Report viewer might load and generate the parameters based on what is loading. If you know what data to be passed, you can easily generate the interface.
|
|
|
|
|
Hi,
I am looking for the “Software Project Management Templates” such as the following. Sorry!! In our organization we don’t have these, yet.
1. Issue Log
2. Risk Register
3. Change Log
May I know where I could get these templates as well as other standard “Software Project Management Templates”?
Many Thanks,
Regards.
Anusha.
|
|
|
|
|
What do you mean by 'template' ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Why Dont You Perpare one ..!And make it available to all
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
