Stored procedure parameter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

should I be able to set the value for a parameter to a stored procedure to
null? For example:

IDataParameter param = command.CreateParameter();
param.ParameterName = "@id";
param.Value = null;
param.Direction = ParameterDirection.Input;
param.DbType = DbType.Int32;
command.Parameters.Add(param);


I keep getting an sql-exception stating that the parameter @id was expected.

Thanks
Peter


.

Relevant Pages

  • Re: UPDATE problems with Parameters
    ... the parameters defined in your stored procedure. ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: sqltransaction
    ... stored procedure may be doing something with the master id.. ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why does the stored procedure always return the same value?
    ... I added it in the ADONET newsgroup yesteday before attaching here but ... But do you think a stored procedure will ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Update Record
    ... dass sich deine allgemeine Aussage "Die wahrscheinlich performanteste Variante dürfte eine Stored Procedure in der DB sein." ... mit einer DB vom Typ Access nicht umsetzen lässt :-) ... Peter ...
    (microsoft.public.de.vb.datenbank)
  • Re: DTS packages or stored procedures?
    ... a DTS script or a stored procedure ... with linked (SQL) servers? ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)