copy data from one datagridview to another if strings match

Question

I am importing data from excel to Datagridview1 and Datagridview2 which has columns of Group number, Member name

I want to copy the Group number from dataGridview2 to Datagridview1 if Member name is matching non case sensitive ignore characters like .,- and ect. something like .contains will be great

below are the codes that i already tried and after error/failed i converted them to comment

foreach (DataGridViewRow kk in datagridcorrect.Rows)

{

foreach (DataGridViewRow cell in Memnum.Rows)

{

//string corct;

//string memn;

//corct = kk.Cells[0].Value.ToString();

// memn = cell.Cells[0].Value.ToString();

// corct = Convert.ToString(kk.Cells[0].Value);

// memn = Convert.ToString(cell.Cells[0].Value);

//bool b;

// b = kk.Cells[0].Value.ToString().Contains(cell.Cells.ToString());

// if(mem.Equals(correct))

//if (object.Equals(kk.Cells[1].Value, cell.Cells[1].Value))

// if(b == true)

{

kk.Cells[0].Value = cell.Cells[0].Value;

}

}

}

I really worked alot on this any help will be highly appreciated!

thanks

Answer 1

Hi Ghamai Khuram

 

Copy Data Grid view rows to another u can use this code below, 

private DataGridView CopyDataGridView(DataGridView dgv_org)
{
    DataGridView dgv_copy = new DataGridView();
    try
    {
        if (dgv_copy.Columns.Count == 0)
        {
            foreach (DataGridViewColumn dgvc in dgv_org.Columns)
            {
                dgv_copy.Columns.Add(dgvc.Clone() as DataGridViewColumn);
            }
        }

        DataGridViewRow row = new DataGridViewRow();

        for (int i = 0; i < dgv_org.Rows.Count; i++)
        {
            row = (DataGridViewRow)dgv_org.Rows[i].Clone();
            int intColIndex = 0;
            foreach (DataGridViewCell cell in dgv_org.Rows[i].Cells)
            {
                row.Cells[intColIndex].Value = cell.Value;
                intColIndex++;
            }
            dgv_copy.Rows.Add(row);
        }
        dgv_copy.AllowUserToAddRows = false;
        dgv_copy.Refresh();

    }
    catch (Exception ex)
    {
        cf.ShowExceptionErrorMsg("Copy DataGridViw", ex);
    }
    return dgv_copy;
}

In order to copy selected rows   

private DataGridView CopyDataGridView(DataGridView dgv_org)
       {
           DataGridView dgv_copy = new DataGridView();
           try
           {
               if (dgv_copy.Columns.Count == 0)
               {
                   foreach (DataGridViewColumn dgvc in dgv_org.Columns)
                   {
                       dgv_copy.Columns.Add(dgvc.Clone() as DataGridViewColumn);
                   }
               }

               DataGridViewRow row = new DataGridViewRow();

               for (int i = 0; i < dgv_org.SelectedRows.Count; i++)
               {
                   row = (DataGridViewRow)dgv_org.SelectedRows[i].Clone();
                   int intColIndex = 0;
                   foreach (DataGridViewCell cell in dgv_org.SelectedRows[i].Cells)
                   {
                       row.Cells[intColIndex].Value = cell.Value;
                       intColIndex++;
                   }
                   dgv_copy.Rows.Add(row);
               }
               dgv_copy.AllowUserToAddRows = false;
               dgv_copy.Refresh();

           }
           catch (Exception ex)
           {
               System.Console.WriteLine(ex.ToString());

           }
           return dgv_copy;
       }

I Hope it will help you 

Answer 2

I Have not used DataGridView before but I hope this short discussion may helps: https://stackoverflow.com/questions/6336239/copy-datagridviews-rows-into-another-datagridview