Navigation:  Advantage .NET Data Provider > AdsParameter Class > AdsParameter Constructors >

AdsParameter Constructor ( string, object )

Advantage .NET Data Provider

Previous pageReturn to chapter overviewNext page

Initializes a new instance of the AdsParameter class with the given name and value.

public AdsParameter


string parameterName, // (I) parameter name

object value // (I) parameter value



The DbType will be inferred from the value of the given object. It can be changed if desired after creating the AdsParameter object via the AdsParameter.DbType property.


AdsConnection conn = new AdsConnection( "data source = c:\\data;" );

AdsCommand cmd;

AdsParameter param;


// open the connection


// create a new command object

cmd = new AdsCommand( "update departments set [Department Name] = :name " +

"where [department code] = :code",

conn );


// create the two parameters.

param = new AdsParameter( "name", "Research & Development" );

cmd.Parameters.Add( param );

param = new AdsParameter( "code", 104 );

cmd.Parameters.Add( param );


// execute the query

Console.WriteLine( "Records affected: " + cmd.ExecuteNonQuery() );