Showing large data from file in GridView and customizing
cell style single/group
Hi all,
Microsoft Excel can't show large amount of tabular data for example > 1000*1000
I want to show larger tabular data and then like in excel formating their cells and save and load it.
but here mathematical calculations are not needed and just style should be save and load.
my idea is using data gridview
but there are some questions :
1. Can bind very large file to datagridview?! and then user doesn't feel borely when scroll on it( how much delay for loading data)?
2. Can assign styling format to each cell or grouping of cells alike excel for example font, forecolor, backcolor and borders?!
3. now can save and load it's display style?
Data are Integers ...
excuse me for poor english writing and please help me
Thnks
TAGS: Excel Simulator, Datagridview, style cells, large amount of data, format group of cells
mohammad namakiPosted Feb 5, 2011, 3:49 AM
it's a dataGridView!
of course it can be each Control that solve this requierment
Sam HobbsPosted Feb 4, 2011, 7:58 PM
When you use a DataGridView, you can use a UserControl for columns. You can create a custom UserControl that can do the formatting (styles) that you need for your application. Look for articles about UserControls.
Suthish NairPosted Feb 4, 2011, 2:34 PM
mohammad namakiPosted Feb 4, 2011, 11:57 AM
1 solution for that is: load 100*100 cells in data gridview from whole cells in dataTable and when user scrolling dataGridView then load remind of cells for his/her scrolling...
but there is problem! how can I found dataGridview scrolling?! this means what event done when user scroll datagridview?
and how can handle this event or this solution?!
Suthish NairPosted Feb 3, 2011, 12:15 PM
Loading of huge data will slow down your application so drastically. This will effect the performance of your application.
Better if you provide some search criterias, depends on user selection query the data and display.