Question

How to print specific column in DataTable with C#

Answer 1

using System;
using System.Data;

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

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

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

            foreach (DataRow row in table.Rows) {
                Console.WriteLine(row.Field<string>(1));
            }
        }
    }
}


/*
run:
   
Ajax
Arrow
Axel
Everly
 
*/

 

70+ SQL courses for beginners and professionals