SQL insert query does not execute

Question

ERROR : La sous-requête a retourné plusieurs valeurs. Cela n'est pas autorisé quand la sous-requête suit =, !=, <, <= , >, >= ou quand elle est utilisée en tant qu'expression.

L'instruction a été arrêtée.

 

 voici la requete 

Program.cmd.CommandText = "insert into bon_reception_marche (Id_marche,Designation_bon_reception,Num_bon_reception,Date_reception,Unite,Qte,Prix_unitaire,Montant,TVA,MO,OT,User_create,Date_create)values((select distinct Id_marche from marche where Libelle_marche = '" + comboBox3.Text + "'),'" + textBox2.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Value.Date + "','" + textBox3.Text + "', " + Convert.ToDouble(textBox4.Text) + "," + Convert.ToDouble(textBox5.Text) + "," + Convert.ToDouble(textBox6.Text) + "," + Convert.ToDouble(comboBox1.Text) + ",'" + textBox8.Text + "','" + textBox9.Text + "','" + values.username + "','" + DateTime.Now.Date + "')";

thanks for adavance 

 

Answer 1

See my article Introduction to Web Site Scraping.

Answer 2

hi friend,

Please give more details about it how you want to read. if you want to read HTML file you can read it as XML file  programmatically and if you want to read it using like javascript then you can identify the table by giving it an id. and read the rows.

Please mark as answer if it helps.