Retrieving a value from an url

[Rekha Venkat]

how do i retrieve a value from the URL. i need this value for a
select statement. example:

"SELECT Title from Suggestions WHERE SuggestionID=????"

the value of this id is not known and has to be taken from the url. so how do i go about doing this.What should i fill in for the ???? part?

[channaJ]

how do i retrieve a value from the URL. i need this value for a
select statement. example:

"SELECT Title from Suggestions WHERE SuggestionID=????"

the value of this id is not known and has to be taken from the url. so how do i go about doing this.What should i fill in for the ???? part?

What do you mean by 'retrieve a value from the URL'? Are you trying to retrive a value comming as a QueryString which is appended to the url? or Are you trying to read a value from a file stored in a known url?

[Rekha Venkat]

What do you mean by 'retrieve a value from the URL'? Are you trying to retrive a value comming as a QueryString which is appended to the url? or Are you trying to read a value from a file stored in a known url?

Thank u for the response. i will be more clear. i have 2 pages: default.aspx and default2.aspx. in my default.aspx page i have a report which has many customers id.on clicking a particular id he should be redirected to the dafault2.aspx page which shows the details of that customerID. so in the load event of my default2.aspc.cs page i am writing a query using the select statement which i showed earlier which will take value from the url when the user clicks a particular customerid.
ex: www.mywebsite/default2.aspx/?customerid=5
something like the above.
so in my query
"SELECT CustomerDetails from Customer WHERE CustomerID=????"
so what do i fill in that ??????
how do i retrieve the value from the url?
i hope i have made myself clear.thanking u in advance.

[channaJ]

Thank u for the response. i will be more clear. i have 2 pages: default.aspx and default2.aspx. in my default.aspx page i have a report which has many customers id.on clicking a particular id he should be redirected to the dafault2.aspx page which shows the details of that customerID. so in the load event of my default2.aspc.cs page i am writing a query using the select statement which i showed earlier which will take value from the url when the user clicks a particular customerid.
ex: www.mywebsite/default2.aspx/?customerid=5
something like the above.
so in my query
"SELECT CustomerDetails from Customer WHERE CustomerID=????"
so what do i fill in that ??????
how do i retrieve the value from the url?
i hope i have made myself clear.thanking u in advance.

Ok. What you are talking about here is QueryString. I'll take your example.
You are passing 'customerid=5' key value pair as a QueryString to the default2.aspx. So if you can take the value of it in 'Page_Load' event handler of default2.aspx you can perform your sql query right..?
Use the following code in your 'Page_Load' event handler.

string customerId = Request.QueryString["customerid"].ToString();

You'll have the value you passed in the variable 'customerId' :)
Hope this will make sence.

Channa