Foreach loop on datatables within dataset

Raghu Mohan

Please see the following

DataSet ds = new DataSet("AB");

ds.ReadXml(reader);

DataTable dtProperty = ds.Tables["property"];

DataTable dtvalue = ds.Tables["value"];

Table table = GeneratingTable();

property table has : prop_id,label

value table has:value,prop_id

DataRow dr;

DataRow dr2;

for (int r = 0; r < dtProperty.Rows.Count; ++r)

{

dr = dtProperty.Rows[r];

dr2 = dtvalue.Rows[r];

}

Now I want the same result by looping through values table only but not property table. something looks like

foreach(prop_id in dtvalue)

{

getpropertyname(prop_id)

}

I know the logic but finding difficulty with code. Can someone help me on this? Please

Thanks

3 Replies

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

Francis Susaimichael11y ago
Accepted answer
Hope the below code solve your problem:

foreach (DataRow drProperty in dtProperty.Rows)
{
// Get the prop_id column value
string strPropColValue = Convert.ToString(drProperty["prop_id"]);
//form the filter condition
string strFilter = string.Concat("prop_id='", strPropColValue, "'");
// Select only the values matched with Prop_id from values table
DataRow[] arrValues = dtValues.Select(strFilter);
// Loop thru it
foreach (DataRow drValue in arrValues)
{
string strValueColValue = Convert.ToString(drProperty["value"]);
}
}

+1
Raghu Mohan11y ago
I am still finding it difficult ..because prop_id column name sits in property data table....
0
Francis Susaimichael11y ago
Hope that, you want to loop thru the datatable, using for each loop. If so, try the below code:

//Loop thru the rows
foreach(DataRow drValue in dtvalue.Rows)
{
// Get the prop_id column value
string strPropColValue = Convert.ToString(drValue["prop_id"]);
}

If you have any other clarification, let me know!
Hope this helps!
+1