public UC_BC_HDDoan() { InitializeComponent(); Report.crpt_BC_HoatDongDoan rpt = new Report.crpt_BC_HoatDongDoan(); rpt.SetParameterValue("fromDate", DateTime.Now.ToString()); crpt_BC_HDDoan.ReportSource = rpt; }
private void buttonX2_Click(object sender, EventArgs e) { Report.crpt_BC_HoatDongDoan rpt = new Report.crpt_BC_HoatDongDoan(); rpt.SetParameterValue("fromDate", dtiptungay.Value.ToString()); conn.Open(); SqlDataAdapter dap = new SqlDataAdapter("SELECT Id,TenHoatDong,CONVERT(varchar,ThoiGian,103) as ThoiGian,MaCB,KetQua FROM tbl_THONGTINHOATDONGDOAN where ThoiGian between '" + dtiptungay.Value + "' and '" + dtipdenngay.Value + "'", conn); DataSet ds = new DataSet(); dap.Fill(ds); rpt.SetDataSource(ds.Tables[0]); crpt_BC_HDDoan.ReportSource = rpt; crpt_BC_HDDoan.Refresh(); conn.Close(); }