Parameter.Type Property

Reference

Definition

Namespace:: System.Web.UI.WebControls

Assembly:: System.Web.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the type of the parameter.

public:
 property TypeCode Type { TypeCode get(); void set(TypeCode value); };

public TypeCode Type { get; set; }

member this.Type : TypeCode with get, set

Public Property Type As TypeCode

Property Value

TypeCode

The type of the Parameter. The default value is Object.

Exceptions

ArgumentOutOfRangeException

The parameter type is not one of the TypeCode values.

Examples

The following code example demonstrates how to set the DefaultValue, Type, and Direction properties of Parameter objects when using them as output parameters and return value parameters with a stored procedure. This code example is part of a larger example provided for the SqlDataSourceStatusEventArgs class overview.

<asp:sqldatasource
    id="SqlDataSource1"
    runat="server"
    datasourcemode="DataSet"
    connectionstring="<%$ ConnectionStrings:MyNorthwind%>"
    selectcommand="getordertotal"
    onselected="OnSelectedHandler">
    <selectparameters>
      <asp:querystringparameter name="empId" querystringfield="empId" />
      <asp:parameter name="total" type="Int32" direction="Output" defaultvalue="0" />
      <asp:parameter name="_ret" type="Int32" direction="ReturnValue" defaultvalue="0" />
    </selectparameters>
</asp:sqldatasource>

<asp:sqldatasource
    id="SqlDataSource1"
    runat="server"
    datasourcemode="DataSet"
    connectionstring="<%$ ConnectionStrings:MyNorthwind%>"
    selectcommand="getordertotal"
    onselected="OnSelectedHandler">
    <selectparameters>
      <asp:querystringparameter name="empId" querystringfield="empId" />
      <asp:parameter name="total" type="Int32" direction="Output" defaultvalue="0" />
      <asp:parameter name="_ret" type="Int32" direction="ReturnValue" defaultvalue="0" />
    </selectparameters>
</asp:sqldatasource>

Remarks

The type can be used to create strongly typed parameters, so that values are converted correctly between your Web application and underlying code.

If the type of the parameter is changed, the OnParameterChanged method is called.

Applies to

Jaa