Obtaining a parameter from a Session variable

A  Sessionvariable stores a value on the Web server while the user is browsing the site.

The SqlDataSource control can read a value from a Sessionvariable and use it as a parameter value.

In the SqlDataSource control’s Property window, after selecting the SelectQuery property and clicking the ellipsis
button, choose Session in the Command and Parameter Editor, from the Parameter Source drop-down list.