Parameter.Type Property

 

Gets or sets the type of the parameter.

Namespace:   System.Web.UI.WebControls
Assembly:  System.Web (in System.Web.dll)

public TypeCode Type { get; set; }

Property Value

Type: System.TypeCode

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

Exception Condition
ArgumentOutOfRangeException

The parameter type is not one of the TypeCode values.

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.

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>

.NET Framework
Available since 2.0
Return to top
Show: