How to find the row ID from datagridview, given a row value?

Question

Hi,

Can anyone help me please?

I have to find the row number from 1 selected array which I stored in one separate array and randomly I'm trying to get the row number from datagridview

http://serv8.enterupload.com/i/00246/aewglahmvpr5.jpg

In other words: if I know a column value for a given row in a datagridview (e.g. for this row, FirstName == 'Bud'), how can I get the row ID?

Answer 1

There's probably some easier way where you filter it in some way but at the moment I can only think of looping through it.

int rowIndex = -1;
foreach(DataGridViewRow row in DataGridView1.Rows)
{
    if(row.Cells(1).Value.ToString().Equals("mystr"))
    {
        rowIndex = row.Index;
        break;
    }
}
// rowIndex is now either the correct index or -1 if not found

Answer 2

You can use LINQ query:

        int index = -1;

        DataGridViewRow row = dgv.Rows
            .Cast<DataGridViewRow>()
            .Where(r => r.Cells[columnId].Value.ToString().Equals("Some string"))
            .First();

        index = row.Index;

Answer 3

From: http://www.vbforums.com/showthread.php?t=610134

Call the Find method of the BindingSource and it will return the index of the matching row if there is one. If there is, you index the BindingSource to get that row and update the appropriate fields. If there isn't, you call the AddNew method of the BindingSource to create a new row and set the appropriate fields.