C# convert DataTable to dynamic object | C# Online Compiler

C# convert DataTable to dynamic object by John Kirwin

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Data;
using System.Dynamic;
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;
using System.Diagnostics;


namespace DataReaderDebugUtilities
{
    public class Program
    {
        public static void Main()
        {
			try
			{
				Debug Debug = new Debug();
				DataTable dt = new DataTable();
				dt = DataTableCreate("ProductId", "ProductName", "UnitPrice", "UnitsInStock");
				DataTableAddRow(ref dt, "1001", "John One", "15.50", "5");
				DataTableAddRow(ref dt, "1002", "Jill Two", "10.75", "10");
				DataTableAddRow(ref dt, "1003", "Tim Three", "5.25", "15");
				DataTableAddRow(ref dt, "1004", "Jane Four", "15.50", "5");
				DataTableAddRow(ref dt, "1005", "Greg Five", "10.75", "10");
				DataTableAddRow(ref dt, "1006", "Mike Six", "5.25", "15");
				DataTableAddRow(ref dt, "1007", "Ellen Seven", "12.50", "5");
				DataTableAddRow(ref dt, "1008", "Skip Eight", "10.75", "10");
				DataTableAddRow(ref dt, "1009", "Tom Nine", "8.25", "8");
				DataTableAddRow(ref dt, "1010", "Ann Ten", "4.25", "6");
				DataTableAddRow(ref dt, "1011", "Walt Eleven", "7.95", "4");
				DataTableAddRow(ref dt, "1012", "Meg Twelve", "13.25", "2");

				var dynamicList = new List<dynamic>();
				foreach (DataRow row in dt.Rows)
				{
					dynamic dynamicObject = new ExpandoObject();
					IDictionary<string, object> dictionary = dynamicObject;
					foreach (DataColumn column in dt.Columns)
					{
						dictionary[column.ColumnName] = row[column];
					}
					dynamicList.Add(dynamicObject);
				}

				foreach (dynamic row in dynamicList)
				{
					//DebugWriteObject(row, "row"); // json
					Console.WriteLine($"ProductId: {row.ProductId}, Product Name: {row.ProductName}, Unit Price: {row.UnitPrice}, UnitsInStock: {row.UnitsInStock}");
				}
			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.Message);
				Console.WriteLine(ex.StackTrace);

			}
        }

		// #region Debugging DataTable Helpers
        public static void DataTableListRowsAndColumns(ref DataTable dt)
        {
            using (DataTableReader rdr = dt.CreateDataReader())
            {
                Int32 _Count = 0;
                while (rdr.Read())
                {
                    for (int i = 0; i <= rdr.FieldCount - 1; i++)
                        Debug.WriteLine(string.Format("({0},{1}) - {2}: {3}", (_Count + 1).ToString(), (i + 1).ToString(), rdr.GetName(i), rdr[i].ToString()));
                    _Count += 1;
                }
            }
            Debug.WriteLine(Constants.vbCrLf);
        }

