CODEWITHSUNDEEP
c#winformsdatagridviewdatatable
Dan Is Fiddling By Firelight
Dan Is Fiddling By Firelight

Reputation: 6061

How do I get a DataRow from a row in a DataGridView

I'm using a databound Windows Forms DataGridView. how do I go from a user selected row in the DataGridView to the DataRow of the DataTable that is its source?

Upvotes: 36

Views: 73381

Answers (5)

Meisam Rasouli
Meisam Rasouli

Reputation: 321

If you have assigned the a DataTable to the DataSource of a DataGridView object, you can access the DataRow associated with the DataGridView row using the DataBoundItem property.

System.Windows.Forms.DataGridViewRow dgvRow = this._mainDGV.SelectedRows[0];
    System.Windows.Forms.DataGridView dgv = (System.Windows.Forms.DataGridView)sender;
    if (dgvRow is not null)
    {
        if (dgvRow.DataBoundItem != null)
        {
            System.Data.DataRow row = ((System.Data.DataRowView)dgvRow.DataBoundItem).Row;
            if (row is not null)
            {
    
            }
        }
    }

However, DataBoundItem will have a null value, if you have created a new DataGridView row using the DataGridView's built-in functionality.

Upvotes: 0

Pallavi
Pallavi

Reputation: 584

In Visual Studio 2017 .NET 4.5, I had success with 

 var row = (DataRowView) e.Row.DataItem;

Upvotes: 0

Captain Comic
Captain Comic

Reputation: 16196

In a DataGridViewRow is a property called DataBoundItem of type object.

This will contain a DataRowView (for certainty you can check this)

Upvotes: 2

Lev Z
Lev Z

Reputation: 802

DataTable table = grdMyGrid.DataSource as DataTable;
DataRow row = table.NewRow();
row = ((DataRowView)grdMyGrid.SelectedRows[0].DataBoundItem).Row;

Upvotes: 11

Neil Barnwell
Neil Barnwell

Reputation: 42095

DataRow row = ((DataRowView)DataGridViewRow.DataBoundItem).Row

Assuming you've bound an ordinary DataTable.

MyTypedDataRow row = (MyTypedDataRow)((DataRowView)DataGridViewRow.DataBoundItem).Row

Assuming you've bound a typed datatable.

See the article on MSDN for more information.

Upvotes: 61

Related Questions