[This is preliminary documentation and is subject to change.]
Adds a double parameter to the SqlCommand for the stored procedure.
This done to make the parameter assignment simple for Stored Procedure.
Namespace:
OfficeClip.DBLayerAssembly: OfficeClip.DBLayer (in OfficeClip.DBLayer)
Version: 8.1.1.0
Syntax
C# |
---|
protected void AddParameters( SqlCommand myCommand, string parameterSP, double parameterValue, SqlDbType sdt, int size, int precision, int scale ) |
Visual Basic (Declaration) |
---|
Protected Sub AddParameters ( _ myCommand As SqlCommand, _ parameterSP As String, _ parameterValue As Double, _ sdt As SqlDbType, _ size As Integer, _ precision As Integer, _ scale As Integer _ ) |
Visual C++ |
---|
protected: void AddParameters( SqlCommand^ myCommand, String^ parameterSP, double parameterValue, SqlDbType sdt, int size, int precision, int scale ) |
Parameters
- myCommand
- Type: System.Data.SqlClient..::.SqlCommand
The SqlCommand object passed as reference.
- parameterSP
- Type: System..::.String
The Stored Procudure parameter name string.
- parameterValue
- Type: System..::.Double
The value of the parameter to be assigned in double.
- sdt
- Type: System.Data..::.SqlDbType
SqlDbType enumerated type to ensure the parameter type is correctly passed.
- size
- Type: System..::.Int32
size of the input parameter.
- precision
- Type: System..::.Int32
Precision of the input parameter.
- scale
- Type: System..::.Int32
Scale of the input parameter.