Question

How to create and print DataTable in C#

Answer 1

using System.Data;

namespace WinFormsApp1
{
    public partial class Form1 : Form
    {
        DataTable dt = new DataTable();
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            dt.Columns.Add("ID", typeof(int));
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Age", typeof(int));

            dt.Rows.Add(134, "Oliver", 40);
            dt.Rows.Add(265, "Luna", 38);
            dt.Rows.Add(387, "Hazel", 51);

            label1.Text = "";

            foreach (DataRow dataRow in dt.Rows)
            {
                foreach (var item in dataRow.ItemArray)
                {
                    label1.Text += item + " ";
                }
                label1.Text += Environment.NewLine;
            }
        }
    }
}



/*
 * run:
 *
 * 134 Oliver 40 
 * 265 Luna 38
 * 387 Hazel 51
 * 
 */

 

70+ SQL courses for beginners and professionals