Global Variable for URL param recommendation

[Rob]

Please recommend best practice for adding a global
variable to an ASP.net class that will take on a
Request.Params( "") value from the URL calling the aspx
page to be used throughout in stored procedure calls as a
parameter in datagrids.

Currently, the best I came up with was to add code around
the Web Form Designer code of the Select statement that
defines the variable and sends it as a Parameter to the
stored procedure. However, Visual studio keeps
overwriting this code everytime I use the GUI tools on the
data objects. Using variable in Select Stored Procedure
paramater call in the Value area.

Is there a better/easier way to send the variable in the
GUI "control source" or value for the data adapter select
statement sp call?

Thank you,

Rob

----
'
'SqlSelectComma nd1
'
'RW - Attempt to globally define EmployeeID from
URL paramater for stored procedure
If Not (Request.Params ("EmployeeID ") Is Nothing)
Then
EmployeeID = Int32.Parse(Req uest.Params
("EmployeeID "))
Else
EmployeeID = "302"
End If
'/RW
Me.SqlSelectCom mand1.CommandTe xt
= "[spGetEmpAttach]"
Me.SqlSelectCom mand1.CommandTy pe =
System.Data.Com mandType.Stored Procedure
Me.SqlSelectCom mand1.Connectio n = Me.SqlConnectio n1
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4,
System.Data.Par ameterDirection .ReturnValue, False, CType
(0, Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, Nothing))
'RW
Me.SqlSelectCom mand1.Parameter s.Add(New
System.Data.Sql Client.SqlParam eter("@Employee ID",
System.Data.Sql DbType.Int, 4,
System.Data.Par ameterDirection .Input, False, CType(0,
Byte), CType(0, Byte), "",
System.Data.Dat aRowVersion.Cur rent, EmployeeID))
'/RW

[Tian Min Huang]

Hi Rob,

I think you could store the variable in a session or application state. So
you could get it throughout the web application.

For an example:
Session["EmployeeID "] = EmployeeID;
Application["EmployeeID "] = EmployeeID;

Please feel free to let me know if you have any problems or concerns.

Have a nice day!

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! ¨C www.microsoft.com/security
This posting is provided ¡°as is¡± with no warranties and confers no rights.