25장 서버연결 통해 DB연동 (WinLINQ)

Magic_kit 2009. 10. 1. 14:40

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;
using System.Data.Linq;

namespace WinLINQ
{
   public partial class Form1 :
                                         Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ToDoListDataContext context = new ToDoListDataContext();
            Table<Items> items = context.GetTable<Items>();

var q = from item in items select item;

            foreach (var desc in items)
         {
          listBox1.Items.Add(desc.Description + "," + desc.Priority);
         }

            //저장 프로시저 ??
            //.점 찍으면 업데이트,삭제 모두 노출되었다
            this.dataGridView1.DataSource = context.GetItems();
        }
    }
}

WinLINQ10월1.zip