Global Variables (Global.asax)

[nevets2001uk]

Hi.

I want to create some global variables for my ASP.NET application. I believe I can set them in the global.asax file. I am currently using this code for the file...

<Script Runat=&quot;Server&quot;>

Sub Application_Start

Dim conParts as OleDbConnection
Dim cmdSelectPart as OleDbCommand
Dim dtrPart as OleDbDataReader

End Sub

</Script>

When I run the pages the variables are creating un-defined errors. Is there something extra I should do? Or am I completely on the wrong track?

Thanks

 

[Custom24]

Use Friend or Public rather than dim
And you don't need to put them in Global.asax - any class or module will do.



Mark

 

[krispradez]

ASP.NET do not support the PUBLIC variable decalarion in a module just like what we're used to in VB. intead use the Application State.

Sub Application_Start
application(&quot;var1&quot = &quot;value1&quot;
application(&quot;var2&quot = 2
application(&quot;var3&quot = false
application(&quot;IsUserAuthenticated&quot = false 'very handy
End Sub

just like a session object, but this one fires whenever a user attempts to view any page of your virtual directory.

i noticed on your example that you want sql connections be globally, im not sure if that's possible but i think that it's not appropriate since you could hang the connection to sql server forever or for the time of your application running. which is of course, not good.

hope this helps.

 

[nevets2001uk]

Cheers! I forgot all about this post! I did eventually do it by just declaring the variables before the subs at the top of my asp.net code. Think I was explaining the initial problem in a bit of a round about way.

Thanks for everyones helps tho.