asp.net.ph

SqlParameter Constructor ( String, SqlDbType )

System.Data.SqlClient Namespace   SqlParameter Class


Initializes a new instance of the SqlParameter class with the parameter name and data type.

[ VB ]
Overloads Public Sub New ( _
   ByVal name As String, _
   ByVal dataType As SqlDbType _
)

[ C# ]
public SqlParameter (
   string name,
   SqlDbType dataType
);

[ C++ ]
public: SqlParameter (
   String* name,
   SqlDbType dataType
);

[ JScript ]
public function SqlParameter (
   name : String,
   dataType : SqlDbType
);

Parameters

name
The name of the parameter to map.
dataType
One of the SqlDbType values.

Remarks

The Size and Precision are inferred from the SqlDbType parameter.

Example

The following example initializes an SqlParameter using this constructor and sets some of its properties.

public void CreateSqlParameter ( ) {
   SqlParameter myParam = new SqlParameter ( "@Description", SqlDbType.VarChar );
   myParam.Direction = ParameterDirection.Output;
}
  C# VB

See Also

SqlParameter Members   SqlParameter Constructor Overload List Skip Navigation Links




Home
Suggested Reading


Previous page Back to top Next page

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph