probleme dans le codeRésolu

Question

J'ai un probleme dans mon code, j'ai cherché la solution en vain je vous mets le code aidez moi, il me met erreur: ORA-01036:numero/nom de variable interdit 
:
 OracleConnection connexion = new OracleConnection();
            connexion.ConnectionString = "User Id=YELIM;Password=koyeli;Data Source=localhost;";
               
            try
            {
                connexion.Open();
                string cmdQuer0 = "SELECT id_direction FROM direction where nom_direction='" + comboBox3.Text + "'";
                OracleCommand unite0 = new OracleCommand(cmdQuer0, connexion);
                OracleDataReader unite01 = unite0.ExecuteReader();
                if (unite01.Read())
                    id0 = unite01.GetInt32(0);
                string cmdQuer = "SELECT id_unite FROM unite where nom_unite='" + comboBox2.Text + "' AND id_direction='" + id0 + "'";
                OracleCommand unite = new OracleCommand(cmdQuer, connexion);
                OracleDataReader unite1 = unite.ExecuteReader();
                if (unite1.Read())
                    id = unite1.GetInt32(0);
                string cmdQuer1 = "SELECT id_grpe_equipement FROM grpe_equipement where nom='" + comboBox1.Text + "' AND id_direction='" + id0 + "' AND id_unite='" + id + "'";
                OracleCommand unite2 = new OracleCommand(cmdQuer1, connexion);
                OracleDataReader unite3 = unite2.ExecuteReader();
                if (unite3.Read())
                    id1 = unite3.GetInt32(0);
                string cmdQuer2 = "SELECT id_equipement FROM equipement where nom_equipement='" + comboBoxeqpmt.Text + "' AND id_direction='" + id0 + "' AND id_unite='" + id + "' AND id_grpe_equipement='"+id1+"'";
                OracleCommand unite4 = new OracleCommand(cmdQuer2, connexion);
                OracleDataReader unite5 = unite4.ExecuteReader();
                if (unite5.Read())
                    id2 = unite5.GetInt32(0);
              
                OracleCommand cmd = connexion.CreateCommand();
                cmd.CommandText = "INSERT INTO SOUS_EQUIPEMENT(NOM_SOUS_EQUIPEMENT,REFERENCE_SOUS_EQUIPEMENT,FABRICATION_SOUS_EQUIPEMENT,DATE_ACHAT_SOUS_EQUIPEMENT,INSTALLATION_SOUS_EQUIPEMENT,IMAGE_SOUS_EQUIPEMENT,ID_DIRECTION,ID_UNITE,ID_GRPE_EQUIPEMENT,ID_EQUIPEMENT) VALUES(1:,:2,:3,:4,:5,:6,:7,:8,:9,:10) ";
                OracleParameter parametre1 = new OracleParameter(":1", OracleType.VarChar, 100);
                OracleParameter parametre2 = new OracleParameter(":2", OracleType.VarChar, 100);
                OracleParameter parametre3 = new OracleParameter(":3", OracleType.DateTime );
                OracleParameter parametre4 = new OracleParameter(":4", OracleType.DateTime );
                OracleParameter parametre5 = new OracleParameter(":5", OracleType.DateTime );
                OracleParameter parametre6 = new OracleParameter(":6", OracleType.VarChar, 300);
                OracleParameter parametre7 = new OracleParameter(":7", OracleType.Number );
                OracleParameter parametre8 = new OracleParameter(":8", OracleType.Number );
                OracleParameter parametre9 = new OracleParameter(":9", OracleType.Number );
                OracleParameter parametre10 = new OracleParameter(":10", OracleType.Number);

                parametre1.Value = textBox2.Text;
                parametre2.Value = txtcode_sous_equipement .Text ;
                parametre3.Value = dateTimePicker1.Value.ToShortDateString();
              
                parametre4.Value = dateTimePicker3.Value.ToShortDateString ();
                parametre5.Value = dateTimePicker2.Value.ToShortDateString();
                parametre6.Value = textBox1.Text;
                parametre7.Value = id0;
                parametre7.Value = id;
                parametre7.Value = id1;
                parametre7.Value = id2;
              
                cmd.Parameters.Add(parametre1);
                cmd.Parameters.Add(parametre2);
                cmd.Parameters.Add(parametre3);
                cmd.Parameters.Add(parametre4);
                cmd.Parameters.Add(parametre5);
                cmd.Parameters.Add(parametre6);
                cmd.Parameters.Add(parametre7);
                cmd.Parameters.Add(parametre8);
                cmd.Parameters.Add(parametre9);
                cmd.Parameters.Add(parametre10);
                
                if (textBox2.Text != "" && txtcode_sous_equipement .Text !="" && textBox1.Text!="" )
                {
                    string message = "Désirez-vous enregistrer ces informations?";
                    string caption = "Enregistrement";
                    MessageBoxButtons buttons = MessageBoxButtons.YesNo;
                    DialogResult resultat;
                    resultat = MessageBox.Show(this, message, caption, buttons, MessageBoxIcon.Question);

                    if (resultat == DialogResult.Yes)
                    {
                        cmd.ExecuteNonQuery();

                    }

                    MessageBox.Show("Les informations ont été bien enrégistrées", "Merci");
                    textBox2.Text = "";
                    txtcode_sous_equipement.Text = "";
                    textBox1.Text = "";
                    comboBox3.Focus();
                    pictureBox2.Image = null;
                }
                
                else
                {
                    MessageBox.Show("Veuillez remplir le champs Nom,Reference et selectionnez une image valide, SVP", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                connexion.Dispose();
            }

sebmafate · Accepted Answer

dans la ligne : 
cmd.CommandText = "INSERT INTO
SOUS_EQUIPEMENT(NOM_SOUS_EQUIPEMENT,REFERENCE_SOUS_EQUIPEMENT,FABRICATION_SOUS_EQUIPEMENT,DATE_ACHAT_SOUS_EQUIPEMENT,INSTALLATION_SOUS_EQUIPEMENT,IMAGE_SOUS_EQUIPEMENT,ID_DIRECTION,ID_UNITE,ID_GRPE_EQUIPEMENT,ID_EQUIPEMENT)
VALUES(1:,:2,:3,:4,:5,:6,:7,:8,:9,:10) ";

y a une erreur...

Sébastien FERRAND (blog)
Consultant Sénior
[Microsoft Visual C# MVP]

yelima · Answer

Genial,mon pote.Tu ne sais pas j'ai passé trois jours à chercher l'erreur.Merci bcp

cs_coq · Answer

Salut, 

Au passage, autant passer les instructions SELECT du dessus en paramétré aussi.

/*
coq
MVP Visual C#
CoqBlog
*/

Probleme dans le code

3 réponses

Votre réponse

Discussions similaires