Original-the easiest way to bind Crystal Reports

A crystal report is usually bound after a dataset is created. Next I will introduce a method to bind it directly with an SQL statement. You do not need to set the report path of crystalreportviewer1. You do not need to create a dataset separately.

CodeAs follows:

Crystalreport3 OCR = new crystalreport3 (); // bound. rpt object

// SQL Binding data
Sqlconnection CNN = new sqlconnection (configurationsettings. etettings ["connectionsqlserver"]);
Sqldataadapter cmd1 = new sqldataadapter ("select top 1 * From meetingplan", CNN );
Dataset DS = new dataset ();
Limit 1.fill (DS, "meetingplan ");

OCR. setdatasource (DS );
This. crystalreportviewer1.reportsource = OCR; // bind the rpt file.
CNN. Close ();

Note: The meetingplan must be consistent with the report expert crystalreport3; otherwiseQuery Engine error.