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_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

How to display the selected line of the datagridview

hemu kumar shriwastaw

Sundar

hemu kumar shriwastaw

Sundar