<div>
Do you have the parameter already defined in the front end?<br />
<br />
sds_DataForPID.SelectParam<wbr />eters[&quot;PID<wbr />&quot;].Default<wbr />Value = lbx_PIDs.SelectedValue.ToS<wbr />tring();<br />
<br />

</div>


Do you have the parameter already defined in the front end?

sds_DataForPID.SelectParameters["PID"].DefaultValue = lbx_PIDs.SelectedValue.ToString();



<div>
<div class="content wysiwyg-content">
I have a sqldatasource that needs a parameter passed to it.<br />
<br />
the attached is not working. &nbsp;<br />
<br />
ideas?<br />
<br />
thanks<br />

<pre><code id="code-8205935">Session[&quot;PID&quot;] = lbx_PIDs.SelectedValue.ToString();

SqlDataAdapter da = new SqlDataAdapter(sds_DataForPID.SelectParameters.Add(&quot;@PID&quot;, TypeCode.Char, Session[&quot;PID&quot;].ToString()), sds_DataForPID);</code></pre>
</div>
</div>


I have a sqldatasource that needs a parameter passed to it.

the attached is not working.  

ideas?

thanks

SQL DataAdapter with parameter

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