How to display the selected line of the datagridview

l'erreu c'est dans la ligne du combobox 3

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace gestion_attachements_decomptes

{

public partial class bon_reception : Form

{

public bon_reception()

{

InitializeComponent();

}

private void bon_reception_Load(object sender, EventArgs e)

{

Program.cmd.CommandText = "select Libelle_marche from marche";

Program.dr = Program.cmd.ExecuteReader();

while (Program.dr.Read())

{

comboBox3.Items.Add(Program.dr.GetString(0));

}

Program.dr.Close();

dataGridView1.AllowUserToAddRows = false;

}

private void button4_Click(object sender, EventArgs e)

{

if (values.username != "admin")

{

button4.Enabled = false;

}

else

{

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 TOP 1 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 + "')";

Program.cmd.ExecuteNonQuery();

MessageBox.Show("c'est ajouté avec succés");

Program.cmd.Parameters.Clear();

label12.Text = "";

textBox1.Text = "";

textBox2.Text = "";

dateTimePicker1.Value = DateTime.Now.Date;

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

textBox6.Text = "";

textBox8.Text = "";

textBox9.Text = "";

comboBox1.Text = "";

}

}

private void button1_Click(object sender, EventArgs e)

{

if (values.username != "admin")

{

button1.Enabled = false;

}

else

{

Program.cmd.CommandText = "update bon_reception_marche set Id_marche =(select TOP 1 Id_marche from marche where Libelle_marche = '" + comboBox3.Text + "') ,Designation_bon_reception ='" + textBox2.Text + "',Num_bon_reception='" + textBox1.Text + "',Date_reception ='" + dateTimePicker1.Value.Date + "',Unite ='" + textBox3.Text + "',Qte= " + Convert.ToDouble(textBox4.Text) + ",Prix_unitaire=" + Convert.ToDouble(textBox5.Text) + ",Montant =" + Convert.ToDouble(textBox6.Text) + ",TVA =" + Convert.ToDouble(comboBox1.Text) + ",MO ='" + textBox8.Text + "',OT ='" + textBox9.Text + "' where Id_bon_reception_marche ="+label12.Text;

Program.cmd.ExecuteNonQuery();

MessageBox.Show("c'est modifié avec succés");

Program.cmd.Parameters.Clear();

label12.Text = "";

textBox1.Text = "";

textBox2.Text = "";

dateTimePicker1.Value= DateTime.Now.Date;

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

textBox6.Text = "";

textBox8.Text = "";

textBox9.Text = "";

comboBox1.Text = "";

}

}

private void button2_Click(object sender, EventArgs e)

{

if (values.username != "admin")

{

button2.Enabled = false;

}

else

{

Program.cmd.CommandText = "delete from bon_reception_marche where Id_bon_reception_marche =" + label12.Text;

Program.cmd.ExecuteNonQuery();

MessageBox.Show("c'est supprimé avec succés");

Program.cmd.Parameters.Clear();

label12.Text = "";

textBox1.Text = "";

textBox2.Text = "";

dateTimePicker1.Value = DateTime.Now.Date;

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

textBox6.Text = "";

textBox8.Text = "";

textBox9.Text = "";

comboBox1.Text = "";

}

}

private void button3_Click(object sender, EventArgs e)

{

Program.cmd.CommandText = "select br.Id_bon_reception_marche,m.Libelle_marche,br.Designation_bon_reception,br.Num_bon_reception,br.Date_reception,br.Unite,br.Qte,br.Prix_unitaire,br.Montant,br.MO,br.OT from bon_reception_marche br, marche m where m.Id_marche=br.Id_marche";

Program.dr = Program.cmd.ExecuteReader();

DataTable dt = new DataTable();

dt.Load(Program.dr);

dataGridView1.DataSource = dt;

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

if (e.RowIndex >= 0)

{

DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];

label12.Text = row.Cells["Id_bon_reception_marche"].Value.ToString();

comboBox3.Text = row.Cells["Id_marche"].Value.ToString();

textBox1.Text = row.Cells["Num_bon_reception"].Value.ToString();

textBox2.Text = row.Cells["Designation_bon_reception"].Value.ToString();

dateTimePicker1.Value =DateTime.Parse( row.Cells["Date_reception"].Value.ToString());

textBox3.Text = row.Cells["Unite"].Value.ToString();

textBox4.Text = row.Cells["Qte"].Value.ToString();

textBox5.Text = row.Cells["Prix_unitaire"].Value.ToString();

textBox6.Text = row.Cells["Montant"].Value.ToString();

comboBox1.Text = row.Cells["TVA"].Value.ToString();

textBox8.Text = row.Cells["MO"].Value.ToString();

textBox9.Text = row.Cells["OT"].Value.ToString();

}

}

}

}

 

 

THANKS FOR U  

You need to explain your problem properly, your problem is not clear

 

Do you mean to display values in top textboxes, etc when user clicks on a record in grid?

 

Post your code as project rar or zip file