I want to write sqlconnection code in global.asax (application on start) so that I need not to repeat the code again and again in the web pages. Please try to help me with code example. Thank U.

With Regards,
S. Karthikeyan

What do you need help with? Connecting to a database or coding in the global.asax?

I shoudl note- Making a global data connection on the Application start is a VERY BAD idea.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

You should do it in the web.config file in your root directory... add a key/valuepair with the connection string and then reference it. Not got the code to do that myself as i choose to write a connection in a user control and then just reference that.

use this string if its access

dim theconnection as string = "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("thedatabasefile.mdb")

i find that a much more reliable way of connecting up to a database...