        public static void DataTableAddRow(ref DataTable dt, string c1, string c2 = "", string c3 = "", string c4 = "", string c5 = "", string c6 = "", string c7 = "", string c8 = "", string c9 = "", string c10 = "", string c11 = "", string c12 = "", string c13 = "", string c14 = "", string c15 = "", string c16 = "", string c17 = "", string c18 = "", string c19 = "", string c20 = "", string c21 = "", string c22 = "", string c23 = "", string c24 = "", string c25 = "", string c26 = "", string c27 = "", string c28 = "", string c29 = "", string c30 = "")
        {
            Int32 cnt = dt.Columns.Count;
            if (cnt < 1)
                return;
            else if (cnt == 1)
            {
                dt.Rows.Add(c1);
                return;
            }
            else if (cnt == 2)
            {
                dt.Rows.Add(c1, c2);
                return;
            }
            else if (cnt == 3)
            {
                dt.Rows.Add(c1, c2, c3);
                return;
            }
            else if (cnt == 4)
            {
                dt.Rows.Add(c1, c2, c3, c4);
                return;
            }
            else if (cnt == 5)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5);
                return;
            }
            else if (cnt == 6)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6);
                return;
            }
            else if (cnt == 7)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7);
                return;
            }
            else if (cnt == 8)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8);
                return;
            }
            else if (cnt == 9)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9);
                return;
            }
            else if (cnt == 10)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10);
                return;
            }
            else if (cnt == 11)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11);
                return;
            }
            else if (cnt == 12)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12);
                return;
            }
            else if (cnt == 13)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13);
                return;
            }
            else if (cnt == 14)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14);
                return;
            }
            else if (cnt == 15)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15);
                return;
            }
            else if (cnt == 16)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16);
                return;
            }
            else if (cnt == 17)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17);
                return;
            }
            else if (cnt == 18)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18);
                return;
            }
            else if (cnt == 19)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19);
                return;
            }
            else if (cnt == 20)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20);
                return;
            }
            else if (cnt == 21)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21);
                return;
            }
            else if (cnt == 22)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22);
                return;
            }
            else if (cnt == 23)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23);
                return;
            }
            else if (cnt == 24)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24);
                return;
            }
            else if (cnt == 25)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25);
                return;
            }
            else if (cnt == 26)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26);
                return;
            }
            else if (cnt == 27)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27);
                return;
            }
            else if (cnt == 28)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28);
                return;
            }
            else if (cnt == 29)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29);
                return;
            }
            else if (cnt == 30)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30);
                return;
            }
        }

        public static DataTable DataTableCreate(string c1, string c2 = "", string c3 = "", string c4 = "", string c5 = "", string c6 = "", string c7 = "", string c8 = "", string c9 = "", string c10 = "", string c11 = "", string c12 = "", string c13 = "", string c14 = "", string c15 = "", string c16 = "", string c17 = "", string c18 = "", string c19 = "", string c20 = "", string c21 = "", string c22 = "", string c23 = "", string c24 = "", string c25 = "", string c26 = "", string c27 = "", string c28 = "", string c29 = "", string c30 = "")
        {
            DataTable dt = new DataTable();
            if (string.IsNullOrEmpty(c2))
                dt.Columns.Add(c1, typeof(string));
            else if (string.IsNullOrEmpty(c3))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
            }
            else if (string.IsNullOrEmpty(c4))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
            }
            else if (string.IsNullOrEmpty(c5))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
            }
            else if (string.IsNullOrEmpty(c6))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
            }
            else if (string.IsNullOrEmpty(c7))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
            }
            else if (string.IsNullOrEmpty(c8))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
            }
            else if (string.IsNullOrEmpty(c9))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
            }
            else if (string.IsNullOrEmpty(c10))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
            }
            else if (string.IsNullOrEmpty(c11))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
            }
            else if (string.IsNullOrEmpty(c12))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
            }
            else if (string.IsNullOrEmpty(c13))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
            }
            else if (string.IsNullOrEmpty(c14))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
            }
            else if (string.IsNullOrEmpty(c15))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c16))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c17))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c18))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c19))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c20))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
            }
            else if (string.IsNullOrEmpty(c21))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
            }
            else if (string.IsNullOrEmpty(c22))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
            }
            else if (string.IsNullOrEmpty(c23))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
            }
            else if (string.IsNullOrEmpty(c24))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
            }
            else if (string.IsNullOrEmpty(c25))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
            }
            else if (string.IsNullOrEmpty(c26))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
            }
            else if (string.IsNullOrEmpty(c27))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
            }
            else if (string.IsNullOrEmpty(c28))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
            }
            else if (string.IsNullOrEmpty(c29))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
                dt.Columns.Add(c29, typeof(string));
            }
            else
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
                dt.Columns.Add(c29, typeof(string));
                dt.Columns.Add(c30, typeof(string));
            }
            return dt;
        }

		// #region Debugging Helpers
        public static void DebugWriteNameValueSeparatedLine(string name, string val)
        {
            if (!string.IsNullOrEmpty(val))
            {
                DebugWriteLine(string.Concat("-- ", name, " -------------------------------------------------------"));
                DebugWriteLine(val);
                DebugWriteLine("--  -------------------------------------------------------------");
            }
        }

		// 
        public static void DebugWriteLine(string str)
        {
            Debug.WriteLine(str);
        }
		
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-string</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, string> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);

        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-int</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, int> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);

        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-object</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, object> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);

        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(Dictionary<string, string> dictionary)
        {
            foreach (KeyValuePair<string, string> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {0}, Value = {1}", kvp.Key, kvp.Value));
            }
        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-int</param>
        public void DebugWriteDictionary(Dictionary<string, int> dictionary)
        {
            foreach (KeyValuePair<string, int> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {0}, Value = {1}", kvp.Key.ToString(), kvp.Value.ToString()));
            }
        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(Dictionary<string, object> dictionary)
        {
            foreach (KeyValuePair<string, object> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {0}", kvp.Key));
                DebugWriteObject(kvp.Value);
            }
        }

        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(List<string> listOfString, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteListOfString(listOfString);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);

        }

        /// <summary>Debug.WriteLine List Of String</summary>
        /// <param name="listOfString"></param>
        public void DebugWriteListOfString(List<string> listOfString)
        {
            listOfString.ForEach(i => Debug.WriteLine(string.Format("{0}\t", i)));
        }

        /// <summary>
        /// 	Debug.WriteLine object JSON.
        /// </summary>
        /// <param name="obj">object</param>
        /// <param name="desc">description</param>
        public static void DebugWriteObject(object obj, string desc)
        {
            if (string.IsNullOrEmpty(desc))
            {
                desc = $"Object: {obj.ToString()}";
            }
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteObject(obj);
            Debug.WriteLine("# ******** " + "End " + " **************  " + Environment.NewLine + Environment.NewLine);
        }

        /// <summary>
        /// 	Debug.WriteLine object JSON.
        /// </summary>
        /// <param name="obj">object</param>
        public static void DebugWriteObject(object obj)
        {
            Debug.WriteLine(JsonConvert.SerializeObject(obj, Formatting.Indented));
        }

        /// <summary>Debug Write Separated Line </summary>
        /// <param name="str">String to Debug.WriteLine</param>
        /// <param name="desc">description</param>
        public void DebugWriteSeparatedLine(string str, string desc)
        {
            if (!string.IsNullOrEmpty(str))
            {
                WriteLine(string.Concat("-- ", desc, " -------------------------------------------------------"));
                WriteLine(str);
                WriteLine("--  -------------------------------------------------------------");
            }
        }

        /// <summary>Debug Write Line </summary>
        /// <param name="str">String</param>
        public void WriteLine(string str)
        {
            Debug.WriteLine(str);
        }

        /// <summary>
        /// 	Debug.WriteLine MySqlDataReader to console and description.
        /// </summary>
        /// <param name="rdr">MySqlDataReader</param>
        /// <param name="desc">description</param>
        public void DebugWriteReader(MySqlDataReader rdr, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteReader(rdr);
            Debug.WriteLine("# ******** " + "End " + " **************  " + Environment.NewLine + Environment.NewLine);
        }


        /// <summary>Debug.WriteLine MySqlDataReader to console</summary>
        /// <param name="rdr">MySqlDataReader</param>
        public void DebugWriteReader(MySqlDataReader rdr)
        {
            try
            {
                if ((rdr.HasRows))
                {
                    DataTable dT = new DataTable();
                    dT.Load(rdr);
                    if (dT.Rows.Count > 0)
                    {
                        DebugWriteTableToConsole(dT);
                    }
                    else
                    {
                        Debug.WriteLine("No Rows");
                    }
                }
                else
                {
                    Debug.WriteLine("No Rows");
                }
            }
            catch (MySqlException sqlEx)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }

        /// <summary>Debug.WriteLine DataTable to console</summary>
        /// <param name="dt">DataTable</param>
        /// <param name="desc">description</param>
        public static void DebugWriteTableToConsole(DataTable dt, string desc = "")
        {
            try
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    string[] name = new string[dt.Columns.Count + 1 - 1 + 1];
                    int i = 0;

                    if (string.IsNullOrEmpty(desc))
                        DebugWriteNameValueSeparatedLine("", dt.TableName);
                    else
                        DebugWriteNameValueSeparatedLine("", desc);

                    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(string.Format("Rows.Count = {0}" + Constants.vbCrLf, dt.Rows.Count));
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
		
        /// <summary>Debug.WriteLine DataTable to console</summary>
        /// <param name="dt">DataTable</param>
        public void DebugWriteTableToConsole(DataTable dt)
        {
            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)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }


		/// <summary>Debug.WriteLine DataTable Column Names to console</summary>
		/// <param name="dt">DataTable</param>
		public void DebugWriteTableColumnNamesToConsole(DataTable dt)
		{
			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));
				}
			}
			catch (MySqlException sqlEx)
			{
				Debug.WriteLine(sqlEx.Message);
			}
			catch (Exception ex)
			{
				Debug.WriteLine(ex.Message);
			}
		}

        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        /// <param name="desc">description</param>
        public void DebugWriteDataRowToConsole(DataRow row, string desc)
		{
			if (!string.IsNullOrEmpty(desc))
			{
				DebugWriteSeparatedLine(desc, "");
				DebugWriteDataRowToConsole(row);
			}
			else
			{
				DebugWriteDataRowToConsole(row);
			}

		}


		/// <summary>Debug.WriteLine DataRow to console</summary>
		/// <param name="row">DataRow</param>
		public void DebugWriteDataRowToConsole(DataRow row)
		{
			try
			{
				Debug.WriteLine("| " + string.Join(" | ", row.ItemArray) + " |");
			}
			catch (MySqlException sqlEx)
			{
				Debug.WriteLine(sqlEx.Message);
			}
			catch (Exception ex)
			{
				Debug.WriteLine(ex.Message);
			}
		}


        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
 		/// <param name="desc">description</param>
        public void DebugWriteDataRowListedToConsole(DataRow row, string desc)
		{
			if (!string.IsNullOrEmpty(desc))
			{
				DebugWriteSeparatedLine(desc, "");
				DebugWriteDataRowListedToConsole(row);
			}
			else
			{
				DebugWriteDataRowListedToConsole(row);
			}

		}


        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        public void DebugWriteDataRowListedToConsole(DataRow row)
		{
			try
			{
				foreach (var item in row.ItemArray)
				{
					if (item is int)
					{
						Debug.WriteLine(string.Format("Int: {0}", item));
					}
					else if (item is string)
					{
						Debug.WriteLine(string.Format("String: {0}", item));
					}
					else if (item is DateTime)
					{
						Debug.WriteLine(string.Format("DateTime: {0}", item));
					}
				}

			}
			catch (MySqlException sqlEx)
			{
				Debug.WriteLine(sqlEx.Message);
			}
			catch (Exception ex)
			{
				Debug.WriteLine(ex.Message);
			}
		}

		// #endregion
	
    }

	
	
	
    public class Debug
    {
        public Debug()
        {
        }

        public static void WriteLine(string writeLine)
        {
            Console.WriteLine(writeLine);
        }
    }
}

