System.Data.SqlClient Namespace SqlParameter Class
Checks whether the parameter accepts null values.
Script |
SqlParameter.IsNullable [ = true | false ] |
This property accepts or returns only a boolean value: true if null values are accepted; otherwise, false. The default is false.
IDataParameter.IsNullable
Null values are handled using the DBNull class.
The following example initializes an SqlParameter and sets some of its properties.
public void CreateSqlParameter ( ) {
SqlParameter myParam = new SqlParameter ( "@Description", SqlDbType.VarChar, 100 );
myParam.IsNullable = true;
myParam.Direction = ParameterDirection.Output;
}
Public Sub CreateSqlParameter ( )
Dim myParam As New SqlParameter ( "@Description", SqlDbType.VarChar, 100 )
myParam.IsNullable = true
myParam.Direction = ParameterDirection.Output
End Sub |
|
C# |
VB |
SqlParameter Members