Question

How to print the content of a DataTable in C#

Answer 1

using System;
using System.Data;

namespace ConsoleApplication_C_Sharp
{
    class Program
    {
        static void Main()
        {
            DataTable table = new DataTable();

            table.Columns.Add("ID", typeof(int));
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Salary", typeof(double));

            table.Rows.Add(123, "Ajax", 23492);
            table.Rows.Add(543, "Arrow", 31871);
            table.Rows.Add(876, "Axel", 16878);
            table.Rows.Add(342, "Everly", 46123);

            foreach (DataRow dataRow in table.Rows) {
                foreach (var item in dataRow.ItemArray) {
                    Console.Write("{0} ", item);
                }
                Console.WriteLine();
            }
        }
    }
}


/*
run:
   
123 Ajax 23492
543 Arrow 31871
876 Axel 16878
342 Everly 46123
 
*/

 

70+ SQL courses for beginners and professionals