using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;

namespace db01
{
    class Program
    {
        static string pripojovaci = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=\"D:\\Škola\\FJFI\\18BI - Business Inteligence\\Vyukova data\\AdventureWorks2012_Data.mdf\";Integrated Security=False;Connect Timeout=30";
        static string dotaz = "SELECT * from [Sales].[SalesOrderHeader]";
        static DataSet data = new DataSet();

        public static void vypis()
        {
            using(SqlConnection konexe = new SqlConnection())
            {
                konexe.ConnectionString = pripojovaci;
                SqlCommand prikaz = konexe.CreateCommand();
                prikaz.CommandText = dotaz;
                konexe.Open();
                SqlDataReader ctec = prikaz.ExecuteReader();
                while (ctec.Read())
                    System.Console.WriteLine(ctec["Comment"]);
            }
        }

        static void Main(string[] args)
        {
            //vypis();
            using (SqlConnection spoj = new SqlConnection(pripojovaci))
            {
                SqlDataAdapter adapter = new SqlDataAdapter(dotaz, spoj);
                adapter.Fill(data);
            }
            foreach (DataRow radek in data.Tables[0].Rows)
            {
                Console.WriteLine(radek["SalesOrderId"]);
            }
        }
    }
}