I garbaged sqlite and make use of a simple List<MyItem>...

Now, you may be able to launch the program and see the behavior :)

Hi Nicolas,

Yes, the file is there, but it will not load. I am getting this error message:

Error    1    Metadata file 'C:\Users\MikeS\Desktop\INFRAGISTICS ERROR\Superviseur\bin\Debug\System.Data.SQLite.dll' could not be found    C:\Users\MikeS\Desktop\INFRAGISTICS%20ERROR\Superviseur\CSC    Superviseur

I suspect that maybe this file has some dependencies that are not installed on my machine or something.

well the system.data.sqlite.dll is include in the bin\debug file so I guess you could easily readd it as a reference and check what is wrong.

You may have everything to challenge this situation !

Hi Nicolas, 

I am unable to run your sample because it's referencing an assembly I don't have: System.Data.SQLite

Can you remove this from the project and re-post it here? There's no reason why the same should need to access SQL. Since the data is irrelevant to the problem, maybe you could just replace the grid's DataSource with a DataTable or UltraDataSource created in memory.

Ok Mike

Here is my project... with only one screen...

To display the database, use menu "Display" => there is only one item inside

To print or export just use the item "print", "export" from the file menu.

In the config file, you have the connectionstring for the database

Anyway, in the archive menu, you have the ability to load an external database.

You can find one in the root folder of the archive.

To show data, pick a starting date (datetimepicker) at least 7/01/2014... (I haven't done test and record in the database today).

Normally, you have data with process column having "OK" value and some with "ERREUR" value which means "red" backcolor.

I hope this sample will help you in finding a solution to my problem...

I'm using SQLite database