C# Copy one Datagrid Row to another Row, Excel import

Question

Trying to copy one datagrid row to another row, below code copies a hard coded number to another row. I need to copy say cell 7 row to cell 10 row.

 private void btn_Adjust_Click(object sender, EventArgs e)

        

for (int i = 0; i < dataGridView1.RowCount; i++)
            {

                if (dataGridView1.Rows[i].Cells[18].Value.ToString() == "Yeshh")
            {
                dataGridView1.Rows[i].Cells[9].Value = "48";
                dataGridView1.Rows[i].Cells[8].Value = "45";



                    var value3 = dataGridView1.Rows[i].Cells[7].Value.ToString();
                    dataGridView1.Rows[i].Cells[10].Value = value3;
                    var K = value3;
                     dataGridView1.Rows[i].Cells[10].Value = K;

---

Booney440

Answer 1

Hi,

>> below code copies a hard coded number to another row

The code you provided is to copy one column of data to another column instead of the row.

>>I need to copy say cell 7 row to cell 10 row.

Try this:

    private void btn_Adjust_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < dataGridView1.ColumnCount; i++)
        {
            dataGridView1.Rows[9].Cells[i].Value = dataGridView1.Rows[6].Cells[i].Value;
        }
    }

Regards,

Stanly

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Stanly Fan

Thank You

---

Booney440