Загрузка данных


SQL
using Microsoft.Data.SqlClient;
using System.Data.SqlTypes;
using System.Drawing;
internal class Program
{
    private static void Main(string[] args)
    {
        Console.WriteLine("Hello, World!");

        SqlConnection? conn = null;
        SqlDataReader? reader = null;
        try
        {
            string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=FlowerShop;Integrated Security=True;Connect Timeout=30;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False";

            conn = new SqlConnection(connectionString);
            conn.Open();

            Console.WriteLine(
                conn.State == System.Data.ConnectionState.Open ?
                "Соединение установлено" : "Ошибка подключения"
                );

            //string sqlString = @"insert into Flowers
            //(Title,Price,Color) values
            //('Sunflower',1000,'Yellow')";

            //SqlCommand cmd = new SqlCommand( sqlString, conn );
            //cmd.ExecuteNonQuery();

            string sqlString = @"select * from Flowers";

            SqlCommand cmd = new SqlCommand(sqlString, conn);
            reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine($"{reader["Color"]} {reader[1]} - {reader[2]}");
            }
        }
        finally
        {
            if(reader != null)
                reader.Close();
            if (conn != null)
            {
                conn.Close();
            }
        }


    }
}