Data from database

[alessiob82]

Hi

I'm devellopping an application in c# that shows in a grid
(DataGridView???) the content of a database table (MySQL database).
This table can contain a lot of records (more then 100.000); this
records are written by another process.

1) What is the best way to mantain synchronized my grid and the real
content of table?
2) One column of my grid will be a button; the visibility of each
button depends from the value of a table field, how can I do it?
3) At the moment I'm developping with VisualStudio2005 .NET Framework
2.0, but I have the possibility to develop also with
VisualStudio2008 .NET Framework 3.5; there is a good reason to change
my environment?

Thank,
Alessio

 

[Ignacio Machin ( .NET/ C# MVP )]

Hi

I'm devellopping an application in c# that shows in a grid
(DataGridView???) the content of a database table (MySQL database).
This table can contain a lot of records (more then 100.000); this
records are  written by another process.

1) What is the best way to mantain synchronized my grid and the real
content of table?

You have to use a pagination mechanism. 100K records in one page is
too much.
I guess that the records are written @ the end, so you should be ok

2) One column of my grid will be a button; the visibility of each
button depends from the value of a table field, how can I do it?

use the ItemDataBound event. there you can hide/show the controls
based on the row

3) At the moment I'm developping with VisualStudio2005 .NET Framework
2.0, but I have the possibility to develop also with
VisualStudio2008 .NET Framework 3.5; there is a good reason to change
my environment?

It's irrelevant for this case