473,811 Members | 2,770 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Rendering tabular data - best for performance?

1 New Member
In terms of processing speed, what is the best method for displaying tabular data from a database in a Windows forms C# app? We generally use data grids (Infragistics WinGrid), but have an instance where run-time performance MUST be optimal - coding complexity and other things are less important. Here are some paticulars:
1. Data is stored in SQL Server.
2. Data is read-only.
3. The container/control must allow for mouse-click event handling on a row or cell basis (based on row or cell content).
4. The container/control must allow for contents to be displayed in different font colors and weight (bold).
5. Volume of data (number of rows) will generally be under 15,000.
6. Data must be sortable based on on predefined criteria - not by clicking on column headers (in fact, there are no column headers).

We have considered using data grid, embedded HTML or use of a third party control. Any input would be helpful, including links to performance tests.
Jan 29 '09 #1
1 2038
vekipeki
229 Recognized Expert New Member
There is a DataGridView.Vi rtualMode
in DataGridView which can be used to pass only the displayed cells to the DataGridView. In that case, you are not binding to data, but rather handling the paint event of each cell individually.

We used it for large tables, with many rows/columns, and you really get your table drawn instantly. The downside is that you lose the data-binding benefits, and have to implement some sort of custom caching:

Here are some links:
Best Practices for Scaling the Windows Forms DataGridView Control
Implementing Virtual Mode with Just-In-Time Data Loading
Jan 30 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
2565
by: kelvSYC | last post by:
Say I have a really long list (more than 100 items, say). Because of the enormous vertical space it takes up, I decide to present them in a a way that I put five list items in a line (ie. the sixth item appears under the first, seventh under the second, and so on). However, I can't think of a way to do this with a minimal amount of XHTML. So far, I've used divs to simulate layout-tables, but I believe a more elegant and flexible...
7
9545
by: Maxim Shemanarev | last post by:
I'd like to announce my project called Anti-Grain Geometry. http://www.antigrain.com Anti-Grain Geometry (AGG) is an Open Source, free of charge graphic library, written in industrially standard C++. The terms and conditions of use are very simple and described on the License page. AGG doesn't depend on any graphic API or technology. Basically, you can think of AGG as of a rendering engine that produces pixel images in memory from
2
3265
by: Spotnick | last post by:
I have no idea why, but since I'm trying to recreate my website using ASP.NET 2.0 I've encountered so many performance issues that I'm about to give up and continue using v1.1 Seriously, how can a page that is not that complicated be so long to render locally, it's amazing. This is the trace info: aspx.page Begin PreInit
0
1383
by: Jeff Morgan | last post by:
I have an application that runs on ASP.NET. We have been working through performance testing and it appears that at about 40-50 users, I start to get CPU bound. The application is a three form, ASP.NET 2.0 application. A login page, and a main page, that is a frame with a header page, and the main page. On the main page, there are two datagrids that pull data from a database. The problem is that on one of the grids, the amount of rows...
3
1387
by: AndyHolyer | last post by:
In all my years of hacking HTML I've never seen this happen before: I'm writing a small part of a site in Mason which implements a calendar and booking system. Bookings can be of various lengths, and a day is implemented as a table, with each row signifying a a 15-minute period. To test the system I decided to make a 9:00-17:00 booking. This will produce a cell with a rowspan of 32.
3
2205
by: UJ | last post by:
I had somebody (who was an idiot) tell me that tables are slow in rendering? That you shouldn't do things like tables inside of tables. Is that true? I think she didn't know what she was talking about but I just wanted to confirm with people. TIA - J.
3
2200
by: lucky | last post by:
Hi guys, i want to write some data in tabular format in text file. i've data in strings and i want to write like this in file col1 col2 col3 d1 d1 d1 d2 d2 d2 d3 d3 d3
38
3316
by: Sanders Kaufman | last post by:
I'm converting my table-based layouts to css-positioned divs - but the ONLY reason I'm doing it is because it's *considered* a best practice. I don't really see where anything goes hinky when tables are used - but I'm doing it anyway because the HTML and CSS specs says to reserve tables for tabular data. So as I convert my login widgit to a css thing, I'm saying to myself - hey, this form is most certainly "tabular data" - even if it...
5
2305
by: Lars Eighner | last post by:
Is a calendar tabular data, logically meriting table markup? -- Lars Eighner <http://larseighner.com/ <http://myspace.com/larseighner> Countdown: 465 days to go. What do you do when you're debranded?
0
9605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10651
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10393
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10405
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9208
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7671
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6893
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4342
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3871
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.