How to avoid duplicating when inserting both lines at once

Question

Hello friends first I will explain the state after I will give you my need I have a datagridview with a checkbox I check the lines after I click on the save button and normally the lines I check they will have to be inserted both in the other table but I find that just one line that was Insert twice The second problem is that I want the lines I inserted I want the most to see when I click on the search button because there are already assigned in the table You will find the two interfaces that process the state I hope I have described my condition well and thank you in advance

Amit Gupta · Answer

@ma ouml The code was written in a improper way and needs to be optimized when you work in a project otherwise it can create confusion and you cannot figure it out the exact problem. I am marking some of the code like Program.cmd.CommandText = select * from bon_reception_marche where Date_reception between ' + dateTimePicker1.Value.Date + ' and ' + dateTimePicker2.Value.Date + ' and Id_marche in (select TOP 1 Id_marche from marche where Num_marche = '+textBox1.Text+'); to be written as var query Select * from bon_reception_marche where Date_reception between (@start and @end) and Id_marche in (select TOP 1 Id_marche from marche where Num_marche = @num) ; SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue( @start  dateTimePicker1.Value.Date); cmd.Parameters.AddWithValue( @end  dateTimePicker2.Value.Date); cmd.Parameters.AddWithValue( @num  textbox1.Text); cmd.CommandText=query; cmd.Connection= your connection ; var dr= cmd.ExecuteReader(); ... optimize your code as the above so that it should be look clean and easy to maintain. Furthermore you need to debug your code and get the value appearing in the intellisense and try to execute in SSMS. If it was totally correct then use that query and build your project further. Hope it makes you understand :)

ma ouml · Answer

script search button private void button4_Click(object sender EventArgs e) { dataGridView2.Rows.Clear(); Program.cmd.CommandText = select * from bon_reception_marche where Date_reception between ' + dateTimePicker1.Value.Date + ' and ' + dateTimePicker2.Value.Date + ' and Id_marche in (select TOP 1 Id_marche from marche where Num_marche = '+textBox1.Text+'); Program.dr = Program.cmd.ExecuteReader(); while (Program.dr.Read()) { dataGridView2.Rows.Add(Program.dr[0]Program.dr[2] Program.dr[3] Program.dr[5] Program.dr[6] Program.dr[7] Program.dr[8] Program.dr[9] Program.dr[10] Program.dr[11] Program.dr[12]); } Program.dr.Close(); } script click datagridview private void dataGridView2_CellClick(object sender DataGridViewCellEventArgs e) { if (e.ColumnIndex == 11/*myColumn*/ && e.RowIndex >= 0 /*myRow*/) { button1.Enabled = true; } } script button save : private void button1_Click(object sender EventArgs e) { int colIndex = dataGridView2.Columns[CheckBox].Index; try { var rows = dataGridView2.Rows .Cast () .Where(row => row.Cells[colIndex].Value != null) .Where(row => (bool)row.Cells[colIndex].Value) .ToList(); foreach (DataGridViewRow row in rows) insertRowData(row); MessageBox.Show(c'est ajouté avec succés); } catch (FormatException) { MessageBox.Show(Only input numbers into the table! Only Numbers MessageBoxButtons.OK); } catch (Exception) { MessageBox.Show(There was an error while saving! Error MessageBoxButtons.OK); } } private void insertRowData(DataGridViewRow row) { double montantValue = Convert.ToDouble(row.Cells[Column7].Value); int id_br_value = Convert.ToInt32(row.Cells[Column11].Value); string check; if (checkBox1.Checked == true) { check = O; } else { check = N; } Program.cmd.Parameters.Clear(); Program.cmd.CommandText = insert into attachement_marche (Id_bon_reception_marcheId_marcheNum_attachementDate_debutDate_finFlag_dernierMontantUser_createDate_create) values (  + id_br_value + (select TOP 1 Id_marche from marche where Num_marche = ' + textBox1.Text + ')' + textBox3.Text + '' + dateTimePicker1.Value.Date + '' + dateTimePicker1.Value.Date + '' + check + ' + montantValue + ' + values.username + '' + DateTime.Now.Date + '); Program.cmd.ExecuteNonQuery(); }

Amit Gupta · Answer

By seeing only the interface it was too difficult to assume the problem. It might be problem in your insert query. You need to debug your code and find the problem. If still not got resolve then you need to share your code and point out the area.

ma ouml · Answer

Okay dear friend

Amit Gupta · Answer

Dear Friend As already stated it was a partial code and cannot be figure it out in an efficient way you need to debug your code and get the value appearing in the intellisense and try to execute in SSMS. If it was totally correct then use that query and build your project further.

ma ouml · Answer

You corrected me just the syntax but the need that I described you have not proposed to me any solution

ma ouml · Answer

OK thank you so much Mr

ma ouml · Answer

Amit Gupta Please is what you can tell me to solve this problem if you want to