​x
 
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Data;
using System.Dynamic;
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;
using System.Diagnostics;
​
​
namespace DataReaderDebugUtilities
{
    public class Program
    {
        public static void Main()
        {
            try
            {
                Debug Debug = new Debug();
                DataTable dt = new DataTable();
                dt = DataTableCreate("ProductId", "ProductName", "UnitPrice", "UnitsInStock");
                DataTableAddRow(ref dt, "1001", "John One", "15.50", "5");
                DataTableAddRow(ref dt, "1002", "Jill Two", "10.75", "10");
                DataTableAddRow(ref dt, "1003", "Tim Three", "5.25", "15");
                DataTableAddRow(ref dt, "1004", "Jane Four", "15.50", "5");
                DataTableAddRow(ref dt, "1005", "Greg Five", "10.75", "10");
                DataTableAddRow(ref dt, "1006", "Mike Six", "5.25", "15");
                DataTableAddRow(ref dt, "1007", "Ellen Seven", "12.50", "5");
                DataTableAddRow(ref dt, "1008", "Skip Eight", "10.75", "10");
                DataTableAddRow(ref dt, "1009", "Tom Nine", "8.25", "8");
                DataTableAddRow(ref dt, "1010", "Ann Ten", "4.25", "6");
                DataTableAddRow(ref dt, "1011", "Walt Eleven", "7.95", "4");
                DataTableAddRow(ref dt, "1012", "Meg Twelve", "13.25", "2");
​
                var dynamicList = new List<dynamic>();
                foreach (DataRow row in dt.Rows)
                {
                    dynamic dynamicObject = new ExpandoObject();
                    IDictionary<string, object> dictionary = dynamicObject;
                    foreach (DataColumn column in dt.Columns)
                    {
                        dictionary[column.ColumnName] = row[column];
                    }
                    dynamicList.Add(dynamicObject);
                }
​
                foreach (dynamic row in dynamicList)
                {
                    //DebugWriteObject(row, "row"); // json
                    Console.WriteLine($"ProductId: {row.ProductId}, Product Name: {row.ProductName}, Unit Price: {row.UnitPrice}, UnitsInStock: {row.UnitsInStock}");
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.WriteLine(ex.StackTrace);
​
            }
        }
​
        // #region Debugging DataTable Helpers
        public static void DataTableListRowsAndColumns(ref DataTable dt)
        {
            using (DataTableReader rdr = dt.CreateDataReader())
            {
                Int32 _Count = 0;
                while (rdr.Read())
                {
                    for (int i = 0; i <= rdr.FieldCount - 1; i++)
                        Debug.WriteLine(string.Format("({0},{1}) - {2}: {3}", (_Count + 1).ToString(), (i + 1).ToString(), rdr.GetName(i), rdr[i].ToString()));
                    _Count += 1;
                }
            }
            Debug.WriteLine(Constants.vbCrLf);
        }
​
        public static void DataTableAddRow(ref DataTable dt, string c1, string c2 = "", string c3 = "", string c4 = "", string c5 = "", string c6 = "", string c7 = "", string c8 = "", string c9 = "", string c10 = "", string c11 = "", string c12 = "", string c13 = "", string c14 = "", string c15 = "", string c16 = "", string c17 = "", string c18 = "", string c19 = "", string c20 = "", string c21 = "", string c22 = "", string c23 = "", string c24 = "", string c25 = "", string c26 = "", string c27 = "", string c28 = "", string c29 = "", string c30 = "")
        {
            Int32 cnt = dt.Columns.Count;
            if (cnt < 1)
                return;
            else if (cnt == 1)
            {
                dt.Rows.Add(c1);
                return;
            }
            else if (cnt == 2)
            {
                dt.Rows.Add(c1, c2);
                return;
            }
            else if (cnt == 3)
            {
                dt.Rows.Add(c1, c2, c3);
                return;
            }
            else if (cnt == 4)
            {
                dt.Rows.Add(c1, c2, c3, c4);
                return;
            }
            else if (cnt == 5)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5);
                return;
            }
            else if (cnt == 6)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6);
                return;
            }
            else if (cnt == 7)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7);
                return;
            }
            else if (cnt == 8)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8);
                return;
            }
            else if (cnt == 9)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9);
                return;
            }
            else if (cnt == 10)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10);
                return;
            }
            else if (cnt == 11)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11);
                return;
            }
            else if (cnt == 12)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12);
                return;
            }
            else if (cnt == 13)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13);
                return;
            }
            else if (cnt == 14)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14);
                return;
            }
            else if (cnt == 15)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15);
                return;
            }
            else if (cnt == 16)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16);
                return;
            }
            else if (cnt == 17)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17);
                return;
            }
            else if (cnt == 18)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18);
                return;
            }
            else if (cnt == 19)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19);
                return;
            }
            else if (cnt == 20)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20);
                return;
            }
            else if (cnt == 21)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21);
                return;
            }
            else if (cnt == 22)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22);
                return;
            }
            else if (cnt == 23)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23);
                return;
            }
            else if (cnt == 24)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24);
                return;
            }
            else if (cnt == 25)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25);
                return;
            }
            else if (cnt == 26)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26);
                return;
            }
            else if (cnt == 27)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27);
                return;
            }
            else if (cnt == 28)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28);
                return;
            }
            else if (cnt == 29)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29);
                return;
            }
            else if (cnt == 30)
            {
                dt.Rows.Add(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30);
                return;
            }
        }
