void loadReport() { dgvHD.DataSource = cn.XDL("select MaHD, TenDV, DonGia, SoluongDV, ThanhTien from DichVu, ChiTietHoaDon where ChiTietHoaDon.MaDV=DichVu.MaDV and ChiTietHoaDon.MaHD='" + txtMaHD.Text.ToString() + "'"); txtTongtien.Text = cn.XDL("select sum(ThanhTien) as TongTien from ChiTietHoaDon where MaHD='" + txtMaHD.Text.ToString() + "'").Rows[0][0].ToString(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt.Columns.Add("MaHD", typeof(string)); dt.Columns.Add("TenDV", typeof(string)); dt.Columns.Add("DonGia", typeof(float)); dt.Columns.Add("SoluongDV", typeof(float)); dt.Columns.Add("ThanhTien", typeof(float)); foreach (DataGridViewRow dgv in dgvHD.Rows) { dt.Rows.Add(dgv.Cells["MaHD"].Value, dgv.Cells["TenDV"].Value, dgv.Cells["DonGia"].Value, dgv.Cells["SoluongDV"].Value, dgv.Cells["ThanhTien"].Value); } ds.Tables.Add(dt); ds.WriteXmlSchema("report.xml"); CR cr = new CR(); cr.SetDataSource(ds); crv.ReportSource = cr; }