Returns all parameters used when performing the select command.
[Visual Basic] Overrides Public Function GetFillDataSetParameters() As _ IDataParameter () [C#] public override IDataParameter[] GetFillDataSetParameters(); [C++] public: override IDataParameter* GetFillDataSetParameters() []; [JScript] public override function GetFillDataSetParameters() : IDataParameter ;
A collection of IDataParameter objects that contain all the parameters used by the SelectCommand.
The following example creates an array of IDataParameter and sets it to all the select command parameters.
[Visual Basic]
Sub ShowAllDataParams() Dim myDataSetComm As ADODataSetCommand ' Initialize the ADODataSetCommand myDataSetComm = New ADODataSetCommand ' Create array to place data parameters in Dim myParams() As IDataParameter ' Create temporary parameter for loop Dim tempParam As IDataParameter ' Create message box to display parameters Dim myMsgBox As MessageBox ' Create the string for the message box Dim myMessage As String ' Return all parameters to myParams myParams = myDataSetComm.GetFillDataSetParameters ' Initialize myMessage myMessage = "" ' loop through all parameters extracting name, column, and value For Each tempParam In myParams myMessage += "Name: " + tempParam.ParameterName + " Column: " _ + tempParam.SourceColumn + "\n" Next ' Display the list of parameter names myMsgBox.Show myMessage End Sub
DBDataSetCommand Class | DBDataSetCommand Members | System.Data.Internal Namespace