​
        public static DataTable DataTableCreate(string c1, string c2 = "", string c3 = "", string c4 = "", string c5 = "", string c6 = "", string c7 = "", string c8 = "", string c9 = "", string c10 = "", string c11 = "", string c12 = "", string c13 = "", string c14 = "", string c15 = "", string c16 = "", string c17 = "", string c18 = "", string c19 = "", string c20 = "", string c21 = "", string c22 = "", string c23 = "", string c24 = "", string c25 = "", string c26 = "", string c27 = "", string c28 = "", string c29 = "", string c30 = "")
        {
            DataTable dt = new DataTable();
            if (string.IsNullOrEmpty(c2))
                dt.Columns.Add(c1, typeof(string));
            else if (string.IsNullOrEmpty(c3))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
            }
            else if (string.IsNullOrEmpty(c4))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
            }
            else if (string.IsNullOrEmpty(c5))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
            }
            else if (string.IsNullOrEmpty(c6))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
            }
            else if (string.IsNullOrEmpty(c7))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
            }
            else if (string.IsNullOrEmpty(c8))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
            }
            else if (string.IsNullOrEmpty(c9))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
            }
            else if (string.IsNullOrEmpty(c10))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
            }
            else if (string.IsNullOrEmpty(c11))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
            }
            else if (string.IsNullOrEmpty(c12))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
            }
            else if (string.IsNullOrEmpty(c13))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
            }
            else if (string.IsNullOrEmpty(c14))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
            }
            else if (string.IsNullOrEmpty(c15))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c16))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c17))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c18))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c19))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
            }
            else if (string.IsNullOrEmpty(c20))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
            }
            else if (string.IsNullOrEmpty(c21))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
            }
            else if (string.IsNullOrEmpty(c22))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
            }
            else if (string.IsNullOrEmpty(c23))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
            }
            else if (string.IsNullOrEmpty(c24))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
            }
            else if (string.IsNullOrEmpty(c25))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
            }
            else if (string.IsNullOrEmpty(c26))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
            }
            else if (string.IsNullOrEmpty(c27))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
            }
            else if (string.IsNullOrEmpty(c28))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
            }
            else if (string.IsNullOrEmpty(c29))
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
                dt.Columns.Add(c29, typeof(string));
            }
            else
            {
                dt.Columns.Add(c1, typeof(string));
                dt.Columns.Add(c2, typeof(string));
                dt.Columns.Add(c3, typeof(string));
                dt.Columns.Add(c4, typeof(string));
                dt.Columns.Add(c5, typeof(string));
                dt.Columns.Add(c6, typeof(string));
                dt.Columns.Add(c7, typeof(string));
                dt.Columns.Add(c8, typeof(string));
                dt.Columns.Add(c9, typeof(string));
                dt.Columns.Add(c10, typeof(string));
                dt.Columns.Add(c11, typeof(string));
                dt.Columns.Add(c12, typeof(string));
                dt.Columns.Add(c13, typeof(string));
                dt.Columns.Add(c14, typeof(string));
                dt.Columns.Add(c15, typeof(string));
                dt.Columns.Add(c16, typeof(string));
                dt.Columns.Add(c17, typeof(string));
                dt.Columns.Add(c18, typeof(string));
                dt.Columns.Add(c19, typeof(string));
                dt.Columns.Add(c20, typeof(string));
                dt.Columns.Add(c21, typeof(string));
                dt.Columns.Add(c22, typeof(string));
                dt.Columns.Add(c23, typeof(string));
                dt.Columns.Add(c24, typeof(string));
                dt.Columns.Add(c25, typeof(string));
                dt.Columns.Add(c26, typeof(string));
                dt.Columns.Add(c27, typeof(string));
                dt.Columns.Add(c28, typeof(string));
                dt.Columns.Add(c29, typeof(string));
                dt.Columns.Add(c30, typeof(string));
            }
            return dt;
        }
