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

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 < 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  DataRow row in dt Rows                  foreach  DataColumn col in dt Columns             Console WriteLine row col

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  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