DB2Parameter Class

In This Topic

Represents a parameter to a DB2Command, and optionally, its mapping to System.Data.DataSet columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Class DB2Parameter 
   Inherits Devart.Common.DbParameterBase
   Implements System.Data.IDataParameter, System.Data.IDbDataParameter, System.ICloneable

public class DB2Parameter : Devart.Common.DbParameterBase, System.Data.IDataParameter, System.Data.IDbDataParameter, System.ICloneable

Remarks

Parameter names are not case-sensitive.

Refer to article Using Parameters in dotConnect for DB2 to obtain detailed information on the matter together with some advanced examples.

Example

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.

csharp

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);
}

Visual Basic

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

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbParameter
         Devart.Common.DbParameterBase
            Devart.Data.DB2.DB2Parameter

Reference

DB2Parameter Members
Devart.Data.DB2 Namespace
DB2Command Class
DB2DataAdapter Class

Send Feedback