Looping through a DataTable

Question

Well  I have a DataTable with multiple columns and multiple rows   I want to loop through the DataTable dynamically basically the output should look as follows excluding the braces    Name  DataColumn  Tom   DataRow  Peter  DataRow   Surname  DataColumn  Smith  DataRow  Brown  DataRow   foreach  DataColumn col in rightsTable Columns         foreach  DataRow row in rightsTable Rows                     output                           I typed that out and noticed this would not work  Can someone please advice on a better way of doing this

User · Answer

Please try the following code below     Here I am using a reader object to fetch data from database  along with sqlcommand onject  cmd     Once the data is loaded to the Datatable object  datatable  you can loop through it using the datatable rows count prop   using  reader   cmd ExecuteReader         Load the Data table object   dataTable Load reader     if  dataTable Rows Count  gt  0          DataColumn col   dataTable Columns  YourColumnName          foreach  DataRow row in dataTable Rows                                                  strJsonData   row col  ToString

User · Answer

foreach  DataRow row in dt Rows                  foreach  DataColumn col in dt Columns             Console WriteLine row col

User · Answer

If you want to change the contents of each and every cell in a datatable then we need to Create another Datatable and bind it as follows using  Import Row   If we don t create another table it will throw an Exception saying  Collection was Modified    Consider the following code     New Datatable created which will have updated cells DataTable dtUpdated   new DataTable       This gives similar schema to the new datatable dtUpdated   dtReports Clone    foreach  DataRow row in dtReports Rows        for  int i   0  i  lt  dtReports Columns Count  i                  string oldVal   row i  ToString            string newVal       oldVal          row i    newVal            dtUpdated ImportRow row        This will have all the cells preceding with Paranthesis

User · Answer

foreach  DataColumn col in rightsTable Columns         foreach  DataRow row in rightsTable Rows                   Console WriteLine row col ColumnName  ToString

[c#] Looping through a DataTable

Examples related to c#

Examples related to datatable

Examples related to dataset