DataGridview unbound data imported from excel

Hello,

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

if you want to compare exact string ,follow below code:

for (int intI = 0; intI < dGV2.Rows.Count; intI++)

{

for (int intJ = 0; intJ < dGV1.Rows.Count; intJ++)

{

if (dGV2.Rows[intI].Cells[0].Value.ToString().ToUpper().Trim() == dGV1.Rows[intJ].Cells[1].Value.ToString().ToUpper().Trim())

{

dGV2.Rows[intI].Cells[1].Value = dGV1.Rows[intJ].Cells[0].Value;

break;

}

And if you want to compare with contains string follow below coding:

for (int intI = 0; intI < dGV2.Rows.Count; intI++)

{

for (int intJ = 0; intJ < dGV1.Rows.Count; intJ++)

{

if (dGV2.Rows[intI].Cells[0].Value.ToString().ToUpper().Trim().Contains(dGV1.Rows[intJ].Cells[1].Value.ToString().ToUpper().Trim()))

{

dGV2.Rows[intI].Cells[1].Value = dGV1.Rows[intJ].Cells[0].Value;

break;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Kanimozhi Shivakumar8y ago
Accepted answer
if you want to compare exact string ,follow below code:

for (int intI = 0; intI < dGV2.Rows.Count; intI++)
{
for (int intJ = 0; intJ < dGV1.Rows.Count; intJ++)
{
if (dGV2.Rows[intI].Cells[0].Value.ToString().ToUpper().Trim() == dGV1.Rows[intJ].Cells[1].Value.ToString().ToUpper().Trim())
{
dGV2.Rows[intI].Cells[1].Value = dGV1.Rows[intJ].Cells[0].Value;
break;
}
}
}

And if you want to compare with contains string follow below coding:

for (int intI = 0; intI < dGV2.Rows.Count; intI++)
{
for (int intJ = 0; intJ < dGV1.Rows.Count; intJ++)
{
if (dGV2.Rows[intI].Cells[0].Value.ToString().ToUpper().Trim().Contains(dGV1.Rows[intJ].Cells[1].Value.ToString().ToUpper().Trim()))
{
dGV2.Rows[intI].Cells[1].Value = dGV1.Rows[intJ].Cells[0].Value;
break;
}
}
}