private void button1_Click(object sender, EventArgs e) { try { HoTro ht = new HoTro(); string command = "select ProductId, MfgDate, ExpDate, ProdName, PurchasePrice, SalePrice,DisCount,StatusName, BillPurchase.CreateDate" + " from product join ProductName" + " on Product.productNameid = ProductName.productNameid" + " join ProductStatus" + " on Product.StatusId = ProductStatus.StatusId" + " join BillPurchase" + " on Product.BillPurchaseId = BillPurchase.BillPurchaseId"; SqlDataAdapter adapter = new SqlDataAdapter(command, ht.KetNoi()); BaoCao.DataSet1 dataset = new SSMP.BaoCao.DataSet1(); adapter.Fill(dataset, "DataTable1"); BaoCao.TestNhapCrystalReport report = new SSMP.BaoCao.TestNhapCrystalReport(); report.SetDataSource(dataset); crystalReportViewer1.ReportSource = report; } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void taiCrystalReport() { try { HoTro ht = new HoTro(); SqlConnection conn = ht.KetNoi(); string tuNgay, denNgay; if (checkBoxNgay.Checked) { tuNgay = dateTimePicker1.Value.ToShortDateString(); denNgay = dateTimePicker2.Value.ToShortDateString(); } else { tuNgay = "1/1/2009"; denNgay = DateTime.Now.ToShortDateString(); } string command = "select ProductId, convert(varchar,MfgDate,103) as 'MfgDate',convert(varchar,ExpDate,103) as 'ExpDate', ProdName, PurchasePrice, SalePrice,DisCount,StatusName, convert(varchar,BillPurchase.CreateDate,103) as 'CreateDate' " + " from product join ProductName" + " on Product.productNameid = ProductName.productNameid" + " join ProductStatus" + " on Product.StatusId = ProductStatus.StatusId" + " join BillPurchase" + " on Product.BillPurchaseId = BillPurchase.BillPurchaseId" +" where BillPurchase.CreateDate >= '" + tuNgay + "' and BillPurchase.CreateDate <= '" + denNgay + "'"; SqlDataAdapter adapter = new SqlDataAdapter(command, conn); BaoCao.DataSet1 dataset = new SSMP.BaoCao.DataSet1(); adapter.Fill(dataset, "DataTable1"); BaoCao.TestNhapCrystalReport report = new SSMP.BaoCao.TestNhapCrystalReport(); report.SetDataSource(dataset); crystalReportViewer1.ReportSource = report; conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }