Example #1
0
        public void ShowT()
        {
            DataTable dt = new DataTable();

            dt = Bus.GetListT("SELECT * FROM dbo.Thuoc WHERE TenThuoc NOT IN (SELECT TenThuoc FROM dbo.ChiTietHoaDonXuat INNER JOIN dbo.Thuoc ON Thuoc.MaThuoc = ChiTietHoaDonXuat.MaThuoc WHERE MaHDX='" + txt_MaHD.Text + "') AND TTT='0'");
            cbTenThuoc.DataSource    = dt;
            cbTenThuoc.DisplayMember = "TenThuoc";
            cbTenThuoc.ValueMember   = "MaThuoc";
        }