Retrieving a session variable from a URL and using it in an SQL query

[kevcorn]

I am creating a movie review website for a project in visual studio...asp.net

The home page displays a table with the top news headlines. Each headline is hyperlinked to the ViewEntry.aspx page defining it with the id variable on the end such as ?id=2

To put it simple, my URL consists of

http://localhost:1672/.iis6/ViewEntry.aspx?id=15

Does anyone know how to take the 15 section of the URL, and use it in a query to display on the page?

The sql statement i have at the moment is;

SELECT * FROM [Latest_News] WHERE ([Id] = Session(id))

i would like to display only the data connected to the end value in the url

[shweta123]

Hi,

If you want to get the value for id , then you can use Request.QueryString for this.
e.g.

SELECT * FROM [Latest_News] WHERE ([Id] =" & Request.QueryString ("id") & "

I am creating a movie review website for a project in visual studio...asp.net

The home page displays a table with the top news headlines. Each headline is hyperlinked to the ViewEntry.aspx page defining it with the id variable on the end such as ?id=2

To put it simple, my URL consists of

http://localhost:1672/.iis6/ViewEntry.aspx?id=15

Does anyone know how to take the 15 section of the URL, and use it in a query to display on the page?

The sql statement i have at the moment is;

SELECT * FROM [Latest_News] WHERE ([Id] = Session(id))

i would like to display only the data connected to the end value in the url