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(); }