Читање података помоћу DataReader-а

Подаци се могу једноставно читати из базе података помоћу DataReader-а.

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/retrieving-data-using-a-datareader

using System;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        SqlConnection con = new SqlConnection("Data Source=MAINFRAME\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");
        con.Open();
        SqlCommand command = new SqlCommand("Select LastName, FirstName from Employees", con);
        SqlDataReader dataReader = command.ExecuteReader();
        if (dataReader.HasRows)
            while (dataReader.Read())
                Console.WriteLine(dataReader.GetValue(0).ToString() + " " + dataReader.GetValue(1).ToString());
        else
            Console.WriteLine("Nema podataka");
        dataReader.Close();
        command.Dispose();
        con.Close();
    }
}

Метаподаци

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        SqlConnection con = new SqlConnection("Data Source=MAINFRAME\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");
        SqlCommand command = new SqlCommand("Select LastName from Employees", con);
        con.Open();
        SqlDataReader dataReader = command.ExecuteReader();
        DataTable schemaTable = dataReader.GetSchemaTable();
        foreach (DataRow row in schemaTable.Rows)
            foreach (DataColumn column in schemaTable.Columns)
                Console.WriteLine(String.Format(column.ColumnName + " = " + row[column]));
        command.Dispose();
        con.Close();
    }
}