Example #1
0
        private void cbo_dm_SelectedIndexChanged(object sender, EventArgs e)
        {
            bll = new BLL_QuanLySP();
            DataTable dt = new DataTable();

            if (cbo_dm.SelectedIndex == 0)
            {
                dt = bll.GetListPro(ref err);
            }
            else
            {
                int id = bll.GetCatIDWithCatName(ref err, cbo_dm.SelectedItem.ToString());
                dt = bll.GetListProWithCatID(ref err, id);
            }
            dataGridView1.DataSource = dt;
            lbl_QuantityPro.Text     = dt.Rows.Count.ToString();
        }
        public void HienThiReport()
        {
            BLL_QuanLySP bll = new BLL_QuanLySP();
            DataTable    dt  = new DataTable();

            dt = bll.GetListProWithCatID(ref err, Convert.ToInt32(CatID));
            dt.Columns.Add("STT");
            int i = 1;

            foreach (DataRow item in dt.Rows)
            {
                item["STT"] = i;
                i++;
            }
            reportViewer1.Reset();
            reportViewer1.LocalReport.ReportEmbeddedResource = "ThiWinfrom.Report1.rdlc";
            reportViewer1.LocalReport.DataSources.Clear();
            ReportDataSource _dataSource = new ReportDataSource("DS_InBaoCao", dt);

            reportViewer1.LocalReport.DataSources.Add(_dataSource);
            this.reportViewer1.RefreshReport();
        }