How to get columns value from DataRow while DataTable Looping

[Kelvin]

Hi All,

How to get column value from datarow while datatable looping ?

Please advised !

 

[deko]

How to get column value from datarow while datatable looping ?

Not sure if this is what you're looking for, but I've used this:

foreach (DataTable t in myDataSet.Tables)
{
foreach (DataRow r in t.Rows)
{
foreach (DataColumn c in t.Columns)
{
if (r[c] != null)
{
Console.WriteLine(r[c]);
}
}
}
}