(교재실습) MakeDataSet(DateSet연습)

* "윈폼"에서 '새 프로젝트 만들기'로 프로젝트 실행


==> Form1.cs [디자인]  

  

 

-------------------------------------------------------------------------------------

  

==> Form1.cs 소스  

  

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

 

namespace MakeDataSet

{

    public partial class Form1 : Form

    {

        private DataSet DbADOTest;

        private DataTable tblPeople, tblSale;

        private DataRelation RelBuy;

 

        public Form1()

        {

            InitializeComponent();

        }

 

        private void Form1_Load(object sender, EventArgs e)

        {

            DbADOTest = new DataSet("DbADOTest");

            tblPeople = MakePeopleTable();

            tblSale = MakeSaleTable();

            DbADOTest.Tables.Add(tblPeople);

            DbADOTest.Tables.Add(tblSale);

 

            RelBuy = new DataRelation("Buy",

                DbADOTest.Tables["tblPeople"].Columns["Name"],

                DbADOTest.Tables["tblSale"].Columns["Customer"]);

            DbADOTest.Relations.Add(RelBuy);

 

            dataGridView1.DataSource = DbADOTest.Tables["tblPeople"];

            dataGridView2.DataSource = DbADOTest.Tables["tblSale"];

        }

 

        private DataTable MakePeopleTable()

        {

            DataTable tblPeople = new DataTable("tblPeople");

 

            DataColumn col;

            DataRow row;

 

            // 열 등록

            col = new DataColumn("Name", typeof(String));

            col.MaxLength = 10;

            col.AllowDBNull = false;

            col.Unique = true;

            tblPeople.Columns.Add(col);

 

            tblPeople.PrimaryKey = new DataColumn[] { col };

 

            col = new DataColumn("Age", typeof(Int32));

            col.AllowDBNull = false;

            tblPeople.Columns.Add(col);

 

            col = new DataColumn("Male", typeof(bool));

            col.AllowDBNull = false;

            tblPeople.Columns.Add(col);

 

            // 행 삽입

            row = tblPeople.NewRow();

            row["Name"] = "정우성";

            row["Age"] = 36;

            row["Male"] = true;

            tblPeople.Rows.Add(row);

 

            row = tblPeople.NewRow();

            row["Name"] = "고소영";

            row["Age"] = 32;

            row["Male"] = false;

            tblPeople.Rows.Add(row);

 

            row = tblPeople.NewRow();

            row["Name"] = "배용준";

            row["Age"] = 37;

            row["Male"] = true;

            tblPeople.Rows.Add(row);

 

            row = tblPeople.NewRow();

            row["Name"] = "김태희";

            row["Age"] = 29;

            row["Male"] = false;

            tblPeople.Rows.Add(row);

 

            tblPeople.AcceptChanges();

            return tblPeople;

        }

 

        private DataTable MakeSaleTable()

        {

            DataTable tblSale = new DataTable("tblSale");

 

            DataColumn col;

            DataRow row;

 

            //열 등록

            col = new DataColumn("OrderNo", typeof(Int32));

            col.AllowDBNull = false;

            col.Unique = true;

            col.AutoIncrement = true;

            col.ReadOnly = true;

            tblSale.Columns.Add(col);

 

            tblSale.PrimaryKey = new DataColumn[] { col };

 

            col = new DataColumn("Customer", typeof(String));

            col.MaxLength = 10;

            col.AllowDBNull = false;

            tblSale.Columns.Add(col);

 

            col = new DataColumn("Item", typeof(String));

            col.MaxLength = 20;

            col.AllowDBNull = false;

            tblSale.Columns.Add(col);

 

            col = new DataColumn("ODate", typeof(DateTime));

            col.AllowDBNull = false;

            tblSale.Columns.Add(col);

 

            // 행 삽입

            row = tblSale.NewRow();

            row["Customer"] = "정우성";

            row["Item"] = "면도기";

            row["ODate"] = new DateTime(2008, 1, 1);

            tblSale.Rows.Add(row);

 

            row = tblSale.NewRow();

            row["Customer"] = "고소영";

            row["Item"] = "화장품";

            row["ODate"] = new DateTime(2008, 1, 2);

            tblSale.Rows.Add(row);

 

            row = tblSale.NewRow();

            row["Customer"] = "김태희";

            row["Item"] = "핸드폰";

            row["ODate"] = new DateTime(2008, 1, 3);

            tblSale.Rows.Add(row);

 

            row = tblSale.NewRow();

            row["Customer"] = "김태희";

            row["Item"] = "휘발유";

            row["ODate"] = new DateTime(2008, 1, 4);

            tblSale.Rows.Add(row);

 

            tblSale.AcceptChanges();

            return tblSale;

        }

       

        private void btnGetChild_Click(object sender, EventArgs e)

        {

            DataRow[] Items;

            DataRow[] Customer;

 

            string Name = (string)dataGridView1.CurrentRow.Cells[0].Value;

 

            Customer = tblPeople.Select("Name = '" + Name + "'");

            Items = Customer[0].GetChildRows(DbADOTest.Relations["Buy"]);

 

            listBox1.Items.Clear();

            foreach (DataRow R in Items)

            {

                listBox1.Items.Add(R["Item"]);

            }

        }

 

        private void btnGetParent_Click(object sender, EventArgs e)

        {

            DataRow[] Items;

            DataRow Customer;

 

            string Name = (string)dataGridView2.CurrentRow.Cells[1].Value;

 

            Items = tblSale.Select("Customer ='" + Name + "'");

            Customer = Items[0].GetParentRow(DbADOTest.Relations["Buy"]);

 

            textBox1.Text = String.Format("이름 : {0}, 나이 : {1}, 성별 : {2}",

                Customer["Name"], Customer["Age"], Customer["Male"]);

        }

    }

}

 

 

-------------------------------------------------------------------------------------

 

 [실행결과]