How to display the selected line of the datagridview

Question

When I click on the show button I display the information after when I click on a line in the datagridview the information will be displayed in the textbox combobox and datetime picker The problem is in the combobox of the marche because I wear id_marche (int) table walking and I filled the combobox by libelle_ marche (string) the so when I click on the datagrid view it shows me id walks in the combobox marche

Nilesh Shah · Answer

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

ma ouml · Answer

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

ma ouml · Answer

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_marcheDesignation_bon_receptionNum_bon_receptionDate_receptionUniteQtePrix_unitaireMontantTVAMOOTUser_createDate_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_marchem.Libelle_marchebr.Designation_bon_receptionbr.Num_bon_receptionbr.Date_receptionbr.Unitebr.Qtebr.Prix_unitairebr.Montantbr.MObr.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