VS 2010 - Presenting Large Number Of Records To User For Selection
Jul 24, 2014
I have an ASP.net VB Web app I'm working on that has a requirement to provide a list of all our component part numbers to our engineers for selection into a custom Bill of Materials for reworking of an assembly. The list of part numbers is currently generated from a stored proc in our MRP systems/SQL database. The number of records being generated is slightly over 39K part numbers.
Although the SP only takes a few seconds to generate the data the web page is taking a couple of minutes to load, primarily because of the time to fill the control presenting the records to the engineers. I've bound the data to a combobox control to the engineer. They want to be able to type the first few characters of the part number if they know it and have the list filtered or be able to just scroll the data to find the part they are looking for.
I've read elsewhere that they may be a way to only populate a certain quantity of records rather than all 39K then filter based on the users actions. Unfortunately the discussions about doing this didn't provide any examples, references, etc.
My questions are these...
Is there a better way to handle this quantity of records than a stored proc and combobox? A
ny examples of a method to populate a certain number of records then filter based on user action?
View 2 Replies
Similar Messages:
Mar 10, 2010
I want to insert a large amount( approx 7000 records) of data into a table, My scenarios is that i need to check whether the record already exists then it will not insert it. Currently i am using a stored procedure for this which gets called for each record.
IF EXISTS(SELECT 'True' FROM MYTABLE WHERE ID = @ID)
BEGIN
--This means it exists, return it to ASP and tell us
SELECT 'This record already exists!'
END
ELSE
BEGIN
--This means the record isn't in there already, let's go ahead and add it
SELECT 'Record Added'
IF EXISTS(SELECT 'True' FROM [Aadil].[dbo].[SharePointSitesData] WHERE ID <> @ID)
View 11 Replies
May 21, 2012
I am having nearly more than 80 thousand records and i need to export in .csv format.
I need to export to woksheet.
I need to export nearly 65 thousands of records in one sheet,
When it reached the limit, it should exported in the next sheet.
View 1 Replies
Dec 4, 2012
In my database m having 1000 record and I want to display 10 record on each page on gridview so every time it fetch 1000 record so while page loading it is quite time consuming ..
View 1 Replies
Jul 13, 2012
I follow the following link for add dropdownlist in gridview.Adding Dynamic Rows in GridView with DropDownLists in ASP.Net..In this template field the drop down list contain 500 items how can i search the paticular item
View 1 Replies
Mar 18, 2013
I have a user control that is common to the application. It searchs for lakhs of Items in one go from the db and I set the selected Items in a list in a session to pass on to the pages that use it. Hence making the application a tad slower. The gridview that contains the Items should have sorting, page indexing. What according to u,I should do to enhance the application's performance ?
View 1 Replies
Nov 5, 2010
I tried to find out about subject but with no success. The point is that in the beginning I've made many user controls. My site is too slow. I have not idea yet if it is because of user controls.
View 7 Replies
Apr 15, 2013
i want datalist to show only 6-8items ,as these datalist is connected to datasource which has more than 20 items..
like in facebook,we have lots of friends but in friend box only 6 friends is shown and when we click that we go to next page which display all list of friends...
View 1 Replies
Apr 7, 2010
I was wondering if anyone can help me work out what the user has selected in this selection changed event?his is what I have so far:
protected void rblNavigation_SelectedIndexChanged(object sender, EventArgs e)
{
string url = (GetCurrentPageName()).ToString() + "?" + Request.ServerVariables["QUERY_STRING"];
[code]...
The problem is that rblNavigation.SelectedValue is not the value that the user has selected to trigger this event. How do I get the value the user has just selected?I'm using C# and this selection event is inside my MasterPage.
View 1 Replies
Apr 28, 2010
I am working on a website in which more than a thousand users can login at a time and there may be more than 50000 total users. I am worried about the performance of the application in case of concurrent access.
what is the best way to manage that, so that my application runs without any performance issues.
View 2 Replies
Feb 9, 2010
I'm running a ASP.NET website on my development box (.NET 2.0 on Vista/IIS7).
The Session_Start method in global.asax.cs logs every call to a file (log4net).
The Session_End method also logs every call.
I'm using InProc session state, and set the session timeout to 5 mins (to avoid waiting for 20 mins).
I hit the website, wait for 5 minutes unit I see the Session_End logging. Then I F5 the website. The browsers still has the session cookie and sends it to the server. Session_Start is called and a new session is created using the same session id (btw: I need this to be the same session id, because it is used to store data in database).
Result:
Every time I hit F5 on a previously ended session, the Session_Start method is called.
When I open a different browser, the Session_Start method is called just once. Then after 5 minutes the Session_End each F5 causes the Session_Start method to execute.
Update:
After the Session timeout, all subsequent requests have a session start & session end. So in the end my question is: why are the sessions on these subsequent request closed immediatly?
[code]....
View 3 Replies
Jan 21, 2011
I am building a small mass email application for my department. Which basically emails out a notice to a large list of email addresses. Because the company email server limits the amount of email addresses that can be contained in a single email I have to break the list apart into smaller 100 email groups.
I've create the query to pull all email addresses needed, stuffed them into a collection but I am not sure how to grab 100 emails at a time and send it off to another sub to perform the email send before grabbing the next 100.
This is what I have so far.
[Code]....
View 5 Replies
Feb 17, 2011
Handling large number of images downloaded from server
View 4 Replies
Feb 11, 2011
Working on a heavy ajax based site with over 100 methods from all the ajax calls inside each of each controller all with basically the same code.Was thinking of changing them to a big case statement for readability which would keep the code a bit more dry and make it easier to read.What I am wondering is: Will there be a performance hit and is there a better way to deal with it?
View 4 Replies
May 7, 2015
I have one application and there are 1500 users of that application.When 200 users logged in application that time login page and other pages of applications are not opend. I want to manage 1000 of users at a time.
View 1 Replies
Mar 7, 2012
I have 65 columns in the grid, if the columns are reduced to 20 then the speed when accessing from client is more or less similar to that accessing from web browser. Does it mean that all this performance issue is due to the data only ???
View 1 Replies
Jul 28, 2010
I am working with VS 2010, Entity framework, SQl-Server 2005, ASP.Net web forms. Currently, I am working on the Data access layer library which soon will be a web service, using Entity Framework collaboration with different design patterns like repository pattern and some best practices that posts in different blogs. I am also test each repository using the Unit testing project. Thumbs up! Working fine.
The thing I am worried about is, how much is good for retrieving data from a table that can contain 80-100k records ?
View 1 Replies
Feb 14, 2011
i've header and detail rad grids. when i click a record from header rad grid, it must be filled detail grid.
how to do this?
View 2 Replies
Apr 16, 2010
I have around 100 rdl report files...what i have found in google is -> open RS Admin site upload each report...doing this manually takes a lot of time... We don't want to use Target report server url method and clicking deploy option to deploy the reports or report project onto the report server...because we are not provided with such production server url information...!! In client perspective...We just give the reports as a rar file...now client will have to extract the report files...and what should be the next step...!! Is there anyway to deploy or upload all the reports at a time...!!
View 1 Replies
Jul 30, 2013
How to resize large number of images in a folder in c# windows application. I am using following code to resize images of my folders. If images are less than 1600 ( in number) then no problem but if images are more than 1600 then i am getting error. My code is given below:-
public static Image ResizeImage(string file, int width, int height, bool onlyResizeIfWider) {
using (Image image = Image.FromFile(file)) {
// Prevent using images internal thumbnail
image.RotateFlip(RotateFlipType.Rotate180FlipNone);
image.RotateFlip(RotateFlipType.Rotate180FlipNone);
[Code] ....
Thumbnail creation in ASP.Net: System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI
View 1 Replies
Feb 15, 2011
When i click on a row in gridview1, i want to go to gridview2 with the id i get from first grid.
How to get id from gridview1 to gridview2 and gridview2 autobinding?
View 1 Replies
Sep 21, 2010
I've gone through this link. (http://connect.microsoft.com/VisualStudio/feedback/details/544562/cannot-send-e-mails-with-large-attachments-system-net-mail-smtpclient-system-net-mail-mailmessage)
It is not possible to send an e-mail with an attachment larger than 4 MB in .NET Framework 4.0. The same code works for small and large files if you set the target platform from .NET Framework 4.0 to .NET Framework 3.5. So this cannot be a problem with our mail-configuration! I get no error if I attach e.g. 10 files of 2 MB! I searched through Google but I didn't get it.
Workaround solution is not working fine as expected. After using this workaround for a while, I found that some files are corrupted. So this is not a solution for this bug.
We've applied that Microsoft patch and we're still seeing the issue?
View 1 Replies
Feb 1, 2012
I am building a webservice that reads some HTML source code from a website and sends it back to the client. The service however is failing to send the data because it is too large. I keep getting this error:
The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter [URL]..... The InnerException message was 'There was an error deserializing the object of type iRacingForumServiceTest.ForumService.GetForumListResponseBody. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 153, position 247.'. Please see InnerException for more details.
I have been googling this problem for ages and I cannot figure out how to apply the answers I keep finding.
The problem is simple: the default configuration doesn't allow such large strings. I just don't know how to change this. All I keep finding is things related to WCF, I'm not sure if that applies for me.
What I keep finding is that I need to change the web.config file in various ways. However I cannot figure out where I need to put the config sections. I've tried everything but without a complete web.config file example I can't get it to work
Here is my current web.config of the server:
Code:
<?xml version="1.0"?>
<configuration>
<configSections>
</configSections>
<connectionStrings/>
<system.web>
[Code] ....
I found this piece to add to it:
Code:
<system.serviceModel>
<services>
<service name="ForumService">
<endpoint address=""
binding="basicHttpBinding"
[Code] ....
I figured out where to put it without getting errors (just as a child of the <configuration> element), but it just doesn't work. I get the same error no matter what values I try here... This shouldn't be such a difficult issue, how can I solve it?
View 8 Replies
Jan 25, 2010
as all we know that we can create very simple chat using ajax timer & web service , it runs well for few users .
i want to leaverage same idea for site where 5000+ users will be there in chat room , messages are stored in queue hold in memory * dispatched as user request that is through java script timers calling page method or service ,
how well it will perform ? i know GTalk implements XMPP protocol(jabber) for the web chat
seems it will be difficult to got XMPP way ?
View 1 Replies
Nov 18, 2010
I have developed one simple application in that i am using mysql database. but my database size more thatn 4,50,0000, as well as ecah and every second my database is updated i.e record ll be added to the table how can i get the details for one single click.
View 1 Replies
