Showing posts with label subset. Show all posts
Showing posts with label subset. Show all posts

Wednesday, March 21, 2012

Html calling apsx - How to pass in a variable value?

I have a main page with splash screen and links to showmerecords.apsx

Showmerecords.aspx connects to a database and retrieves a subset of data based on a criteria. I want the criteria to be contained within the splashscreen call to the showmerecords.aspx.

If the criterias were "Green Baloons", "Red Baloons", "Yellow Baloons" I would want to have it like something like this:

<P>Providers</P>
<P>Providers</P>
<P>Providers</P
How can I write the apsx to accept the text value from the call?

In the aspx I would like to construct a sql call string like this:

"select from baloons where balooncolor = " & BaloonColorVar

I hope I have explained my intention clearly. Thanks to anyone for help.


Green Balloons


C#
"select from balloons where balloonColor = " + Request.QueryString["color"];

VB
"select from balloons where balloonColor = " & Request.QueryString("color")


USe your links like this:


'Green Baloons Providers

Then in your aspx you can check the querysting

in c#


"select from baloons where balooncolor = " + Request.QueryString["color"]

I am replying to an older thread.

I was wondering whether it is possible to pass more than 1 variable?

could you for example do something like

'Green Baloons Providers

effectively passing two variables. One is called provider and the second one is called QueryServer

Thanks for the information.