troubleshooting Question

selection from 2 dropdownlists

Avatar of zebrain777
zebrain777 asked on
ASP.NET
2 Comments1 Solution208 ViewsLast Modified:
Hi there,

Still a beginner but I'm moving on :-)
Ok, that's not interesting but now my 'problem'

I've a master- and contentpage. On the masterpage I've 2 dropdownlists, 1 with the ID's and 1 with e.g. Names. Both are from the same (msaccess) datasource.
Now I want to display the record details depending on what's choosen from 1 of the 2 ddl's

My question is how can I do that, is it possible to use an IF statement in the <SelectParameters> region ? ( see my code on what I've produced so far )

Regards
Rob

using VWD2008 / VB / MSAccess
<asp:AccessDataSource ID="AccessDataSource2" runat="server" 
                            DataFile="~/App_Data/inetds.mdb" 
                            SelectCommand="SELECT Id,Name FROM mytable WHERE (Id = ?)">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="DropDownList1" DefaultValue="" name="Id" 
                                    PropertyName="SelectedValue" Type="Int32" />
                            </SelectParameters>
                        </asp:AccessDataSource>
ASKER CERTIFIED SOLUTION
CtrlAltDl

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros