Single Database, multiple queries!
Posted on 2006-05-27
I am brand new to Visual Web Developper 2005.
However, i have been able to create nice stuff.
Here is what i am unable to do, or let's say almost.
i have a databound control (tested with Textbox and gridview, both same behaviour)
linked to an Acessdatasource control called "Library1"
The Library1 control access the Something.mdb
I have created a query that goes something like this
SELECT * FROM [Info] WHERE ([Path] LIKE '%' + ? + '%') ORDER BY [Cleanname] DESC
What i want to do is manage the ? value to put anything (by code) so that the databound control gets refresh to displays the new data.
I am able to specify what the default value for ? is, and that works.
I have also created some additional queries, that are in fact the same, but with different default values ?.
Is there a way to switch from a value, or from a query to an other, or create multiple connection to the something.mdb file with there own query? so that depending of a value in a dropdown, the user gets a refreshed database with correct being sown.
Hope you can help!