Bonjour,
j'ai un problème avec une requête le code :


Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
 
 command.Parameters.Add(new SqlParameter("@ID_project", SqlDbType.NVarChar, 50));
 
            command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_0", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_1", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_2", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@Duration_Estimate_PH_3", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@Duration_Estimate_at_Completion", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@ETM_PH_0_", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@ETM_PH_1_", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@ETM_PH_2_", SqlDbType.Float));
            command.Parameters.Add(new SqlParameter("@ETM_PH_3_", SqlDbType.Float));
 
 
            command.Parameters["@ID_project"].Value = textBox_project_name.Text;
            command.Parameters["@Duration_Estimate_PH_0"].Value = textBox_Duration_Estimate_PH_0.Text;
            command.Parameters["@Duration_Estimate_PH_1"].Value = textBox_Duration_Estimate_PH_1.Text;
            command.Parameters["@Duration_Estimate_PH_2"].Value = textBox_Duration_Estimate_PH_2.Text;
            command.Parameters["@Duration_Estimate_PH_3"].Value = textBox_Duration_Estimate_PH_3.Text;
            command.Parameters["@Duration_Estimate_at_Completion"].Value = textBox_Duration_Dstimate_at_Completion.Text;
            command.Parameters["@ETM_PH_0_"].Value = textBox_ETM_Phase_0.Text;
            command.Parameters["@ETM_PH_1_"].Value = textBox_ETM_Phase_1.Text;
            command.Parameters["@ETM_PH_2_"].Value = textBox_ETM_Phase_2.Text;
            command.Parameters["@ETM_PH_3_"].Value = textBox_ETM_Phase_3.Text;
 
            Convert.ToDouble(textBox_Duration_Estimate_PH_0.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_Duration_Estimate_PH_1.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_Duration_Estimate_PH_2.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_Duration_Estimate_PH_3.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_Duration_Dstimate_at_Completion.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_ETM_Phase_0.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_ETM_Phase_1.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_ETM_Phase_2.Text, CultureInfo.InvariantCulture);
            Convert.ToDouble(textBox_ETM_Phase_3.Text, CultureInfo.InvariantCulture);
 
             command.ExecuteNonQuery();
le message d'erreur est le suivant :

Input string was not in a correct format : Convert.ToDouble(textBox_Duration_Estimate_PH_0.Text, CultureInfo.InvariantCulture);

merci