using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        SqlConnection conn;
        DataSet ds;
        SqlDataAdapter daCustomers, daOrders, da;
        BindingSource bsCustomers, bsOrders;
        SqlCommandBuilder cb;

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            daOrders.Update(ds, "Orders");
        }

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            conn = new SqlConnection("Data Source=DESKTOP-NM9EEPJ;Initial Catalog=Northwind;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
            da = new SqlDataAdapter("select * from Customers", conn);
            ds = new DataSet();
            //da.Fill(ds, "Customers");
            //---part 1
            //textBox1.DataBindings.Add("Text", ds, "Customers.CustomerID");
            //textBox2.DataBindings.Add("Text", ds, "Customers.CompanyName");

            //comboBox1.DataSource = ds;
            //comboBox1.DisplayMember = "Customers.CustomerID";
            //---done part 1

            //---part2
            //BindingSource bs = new BindingSource();
            //bs.DataSource = ds;
            //bs.DataMember = "Customers";

            //textBox1.DataBindings.Add("Text", bs, "CustomerID");
            //textBox2.DataBindings.Add("Text", bs, "CompanyName");

            //comboBox1.DataSource = bs;
            //comboBox1.DisplayMember = "CustomerID";
            //---done part 2

            daCustomers = new SqlDataAdapter("select * from Customers", conn);
            daOrders = new SqlDataAdapter("select * from Orders", conn);
            daCustomers.Fill(ds, "Customers");
            daOrders.Fill(ds, "Orders");

            cb = new SqlCommandBuilder(daOrders);

            ds.Relations.Add("FK_Orders_Customers", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]);

            bsCustomers = new BindingSource();
            bsCustomers.DataSource = ds;
            bsCustomers.DataMember = "Customers";
            bsOrders = new BindingSource();
            bsOrders.DataSource = bsCustomers;
            bsOrders.DataMember = "FK_Orders_Customers";

            dgvCustomers.DataSource = bsCustomers;
            dgvOrders.DataSource = bsOrders;
        }
    }
}