C #: getting value from DataTable using PrimaryKey

Question

I have a problem with my C # code. I created a pair of DataTables with a primary key assigned to each of them. I want to get one row from one column.

Let's say I have this code:

DataColumn Pcolumn = new DataColumn();
DataColumn[] key = new DataColumn[1];

Pcolumn.DataType = System.Type.GetType("System.Double");

Pcolumn.ColumnName = "length";
key[0] = Pcolumn;


table6F.Columns.Add(Pcolumn);
table6F.Columns.Add("Area", typeof(double));
table6F.Columns.Add("load", typeof(double));
table6F.Columns.Add("weigth", typeof(double));

table6F.PrimaryKey = key;
table.Rows.Add(6.0, 14.0, 17.8 , 11.0 );
table.Rows.Add(7.0, 16.2 , 20.7 , 16.0 );

And I want to get a “load” for the second row (20.7), I would like to find the primary key column 7.0 in the table. I have been dummy tested to do this, just to check:

Object oV;
double load;

//Get an Table object given the specific row number, this dummy i always set to 0.
// Given Column
oV = table.Rows[0]["load"];
load = Convert.ToDouble(oV.ToString());

Is there a similar way to retrieve using the Primary Key?

Answer 1

You can get a row from a DataTable based on its primary key using DataRowCollection.Find . In your case, it will be:

DataRow matchingRow = table.Rows.Find(7.0D);
double value = (double)matchingRow["load"];

Answer 2

You can use the Find method to search for a string using the primary key.

DataRow row = dataTable.Rows.Find("your key");
if(null != row)
{
    string value = row["ColumnName"];
}