Esempio n. 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            TimKiemSanPhamDataContext db = new TimKiemSanPhamDataContext();
            var x = from y in db.SANPHAMs where y.TENSP.Contains(textBox1.Text) select y;

            sANPHAMDataGridView.DataSource = x;
        }
Esempio n. 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            TimKiemSanPhamDataContext db = new TimKiemSanPhamDataContext();
            var x = from y in db.KHUYENMAIs where y.MASP.Contains(textBox1.Text) select y;

            kHUYENMAIDataGridView.DataSource = x;
        }
Esempio n. 3
0
 private void button2_Click(object sender, EventArgs e)
 {
     if (textBox2.Text.Length != 0 && textBox3.Text.Length != 0)
     {
         TimKiemSanPhamDataContext db = new TimKiemSanPhamDataContext();
         var y = from x in db.SANPHAMs where (x.DonGia >= (int.Parse(textBox2.Text))) where (x.DonGia <= (int.Parse(textBox3.Text))) select x;
         sANPHAMDataGridView.DataSource = y;
     }
     else
     {
         MessageBox.Show("Vui lòng nhập đầy đủ thông tin");
     }
 }