<div>
command.CommandType = CommandType.StoredProcedur<wbr />e;<br />
SqlParameter sparam = new SqlParameter(&quot;@invar&quot;,SqlD<wbr />bType.Int)<wbr /> &nbsp; &nbsp; &nbsp;<br />
sparam.Direction = ParameterDirection.Input;<br />
<br />
<br />
//ParameterDirection has the following values avaliable: Input, InputOutput, Output and ReturnValue
</div>


command.CommandType = CommandType.StoredProcedure;
SqlParameter sparam = new SqlParameter("@invar",SqlDbType.Int)      
sparam.Direction = ParameterDirection.Input;


//ParameterDirection has the following values avaliable: Input, InputOutput, Output and ReturnValue

<div>
To specify size:<br />
SqlParameter sparam &nbsp;= new SqlParameter(&quot;@invar&quot;, SqlDbType.VarChar, 2)
</div>


To specify size:
SqlParameter sparam  = new SqlParameter("@invar", SqlDbType.VarChar, 2)

<div>
<div class="content wysiwyg-content">
 &nbsp; &nbsp; &nbsp;How can I specify the size of a stored procedure parameter and also the direction.<br />
I'm having problems doing this...... &nbsp; &nbsp; &nbsp;<br />
<br />
C# sudo code... &nbsp;<br />
<br />
&nbsp;command.CommandType = CommandType.StoredProcedur<wbr />e;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlParameter sparam = new SqlParameter(&quot;@invar&quot;,SqlD<wbr />bType.Int,<wbr /> intput?
</div>
</div>


      How can I specify the size of a stored procedure parameter and also the direction.
I'm having problems doing this......      

C# sudo code...  

 command.CommandType = CommandType.StoredProcedure;
                SqlParameter sparam = new SqlParameter("@invar",SqlDbType.Int, intput?

How can I specify the size of a stored procedure parameter and also the direction

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).