How to foreach a column in a DataTable using C

Question

How do I loop through each column in a datarow using foreach  DataTable dtTable   new DataTable    MySQLProcessor DTTable mysqlCommand  out dtTable    foreach  DataRow dtRow in dtTable Rows          foreach DataColumn dc in dtRow

User · Answer

In LINQ you could do something like   foreach  var data in from DataRow row in dataTable Rows                      from DataColumn col in dataTable Columns                           where                               row col     null                           select row col            do something with data

User · Answer

You can do it like this   DataTable dt   new DataTable  MyTable     foreach  DataRow row in dt Rows        foreach  DataColumn column in dt Columns                if  row column     null     This will check the null values also  if you want to check                               Do whatever you want

User · Answer

You can check this out  Use foreach loop over a DataColumn provided with your DataTable    foreach DataColumn column in dtTable Columns             do here whatever you want to

User · Answer

Something like this      DataTable dt   new DataTable         For each row  print the values of each column      foreach DataRow row in dt  Rows                foreach DataColumn column in dt  Columns                        Console WriteLine row column                      http   msdn microsoft com en-us library system data datatable rows aspx

User · Answer

I believe this is what you want   DataTable dtTable   new DataTable    foreach  DataRow dtRow in dtTable Rows        foreach  DataColumn dc in dtRow ItemArray

User · Answer

This should work   DataTable dtTable   MySQLProcessor DTTable mysqlCommand  out dtTable       On all tables  rows foreach  DataRow dtRow in dtTable Rows           On all tables  columns     foreach DataColumn dc in dtTable Columns              var field1   dtRow dc  ToString

User · Answer

int countRow   dt Rows Count  int countCol   dt Columns Count   for  int iCol   0  iCol  lt  countCol  iCol           DataColumn col   dt Columns iCol         for  int iRow   0  iRow  lt  countRow  iRow                    object cell   dt Rows iRow  ItemArray iCol

[c#] How to 'foreach' a column in a DataTable using C#?

Examples related to c#

Examples related to foreach