Represents a parameter to a
DB2Command, and optionally, its mapping to
System.Data.DataSet columns.
The following example creates multiple instances of
DB2Parameter through the
DB2ParameterCollection within the
DB2DataAdapter. These parameters are used to select data from DB2 and place the data in the
System.Data.DataSet. This example assumes that a
System.Data.DataSet and a
DB2DataAdapter have already been created with the appropriate schema, commands, and connection.
public void AddDB2Parameters()
{
// ...
// create myDataSet and myDataAdapter
// ...
myDataAdapter.SelectCommand.Parameters.Add("DName", DB2Type.VarChar, 15).Value = "DEVELOPMENT";
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", DB2Type.Int).Value = 50;
myDataAdapter.Fill(myDataSet);
}
Public Sub AddDB2Parameters()
' ...
' create myDataSet and myDataAdapter
' ...
myDataAdapter.SelectCommand.Parameters.Add("DName", DB2Type.VarChar, 15).Value = "DEVELOPMENT"
myDataAdapter.SelectCommand.Parameters.Add("DeptNo", DB2Type.Int).Value = 50
myDataAdapter.Fill(myDataSet)
End Sub