using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.IO;

using System.Linq;

using System.Reflection;

using System.Text;

using System.Text.RegularExpressions;

using Newtonsoft.Json;

using Microsoft.VisualBasic;

using Devart.Data.MySql;

​

namespace Debugging

{

public class Debug

{

    public Debug(){}

    public void WriteLine(string writeLine)

    {

        Console.WriteLine(writeLine);

    }

}

public class Program

{

    public static void Main()

    {

        DataTable dt = getData();

        string Json = String.Empty;

        Debug Debug = new Debug();

​

        Debug.WriteLine("\nConvert DataTable to JSON using JSON.Net DLL (Newtonsoft).");

        Debug.WriteLine("-------------------------------------------------------------------------------"); 

        DebugWriteTableToConsole(dt);  

    }

​

    /// <summary>Debug.WriteLine DataTable to console</summary>

    /// <param name="dt">DataTable</param>

    public static void DebugWriteTableToConsole(DataTable dt)

    {

        Debug Debug = new Debug();

        try

        {

            if (dt != null && dt.Rows.Count > 0)

            {

                string[] name = new string[dt.Columns.Count + 1];

                int i = 0;

                foreach (DataColumn column in dt.Columns)

                {

                    name[i] = column.ColumnName;

                    i += 1;

                }

                Debug.WriteLine("|" + string.Join("|", name));

                foreach (DataRow row in dt.Rows)

                    Debug.WriteLine("| " + string.Join(" | ", row.ItemArray) + " |");

                Debug.WriteLine($"Rows.Count = {dt.Rows.Count.ToString()}");

            }

        }

        catch (MySqlException sqlEx)

        {

            Console.WriteLine(sqlEx.Message);

        }

        catch (Exception ex)

        {

            Console.WriteLine(ex.Message);

        }

    }

​

​

    public static DataTable getData()   

    {  

        DataTable dt = new DataTable();  

        dt.Columns.Add("UserId", typeof(Int32));  

        dt.Columns.Add("UserName", typeof(string));  

        dt.Columns.Add("Education", typeof(string));  

        dt.Columns.Add("Location", typeof(string));  

        dt.Rows.Add(1, "Satinder Singh", "Bsc Com Sci", "Mumbai");  

        dt.Rows.Add(2, "Amit Sarna", "Mstr Com Sci", "Mumbai");  

        dt.Rows.Add(3, "Andrea Ely", "Bsc Bio-Chemistry", "Queensland");  

        dt.Rows.Add(4, "Leslie Mac", "MSC", "Town-ville");  

        dt.Rows.Add(5, "Vaibhav Adhyapak", "MBA", "New Delhi");  

        return dt;  

    }  

}

}