I have a sub routine where I pull in information from a database. I want to use variables from this sub routine in another sub routine. I tried making everything public but it doesn't want to be friendly and share.
Dim strEmail as String Public Sub readDB() strEmail = "email@example.com" End Sub Public Sub submit_btn(ByVal sender As Object, ByVal e As EventArgs) Response.Write(strEmail) End Sub
The readDB would read the database and set the variables and do whatever it needs to do. Then when they submit the form it would e-mail the form to whatever the email address was.
Every time an asp.net page loads, the global variables are wiped out. You can avoid this by using Session variables.