db connection function

[Guest]

I have a sub named ConnectToDb which has my db connections commands in it.
When I call it from another page that sub routine will not execute and i can't connect to the DB via that sub.
why is it not allowing me to connect?

code:
public sub ConnectToDB()
conn.connectionstring = ConfigurationSettings.AppSettings("DB")
conn.Open
end sub

the code i'm calling it from
sub GetData()
db.ConnectToDB()

'code to call SP's and bind grids

end sub

nothing happens this way, why not?

 

[Bobby Ryzhy]

I have a sub named ConnectToDb which has my db connections commands in it.
When I call it from another page that sub routine will not execute and i can't connect to the DB via that sub.
why is it not allowing me to connect?

code:
public sub ConnectToDB()
conn.connectionstring = ConfigurationSettings.AppSettings("DB")
conn.Open
end sub

the code i'm calling it from
sub GetData()
db.ConnectToDB()

'code to call SP's and bind grids

end sub

nothing happens this way, why not?

The main thing that is wrong is that you are not passing the connection object back. To save yourself ALLOT of work - use the microsoft
data block. http://www.microsoft.com/downloads/...16-3271-42C2-B138-2891102590AD&displaylang=en


Bobby Ryzhy
bobby @ domain below
http://weekendtech.net