public List <BEL_LOAINUOC> Lay_loai_nuoc()
        {
            List <BEL_LOAINUOC> list = new List <BEL_LOAINUOC>();

            if (ConnectionState.Closed == Getcon().State)
            {
                Getcon().Open();
            }
            string     query = "select * from FoodCategory";
            SqlCommand cmd   = new SqlCommand(query, Getcon());

            try
            {
                SqlDataReader rd = cmd.ExecuteReader();
                dt.Load(rd);
                foreach (DataRow item in dt.Rows)
                {
                    BEL_LOAINUOC loai = new BEL_LOAINUOC(item);
                    list.Add(loai);
                }
            }
            catch (Exception err)
            {
                throw;
            }
            return(list);
        }
Exemplo n.º 2
0
        private void cboDanhMucMonAn_SelectedIndexChanged(object sender, EventArgs e)
        {
            int id = 0;

            ComboBox cb = sender as ComboBox;

            if (cb.SelectedItem == null)
            {
                return;
            }
            BEL_LOAINUOC select = cb.SelectedItem as BEL_LOAINUOC;

            id = select.Maloainuoc;
            load_Food(id);
        }