​
        // #region Debugging Helpers
        public static void DebugWriteNameValueSeparatedLine(string name, string val)
        {
            if (!string.IsNullOrEmpty(val))
            {
                DebugWriteLine(string.Concat("-- ", name, " -------------------------------------------------------"));
                DebugWriteLine(val);
                DebugWriteLine("--  -------------------------------------------------------------");
            }
        }
​
        // 
        public static void DebugWriteLine(string str)
        {
            Debug.WriteLine(str);
        }
        
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-string</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, string> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);
​
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-int</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, int> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);
​
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-object</param>
        /// <param name="desc">Description</param>
        public void DebugWriteDictionary(Dictionary<string, object> dictionary, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteDictionary(dictionary);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);
​
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(Dictionary<string, string> dictionary)
        {
            foreach (KeyValuePair<string, string> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {••0}••••••••••, Value = {••••••••1}••••••••", kvp.Key, kvp.Value));
            }
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary string-int</param>
        public void DebugWriteDictionary(Dictionary<string, int> dictionary)
        {
            foreach (KeyValuePair<string, int> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {••0}••••••••••, Value = {••••••••1}••••••••", kvp.Key.ToString(), kvp.Value.ToString()));
            }
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(Dictionary<string, object> dictionary)
        {
            foreach (KeyValuePair<string, object> kvp in dictionary)
            {
                Debug.WriteLine(string.Format("Key = {••0}••••••••", kvp.Key));
                DebugWriteObject(kvp.Value);
            }
        }
​
        /// <summary>Debug.WriteLine Dictionary to console</summary>
        /// <param name="dictionary">Dictionary</param>
        public void DebugWriteDictionary(List<string> listOfString, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteListOfString(listOfString);
            Debug.WriteLine("# ******** End **************  " + Environment.NewLine + Environment.NewLine);
​
        }
​
        /// <summary>Debug.WriteLine List Of String</summary>
        /// <param name="listOfString"></param>
        public void DebugWriteListOfString(List<string> listOfString)
        {
            listOfString.ForEach(i => Debug.WriteLine(string.Format("{0}\t", i)));
        }
​
        /// <summary>
        ///     Debug.WriteLine object JSON.
        /// </summary>
        /// <param name="obj">object</param>
        /// <param name="desc">description</param>
        public static void DebugWriteObject(object obj, string desc)
        {
            if (string.IsNullOrEmpty(desc))
            {
                desc = $"Object: {obj.ToString()}";
            }
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteObject(obj);
            Debug.WriteLine("# ******** " + "End " + " **************  " + Environment.NewLine + Environment.NewLine);
        }
​
        /// <summary>
        ///     Debug.WriteLine object JSON.
        /// </summary>
        /// <param name="obj">object</param>
        public static void DebugWriteObject(object obj)
        {
            Debug.WriteLine(JsonConvert.SerializeObject(obj, Formatting.Indented));
        }
​
        /// <summary>Debug Write Separated Line </summary>
        /// <param name="str">String to Debug.WriteLine</param>
        /// <param name="desc">description</param>
        public void DebugWriteSeparatedLine(string str, string desc)
        {
            if (!string.IsNullOrEmpty(str))
            {
                WriteLine(string.Concat("-- ", desc, " -------------------------------------------------------"));
                WriteLine(str);
                WriteLine("--  -------------------------------------------------------------");
            }
        }
​
        /// <summary>Debug Write Line </summary>
        /// <param name="str">String</param>
        public void WriteLine(string str)
        {
            Debug.WriteLine(str);
        }
​
        /// <summary>
        ///     Debug.WriteLine MySqlDataReader to console and description.
        /// </summary>
        /// <param name="rdr">MySqlDataReader</param>
        /// <param name="desc">description</param>
        public void DebugWriteReader(MySqlDataReader rdr, string desc)
        {
            Debug.WriteLine("# ******** " + desc + " **************  " + Environment.NewLine + Environment.NewLine);
            DebugWriteReader(rdr);
            Debug.WriteLine("# ******** " + "End " + " **************  " + Environment.NewLine + Environment.NewLine);
        }
​
​
        /// <summary>Debug.WriteLine MySqlDataReader to console</summary>
        /// <param name="rdr">MySqlDataReader</param>
        public void DebugWriteReader(MySqlDataReader rdr)
        {
            try
            {
                if ((rdr.HasRows))
                {
                    DataTable dT = new DataTable();
                    dT.Load(rdr);
                    if (dT.Rows.Count > 0)
                    {
                        DebugWriteTableToConsole(dT);
                    }
                    else
                    {
                        Debug.WriteLine("No Rows");
                    }
                }
                else
                {
                    Debug.WriteLine("No Rows");
                }
            }
            catch (MySqlException sqlEx)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
​
        /// <summary>Debug.WriteLine DataTable to console</summary>
        /// <param name="dt">DataTable</param>
        /// <param name="desc">description</param>
        public static void DebugWriteTableToConsole(DataTable dt, string desc = "")
        {
            try
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    string[] name = new string[dt.Columns.Count + 1 - 1 + 1];
                    int i = 0;
​
                    if (string.IsNullOrEmpty(desc))
                        DebugWriteNameValueSeparatedLine("", dt.TableName);
                    else
                        DebugWriteNameValueSeparatedLine("", desc);
​
                    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(string.Format("Rows.Count = {0}" + Constants.vbCrLf, dt.Rows.Count));
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
        
        /// <summary>Debug.WriteLine DataTable to console</summary>
        /// <param name="dt">DataTable</param>
        public void DebugWriteTableToConsole(DataTable dt)
        {
            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)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
​
​
        /// <summary>Debug.WriteLine DataTable Column Names to console</summary>
        /// <param name="dt">DataTable</param>
        public void DebugWriteTableColumnNamesToConsole(DataTable dt)
        {
            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));
                }
            }
            catch (MySqlException sqlEx)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
​
        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        /// <param name="desc">description</param>
        public void DebugWriteDataRowToConsole(DataRow row, string desc)
        {
            if (!string.IsNullOrEmpty(desc))
            {
                DebugWriteSeparatedLine(desc, "");
                DebugWriteDataRowToConsole(row);
            }
            else
            {
                DebugWriteDataRowToConsole(row);
            }
​
        }
​
​
        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        public void DebugWriteDataRowToConsole(DataRow row)
        {
            try
            {
                Debug.WriteLine("| " + string.Join(" | ", row.ItemArray) + " |");
            }
            catch (MySqlException sqlEx)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
​
​
        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        /// <param name="desc">description</param>
        public void DebugWriteDataRowListedToConsole(DataRow row, string desc)
        {
            if (!string.IsNullOrEmpty(desc))
            {
                DebugWriteSeparatedLine(desc, "");
                DebugWriteDataRowListedToConsole(row);
            }
            else
            {
                DebugWriteDataRowListedToConsole(row);
            }
​
        }
​
​
        /// <summary>Debug.WriteLine DataRow to console</summary>
        /// <param name="row">DataRow</param>
        public void DebugWriteDataRowListedToConsole(DataRow row)
        {
            try
            {
                foreach (var item in row.ItemArray)
                {
                    if (item is int)
                    {
                        Debug.WriteLine(string.Format("Int: {0}", item));
                    }
                    else if (item is string)
                    {
                        Debug.WriteLine(string.Format("String: {0}", item));
                    }
                    else if (item is DateTime)
                    {
                        Debug.WriteLine(string.Format("DateTime: {0}", item));
                    }
                }
​
            }
            catch (MySqlException sqlEx)
            {
                Debug.WriteLine(sqlEx.Message);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
        }
​
        // #endregion
    
    }
​
    
    
    
    public class Debug
    {
        public Debug()
        {
        }
​
        public static void WriteLine(string writeLine)
        {
            Console.WriteLine(writeLine);
        }
    }
}
​

View IL Code