How do I enumerate all columns in a DataViewRow?

[Bill]

This generates a compile error:

private void BuildFTPRec(DataRowView a)
{
foreach (DataColumn dc in a)
{
Console.WriteLine(r.ToString());
}
}

The error is as follows:

"foreach statement cannot operate on variables of type
'System.Data.DataRowView' because 'System.Data.DataRowView' does not contain
a definition for 'GetEnumerator', or it is inaccessible"

 

[William Ryan eMVP]

I don't know of an enumerator for that piece of it. I think you are going
to have to look at the columns collectino of the table the view is based on
and then walk through it using an index

for(int i = 0; i < dataView.Table.Column.Count; i++){
Console.WriteLine(dataRowView);
}

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp

 

[David Sceppa]

Bill,

The DataRowView allows you to reference the DataRow. From there,
reference the Table, and its Columns collection:

foreach (DataColumn col in MyDataRowView.Row.Table.Columns)

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.