How to get the primary key column from a data row?

Question

In my code there is a data row. Is there a way to get the primary key from this or no? My code is:

var PK = data_row.PrimaryKey;

However, this I looked up in the MS docs and there is no PrimaryKey property if a data row, there is a property like that for the data table but I don't have the data table here.

Is this what you are looking for: https://stackoverflow.com/questions/95967/how-do-you-list-the-primary-key-of-a-sql-server-table — Michael Hurley, Aug 02 '18 at 18:23

score 6 · Accepted Answer · answered Aug 02 '18 at 18:24

6

You could try the following:

var PK = data_row.Table.PrimaryKey;

this gets the primary key column from the DataTable that the DataRow comes from.

answered Aug 02 '18 at 18:24

G. LC

794
1
8
27

Great to hear that – G. LC Aug 02 '18 at 18:40
2

`DataTable.PrimaryKey` returns a `DataColumn[]` - not a single `DataColumn`, because tables can have composite-keys - just FYI. – Dai May 21 '21 at 08:30

How to get the primary key column from a data row?

1 Answers1