Where to add the Include File

[Steven K]

Hello,

I have an include file (../../Connections/pricex.inc). That I use to
declare my variables and build my connection string. I tried using the
following, but got the error: Compiler Error Message: BC30188: Declaration
expected. If I move "Response.WriteFile" statement into the sub block, I
get the error that my variables are not declared.

My question is, where and how do I add the include file?
<script runat="server">
Response.WriteFile ("../../Connections/pricex.inc")

Sub Page_Load(Sender As Object, E As EventArgs)

spSearch = New SqlDataAdapter("sp_web_Search " &
"'FindRegionSubRegion','','',''", cnnSearch)
spSearch.SelectCommand.CommandType = CommandType.StoredProcedure

'Close Out the connection
spSearch = Nothing
cnnSearch.Close : cnnSearch = Nothing
End Sub
</script>

--
Thanks in advance,

Steven

[Simon Gorski]

Hello Steven,
"Steven K" <sk****@troop.com> schrieb im Newsbeitrag
news:uz**************@TK2MSFTNGP12.phx.gbl...

Hello,

I have an include file (../../Connections/pricex.inc). That I use to
declare my variables and build my connection string. I tried using the
following, but got the error: Compiler Error Message: BC30188: Declaration expected. If I move "Response.WriteFile" statement into the sub block, I
get the error that my variables are not declared.

My question is, where and how do I add the include file?

Don't use include files!!!!!!!!!!!!!

first the are not secure! - everybody can read them .... try in the internet
explorer ---> connections/pricex.inc...!!

Make a connection class!

mfg simon g.

[John Timney \(Microsoft MVP\)]

I dont think you can do what you are trying to do - variables cannot be
declared like this in .net. You could put them in a class, and invoke an
instance of the class, referencing the variable properties in the class
instead. Then they would be available in your page events.

Regards

John Timney
Microsoft Regional Director
Microsoft MVP

I have an include file (../../Connections/pricex.inc). That I use to
declare my variables and build my connection string. I tried using the
following, but got the error: Compiler Error Message: BC30188: Declaration expected. If I move "Response.WriteFile" statement into the sub block, I
get the error that my variables are not declared. <script runat="server">
Response.WriteFile ("../../Connections/pricex.inc")

Sub Page_Load(Sender As Object, E As EventArgs)

spSearch = New SqlDataAdapter("sp_web_Search " &
"'FindRegionSubRegion','','',''", cnnSearch)
spSearch.SelectCommand.CommandType = CommandType.StoredProcedure

'Close Out the connection
spSearch = Nothing
cnnSearch.Close : cnnSearch = Nothing
End Sub
</script>