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.

No comments:

Post a Comment