son uygulama

[caglar temur]

SqlConnection conn=new SqlConnection("server=.;database=Northwind;integrated security=true");

SqlDataAdapter adp;

DataTable dtKategoriler,dtUrunler,dtSiparisler;

 

private void Form4_Load(object sender, EventArgs e)

{

      adp=new SqlDataAdapter("select CategoryID,CategoryName from Categories",conn);

     dtKategoriler=new DataTable();

      adp.Fill(dtKategoriler)

 

    adp=new SqlDataAdapter("select CategoryID,ProductID,ProductName from Products",conn);;

     dtUrunler=new DataTable();

      adp.Fill(dtUrunler);

  

      adp=new SqlDataAdapter("select c.CompanyName,o.OrderDate,od.ProductID,od.Quantity from Orders as o join [Order Details] as od on od.OrderID=o.OrderID join Customer as c on c.CustomerID=o.CustomerID",conn);

     dtSiparisler=new DataTable();

     adp.Fill(dtSiparisler);

 

    DataSet ds=new DataSet();

       ds.Tables.Add(dtKategoriler);

       ds.Tables.Add(dtUrunler);

       ds.Tables.Add(dtSiparisler);

 

    ds.Relations.Add("rltn_KatUr",ds.Tables[0].Columns["CategoryID"],ds.Tables[1].Columns["CategoryID"]);

     ds.Relations.Add("rltn_UrSip",ds.Tables[1].Columns["ProductID"],ds.Tables[2].Columns["ProductID"]);

 

       cmbKategoriler.DataSource=ds.Tables[0];

        cmbKategoriler.DisplayMember="CategoryName";

       cmdKategoriler.ValueMember="CategoryID";

 

       cmbUrunler.DataSource=ds.Tables[0];

        cmbUrunler.DisplayMember="rltn_KatUr.CategoryName";

       cmdUrunler.ValueMember="rltn_KatUr.CategoryID";

 

     dataGridView1.DataSource=ds.Tables[0];

     dataGridView1.DataMember="rltn_KatUr.rltn_UrSip";

 

 

}