Crystal Reports XI Release 2  

Tutorial: Connecting to ADO.NET DataSets: Conclusion

In this tutorial you learned how to connect a report to an ADO.NET DataSet schema and populate the DataSet schema with data and then display it in the report at runtime.

You added a connection to the Xtreme sample database in the Server Explorer. You dragged a Customer table onto a DataSet window to create a CustomerDataSetSchema.xsd. Then you wrote a helper class that returned a populated DataSet at runtime.

You created a Crystal report and configured it to address the CustomerDataSetSchema schema (or, for a Visual Studio 2005 Web Site, a DataSet configured to the CustomerDataSetSchema.xsd file). You then wrote code in the ConfigureCrystalReports() method to retrieve a filled DataSet from the CustomerDataSet property in the helper class and pass that DataSet into the report before binding the report to the CrystalReportViewer control.

In an addendum for Web Sites, you placed the populated DataSet instance into the ASP.NET Cache object, to improve performance and scalability.

See Also

Tutorial: Printing and Setting Print Options | Tutorial: Connecting to ADO.NET DataSets | Tutorials and Sample Code | Tutorials' Sample Code Directory