Comments by LSB71 (Top 14 by date)

Thank you so much,
I will work on the subject and improve my code ... thank you all.

How should I store them in my Sqlite database?

Hello,
Thank you,
Indeed it works in the yyyy-MM-dd format and not in the dd / MM / yyyy format.
So with the code below it works ...
and I modify in Datagriview like this:
Datagridview1.Columns [1] .DefaultCellStyle.Format = "dd / MM / yyyy";
and it's great!
Hide Copy Code
if (e.ColumnIndex == Datagridview1.Columns[1].Index)
{
if (e.Value != null)
{

e.Value = DateTime.Parse(e.Value.ToString()).ToUniversalTime();

}
}

Hello,
Not much choice alas!
Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:

NULL. The value is a NULL value.
INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number.
TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
BLOB. The value is a blob of data, stored exactly as it was input.
https://www.sqlite.org/datatype3.html
thank you

Excuse me, but I don't get the result I want.
The answer from (phil.o) gives me this for example.
Txt_total_P9_cmd.Text = string.Format("{0} €uros H.T.", Math.Round(Val, 2)); = 1254,8
I would like two digits after the decimal point like this (1254.80)
and like this :
Txt_total_P9_cmd.Text = Math.Round(Convert.ToString(Val), 2) + " €uros H.T";
I have the following error (impossible conversion from string to duplicate)

Hello,
Thank you, how should I declare them then?

Hello digimanus,
Thank you for your help,
I can not find the solution.
At first I would like to make it easier to understand the meaning.
For example :
(Statut LIKE ? + '%') AND (Email LIKE ? + '%') AND (Date_MES IS NULL OR Date_MES BETWEEN (date1 = Date_fin_MSTPE))";
For simplicity date1 = Date_fin_MSTPE
But I get an error
How to do ?

thank you so much

Can I attach an picture to support my question ?

Thank you very much, I take note of your remarks.