Single line Stored Procedure Parameter Syntax 
Author Message
 Single line Stored Procedure Parameter Syntax

If I setup a parameter going into a stored procedure like:


Is there a way to specify the direction property value on the same
line, so that all my parameter information is setup with one line of
code?



Wed, 20 Jul 2005 08:36:00 GMT  
 Single line Stored Procedure Parameter Syntax
iforsyth,

On 31 Jan 2003 16:36:00 -0800

inline...

Quote:
> Is there a way to specify the direction property value on the same
> line, so that all my parameter information is setup with one line of
> code?

Like this.

    cmdRead.Parameters.Add( _
        New SqlClient.SqlParameter( _

            SqlDbType.VarChar, _
            11, _
            ParameterDirection.Input, _
            True, _
            Nothing, _
            Nothing, _
            "Description", _
            DataRowVersion.Default, _
            strID))

---
| aMailAddress |



Wed, 20 Jul 2005 18:35:20 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ado recordsets from stored procedures, stored procedures have input parameters

2. How to: Replicate Outer join results with a single stored procedure

3. Single stored procedure with 2 select statements

4. Getting both result sets into one recordset from a single stored procedure

5. syntax to access oracle stored procedure

6. stored procedure syntax example?

7. Proper stored procedure syntax

8. Proper stored procedure syntax

9. Need correct syntax for calling JDE stored procedure on AS400

10. Fancy stored procedure syntax

11. Fancy stored procedure syntax

12. To Stored Procedure or not to stored procedure

 

 
Powered by phpBB® Forum Software