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