<div>
You can still use the same wizard to provide parameters <br />
after the first step &quot;Connection step&quot; the second step the wizard will show 3 buttons Where, Order By and Advanced<br />
if you click on the where button you will get the option to select params<br />
Column, Operator and source <br />
once you select the first param you have to click on Add to add it <br />

</div>


You can still use the same wizard to provide parameters
after the first step "Connection step" the second step the wizard will show 3 buttons Where, Order By and Advanced
if you click on the where button you will get the option to select params
Column, Operator and source
once you select the first param you have to click on Add to add it


<div>
And then in the code behind, what do I do?
</div>


And then in the code behind, what do I do?

<div>
The problem is I am building my own SQL Statement in the DataSource.<br />
<br />
When I select that option....the Advanced button becomes disabled.
</div>


The problem is I am building my own SQL Statement in the DataSource.

When I select that option....the Advanced button becomes disabled.

<div>
<div class="content wysiwyg-content">
From the Toolbox I have selected a SqlDataSource. &nbsp;It has a wizard for building the Select statement, but how do I provide parameters to this Select statement at runtime? &nbsp;What does my Select statement look like and what do I need to do in the code behind?<br />
<br />
I need detailed steps.<br />
<br />
Thanks!<br />
<br />
Tom
</div>
</div>


From the Toolbox I have selected a SqlDataSource.  It has a wizard for building the Select statement, but how do I provide parameters to this Select statement at runtime?  What does my Select statement look like and what do I need to do in the code behind?

I need detailed steps.

Thanks!

Tom

Using SqlDataSource - but how do I provide it with parameters at runtime?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications