private void Form9_Load(object sender, EventArgs e) { string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=kursovaya.mdb"; OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = ConnectionString; string sql = "SELECT Товари.[Найменування], Товари.[Бренд], Товари.[Ціна] FROM Товари"; OleDbCommand myCommand = new OleDbCommand(sql, connection); connection.Open(); OleDbDataAdapter da = new OleDbDataAdapter(myCommand); DataSet ds = new DataSet(); da.Fill(ds, "Товари"); ds.WriteXmlSchema("schema7.xml"); connection.Close(); CrystalReport2 rtp = new CrystalReport2(); rtp.SetDataSource(ds); crystalReportViewer1.ReportSource = rtp; this.crystalReportViewer1.RefreshReport(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport2 rpt = new CrystalReport2(); rpt.Site = this.Site; return(rpt); }