<div>
<div class="content wysiwyg-content">
Is it ok to set the parameters of an SqlCommand before they appear in the command text? &nbsp;ie,<br />
<br />
myCommand.Parameters.add(&quot;<wbr />@value&quot;, myInt);<br />
myCommand.CommandText = &quot;SELECT * FROM table WHERE val=@value&quot;;<br />
somereader = myComand.ExecuteReader();<br />
<br />
It's a long story why I'm asking....would this throw an exception?
</div>
</div>


Is it ok to set the parameters of an SqlCommand before they appear in the command text?  ie,

myCommand.Parameters.add("@value", myInt);
myCommand.CommandText = "SELECT * FROM table WHERE val=@value";
somereader = myComand.ExecuteReader();

It's a long story why I'm asking....would this throw an exception?

parameterized queries

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).