//Class chứa data từ sql
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace computer
{
    public class MayTinh
    {
        computerDataContext mt;
        public MayTinh()
        {
            mt = new computerDataContext();
        }
        public List<tblPhonghoc> showtree()
        {
            return mt.tblPhonghocs.Select(t => t).ToList();
        }
        public List<tblMaytinh> computershow(string maPhong)
        {
            return mt.tblMaytinhs.Where(t => t.msPhong==maPhong).ToList();
        }
        public List<tblPhonghoc> classshow()
        {
            return mt.tblPhonghocs.Select(t => t).ToList();
        }
public void addclass(tblPhonghoc e)
        {
            mt.tblPhonghocs.InsertOnSubmit(e);
            mt.SubmitChanges();
        }
}


//Form của mình
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 computer;
namespace QL_MayTinh
{
    
    public partial class Form2 : Form
    {
        computerDataContext cp;
        private MayTinh mt;
        private tblPhonghoc ph;
        
        public Form2(Form1 _f1)
        {
            cp = new computerDataContext();
            mt = new MayTinh();
            ph = new tblPhonghoc();
            InitializeComponent();
            //lvclass.View = View.Details;       
        }

        private void Form2_Load(object sender, EventArgs e)
        {           
            BindingSource b = new BindingSource();
            b.DataSource = mt.classshow();
            dataGridView1.DataSource = b;
            bindingNavigator1.BindingSource = b;
            
        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            ph.msPhong=dataGridView1.SelectedRows[0].Cells[0].ToString();
            ph.tenPhong = dataGridView1.SelectedRows[0].Cells[1].ToString();
            ph.toaNha = dataGridView1.SelectedRows[0].Cells[2].ToString();
            ph.tanglau =Convert.ToInt16( dataGridView1.SelectedRows[0].Cells[3].Value);
            mt.addclass(ph);
           
        }

        
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85