RE: Parameterized components?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Steve,

Its not too hard to do that, in the designer,
1) Right-click the DataAdapter,
2) Click on the SelectCommand property
3) Click on elipsis button [...] on the CommandText property

a designer will popup that looks like the MS Access SQL designer,
you can now modify the SQL to your hearts content.

HTH,
Jorge L Matos

"Steve N." wrote:

> I'm following the walkthroughfor creating a Web Application:
> ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/vsintro7/html/vxwlkWalkthroughCreatingWebApplicationUsingVisualCOrVisualBasic.htm
>
> The application uses a component where data adapters are dropped onto the
> component designer, and then code behind is used to fill the datasets, which
> are then accessed by dropping a dataset onto the designer view of the .aspx
> page. What if I wanted to parameterize the data adapter's SQL statement, so
> that rather than getting ALL the records in the table, I could get only the
> records I wanted through the .aspx page?
>
> I haven't seen anything about this in any of the walkthrough's and it seems
> like I'm the only person posting this question on the internet. Is it
> possible, or was there a faux pas in using components to develop a web app?
.

Quantcast