Question

How to print specific row 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);

            DataRow dataRow = table.Rows[1];

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


/*
run:
   
543 Arrow 31871
 
*/

 

70+ SQL courses for beginners and professionals