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.SqlClient;

namespace WindowsFormsApplication
{
    public partial class Form1 : Form
    {
        SqlConnection cs = new SqlConnection("server=(local);Initial Catalog=Carturesti;Integrated Security=True");
        SqlDataAdapter daEditura = new SqlDataAdapter();
        SqlDataAdapter daCarte = new SqlDataAdapter();
        DataSet ds = new DataSet();
        DataSet dsEditura = new DataSet();
        DataSet dsCarte = new DataSet();
        BindingSource bsEditura = new BindingSource();
        BindingSource bsCarte = new BindingSource();
        SqlCommandBuilder cBuilder;

        //BindingSource bs = new BindingSource();
        public Form1()
        {
            daEditura.SelectCommand = new SqlCommand("SELECT * FROM Editura", cs);
            daCarte.SelectCommand = new SqlCommand("SELECT * FROM Carte", cs);

            ds.Clear();
            cBuilder = new SqlCommandBuilder(daCarte);
            daEditura.Fill(ds, "Editura");
            daCarte.Fill(ds, "Carte");

            DataRelation dr = new DataRelation("codc", ds.Tables["Editura"].Columns["code"], ds.Tables["Carte"].Columns["codEditura"]);
            ds.Relations.Add(dr);


            bsEditura.DataSource = ds;
            bsEditura.DataMember = "Editura";

            bsCarte.DataSource = bsEditura;
            bsCarte.DataMember = "codc";

            dataGridView1.DataSource = bsEditura;
            dataGridView2.DataSource = bsCarte;

        }


    }
}