Implementing a Command Class for a Data Processing Extension

The Command object formulates a request and passes it on to the data source. The command text can take many different syntactical forms, including text and XML. If results are returned, the Command object returns results as a DataReader object.

To create a Command class, implement IDbCommand. Implement the ExecuteReader method to return a result set as a DataReader object. The ExecuteReader method of your Command class should include an implementation that takes a CommandBehavior enumeration as an argument. If you deploy your data processing extension to Report Designer, provide an implementation that handles a SchemaOnly case in the ExecuteReader method. A schema-only implementation is used to supply Report Designer with a fields list. The DataReader object returned by the ExecuteReader method needs to contain type and name information for the fields, or columns, in your result set.

Optionally, your Command class can implement IDbCommandAnalysis. This interface enables an implementing class to analyze a query and return a list of parameters in the query. The functionality of the IDbCommandAnalysis interface is only used in Report Designer. When you implement IDbCommandAnalysis, you enable users of Report Designer to be prompted for parameters whenever a report is run in preview mode. In addition, you can view the parameters in the Parameters tab of the Data Set dialog.

附註：
You should not implement IDbCommandAnalysis if your custom data processing extension does not support parameters.

For a sample Command class implementation, see 檔案共用資料處理延伸模組範例.

請參閱

參考

Reporting Services Extension Library

其他資源

Reporting Services Extensions
Implementing a Data Processing Extension

說明及資訊

取得 SQL Server 2005 協助