Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Web address variable

Author  Topic 

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2007-09-13 : 08:19:43
What's it called when you inbed a variable into a web address?

Http:// www.mypage.com ?MyVar=123456789

And how do you pass it to the SP?

Jim
Users <> Logic

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2007-09-13 : 17:51:53
Its a querystring, you can pass it to sql like any other variable

Dim myVariable as String = Request.Querystring("MyVar")

' sqlcode

MySqlCommand.Parameters.AddWithValue("@myVar",myvariable)

' etc

hope that helps
Go to Top of Page
   

- Advertisement -