Foreach loop on datatables within dataset

Question

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_idlabel value table has:valueprop_id DataRow dr; DataRow dr2; for (int r = 0; 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

Francis · 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]); } }

Francis · Answer

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!

Raghu Mohan · Answer

I am still finding it difficult ..because prop_id column name sits in property data table....