How to loop through DataRow[] to get the column name and value

[Sri13]

Hi
I have a DataTable and get selected values out of it in a DataRow collection. I have the code that I want to make it run. Not sure if this is the correct approach to store column names and value in memory for later use?

DataTable dt = ds.Tables["Employee"];
DataRow[] foundEmpRows = dt.Select("Dept = 10");
 
NameValueCollection nvEmp = new NameValueCollection();
foreach (DataRow dr in foundEmpRows)
{
  foreach (DataColumn dc in foundEmpRows)
  {
    nvEmp.Add(dc.ColumnName, dr[dc]);
  }
}                            
 

The statement in BOLD is giving error. How to access DataColumn from DataRow[] array?

[Sri13]

I was able to resolve it myself :)
I updated the inner loop to:

foreach (DataColumn dc in dr.Table.Columns) 
{ 
  nvEmp.Add(dc.ColumnName.ToString(), dr[dc].ToString()); 
}