Improve Paged Gridview Performance : Huge Underlying Dataset?
Jul 1, 2010
I'm currently working with a gridview that has a huge underlying dataset.I'm almost certain that I saw something about a new facility in Visual Studio 2010/.NET 4, which would improve the performance (e.g. doesn't download all the data on databind, but rather only what data required for current page). My guess would be that it was using AJAX.I didn't need it at the time I saw it, and now I can't find it, even though I've been hunting online for a while.
View 2 Replies
ADVERTISEMENT
Jul 9, 2009
I have a paged gridview. I want to get the text of every row and put that text into an array. However, I only get the text for the visible rows, not the entire dataset. I can't just get the data from the datasource because the gridview is populated by two different databases. How could I get every row's text - visible or not visible?[code]...
View 1 Replies
Mar 9, 2010
i'm developing vb.net application. There are 10 ways of transactions. I want to produce 'Purchase register report'. For that I want to find what amount of effect has been made by each transaction on ledgers of 'Purchase account'. Purchase account has almost 30 ledgers. And transactions can produce about 10000 rows in database for a year. Now if I produce month wise report for a year, there will be 10000*30=300000 row scanning which makes it very slow in execution.
View 6 Replies
Mar 7, 2009
I'm trying to improve my app with some error catching. I have a module that downloads a file from the Internet to a local folder. At the moment, if the local folder doesn't exist, it just crashes here:
strLocalFile = New FileStream(pPath, FileMode.Create, FileAccess.Write, FileShare.None)
with error:
System.IO.DirectoryNotFoundException was unhandled
Message="Could not find a part of the path 'C:Documents and SettingsSimonDesktop estdownload.zip'."
Source="mscorlib"
How can I do something with that error and stop my app from crashing? Ideally, have a messagebox show saying 'directory not found' or similar.
View 5 Replies
Oct 25, 2010
i have a datatable with about 10000 rows and few columns (4)I have noticed that the process of reading a big table its quite slow..is there a way to improve performance in reading a datatable?
View 15 Replies
May 31, 2012
I have a repeater which takes 270 seconds to render and actually ends up crashing all browsers. The SQL to retrieve the data takes about 10 seconds. I wanted to remove the Eval's to see if that speeds up things a bit, but I am having trouble with the correct syntax. I have doubts that this would actually improve performance as I am dealing with 150,000 records. Would a GridView or other control be faster? Would using LINQ to SQL improve performance? Here is the code for the Eval:
[Code]...
View 1 Replies
Apr 10, 2009
How can I improve the performance of a Windows Forms application?
View 1 Replies
Jul 30, 2010
improve performance of Contact fetching using EWS managed API?
View 1 Replies
Jan 18, 2012
How can I improve the performance of a Windows Forms application?
View 5 Replies
Jun 25, 2009
If I took a COM object (specifically Excel 2003 workbook) and made it an embedded resource of my executable, would that improve the notoriously slow .NET-COM interop at all?
View 1 Replies
May 21, 2011
I want to import data from excel and move that to Datatable in VB.NET 2008. I wrote and working but its taking too long time.. for 1500 records its taking 4.40 min.
[Code]...
View 1 Replies
Oct 29, 2010
I have a button on the page and a gridview with checkboxes on the first column. The gridview is bound to a List. On buttonClick, I need to retrieve the underlying bound data item (MyEntity) for each selected row. How can I do this? I can't simply recreate MyEntity based on the gridview columns, because I am not displaying all the fields of MyEntity. I need a way to get a hold of MyEntity based on the key (MyEntityId).
View 2 Replies
Apr 25, 2012
I've got a databound query in my application which is querying the "Customers" table in our database.I've created this directly from the ComboBox's datasource creator in the Design view.Various bits of code created in the designer include:
Me.CustomerBindingSource.DataSource = Me.CustomerDataSet
Me.ComboBox_Customers.DataSource = Me.CustomerBindingSource
What I've done in the first stage of developing this feature is to show my users a ComboBox showing a specific subset of the customer list by applying a filter to the BindingSource.
Me.CustomerBindingSource.Filter = "someColumn = 3"
What I want to do on a second pass is to allow the users to type a specific bit of information into a textbox and check whether it appears in Me.CustomerDataSet like so:
Dim x As IEnumerable(Of CustomerDataSet.customerRow) = From cust In Me.CustomerDataSet.customer Where cust.custno.Trim = "test"
If x.Count <> 0 Then
At this point, I have a customerRow object. I want to check whether this customerRow object appears in the list presented to users in Me.ComboBox_Customers via the filtered Me.CustomerBindingSource. Me.CustomerBindingSource does not (directly) contain customerRow objects, it contains Object objects.How do I find out whether Me.CustomerBindingSource contains the customerRow object at whatever lower level?Also Once I've determined that Me.CustomerBindingSource contains the item, how do I select that entry in the ComboBox?
View 1 Replies
May 11, 2012
I have a Windows Form application with a form that has an underlying data set. When the users click a particular button, the code clears some fields on the form but also is suppose to update a value in the underlying dataset on a field that is NOT displayed on the form.
In VB6 and VBA this is very easy to do. I simply says Forms!formname!NameOfUnderlyingFieldNotshown and pass it the value. How do I do this in VB.net with a Windows Form and underlying dataset?
View 2 Replies
Feb 2, 2011
I have a reasonably simple page setup with four accordian panes and four gridviews in each accordian. The gridviews in themselves are bound to 4 entity data sources with paging and sorting enabled on each and I have a command field which shows the edit/deleted button on each
I am seeing a massive performance issue when selecting edit/ Update/cancel from the gridview row in as much as it takes 20 + seconds to enter the edit state and then another 20 if you cancel out of edit mode. I have pulled out the contents of one of the accordian panes into a seperate page and it enters edit mode in about 1-2 seconds?
View 1 Replies
Aug 9, 2011
I have a dataset in a Visual Studio 2010 Web App project which accesses the DB with a complex SQL statement. If I run the statement in SQL Management Studio directly, it loads in a less than a second. If however, I run it using the "Preview Data" button in the dataset designer, or I try to access it on a page (with a gridview for example), it takes over 40 seconds!
View 2 Replies
Mar 16, 2009
I have a program in where I need to loop though the entire dataset.datatable. I takes a long time. What is the alternative I can use to do the some job but faster?
View 4 Replies
Apr 30, 2009
from a performance point of view is it faster to work with linq to sql or dataset.datatable?
View 6 Replies
Aug 29, 2011
I am having dataset with 5000 records.I am reading them in the below 2 functions and writing to excel.
FillDataRows1(worksheet)
FillDataRows2(worksheet)
private sub FillDataRow1(byval ws as worksheet)
[code]....
When I create thread also it is taking same time .
View 1 Replies
Dec 21, 2009
I have inherited some very old ASP.Net code. Written initially in 1.0 and then converted to 2.0 There is a page which uses a custom pager control. That control has the following logic in it:
Private _DataSource As PagedDataSource
Public Property DataSource() As PagedDataSource
Get
[code]....
The task at hand was to remove all session variables. What would be the best way to represent this data without the use of session. Originally i was told to put all session items into a cookie, while this worked for most of the items it will not work for this due to the cookie size limitation, Im also not to keen on the idea of keeping it in ViewState or even if that is an option. Im very new to VB and dont have much expierence re-writting legacy code. Session is not an option because this is being moved into a web-farm and Sticky sessions are turned off so it must work without session.
View 1 Replies
Apr 19, 2011
how can i get the dataset from a gridview i have populated?
i tried this:
Dim importedDS As DataSet = gwResults.DataSource
but it's coming out blank all the time. is there another way?
View 2 Replies
May 4, 2011
I dont know why my data is not showing in my gridview, if i use an sqldatasource with the same query it works.
cmd.Connection = conn
conn.Open()
cmd.CommandText = "SELECT DISTINCT TOP (100) PERCENT dbo.tblConfig_Agent.FirstName, dbo.tblConfig_Agent.LastName,
[code]....
View 1 Replies
Jun 7, 2010
I want to display dataset records in textboxes instead of GridView. I also want to provide next, previous and search option to navigate between records in the dataset. And I also want to provide update and delete buttons to update and delete the current record that is being displayed.
View 4 Replies
Sep 29, 2009
I am using dataset in my project.After filling all the tables in dataset,i want to perform join queries on tables.i dont know how to do that...Also i want to fetch few columns in a gridview from dataset table.I can't use ds.tables("student").select(name,roll)....
View 1 Replies
Mar 9, 2011
I'm still in my novice stages of .net development, and I think I may be trying to make something too complicated.In VB.Net 2008, I'm using a SQLDataAdapter to Fill a dataset with records being returned from a Stored Procedure (SQL Server 2005).I'm using that dataset as the datasource for a gridview. Up to this point, everything is great and I understand what's happening.I'm getting ready to make my first-ever attempt at updating the data in thegridview and then pushing the updates back to the SQL dB.Here's where I'mgettingconfused...to cut to the chase, what's the simplest way to load the updates back into SQLServer?
View 2 Replies
Jan 27, 2010
How to join two tables in dataset and show in gridview using vb.net 2008?
View 1 Replies
Jun 9, 2009
i created a type dataset. added two table adapters and made relationship on the key. now i want to show the datagridview with master/detail. how i can do it?
View 5 Replies
Jul 31, 2009
I have been writing code fore a rather large project in the past mounts And Im beginning to think about arcitecture of the program... Its just a complete mess. I dont know how to tackle so much code..Its beginning to be impossible to debug.Basically Im doing the following prosidures. Importing several a Excel files and getting the rfrequency data from these files..Displaying them in a litview and a datatable... so you are able to edit them..Doing some calculation and exporting the results back to a xls file.Problem is now that im going to add more functionallity to the program,. What im woundering about is, is there some good unofficial guides on how to program with OOP?
View 11 Replies
Sep 21, 2009
I've been messing around with prime numbers for a while now, but I now want to use massive numbers, say a few million digits in length. Is there a way of storing and performing mathematical functions with such large numbers? Is it even possible on my home computer? I read on another old thread, something about a big number library, but the links he gave are now dead.
View 4 Replies
Aug 1, 2008
Ok New thread - god I hate laptops sometimes - I just 'lost' a huge post in the editor due
View 1 Replies
