To connect with the MS-Access Database it is simple when we work offline but when we make our site live we come across many problems.
So I will suggest that we should make use of global.asax to store our connection string instead of webconfig or any other place.
A small example is shown here
I have eliminated the angular bracket of script tag to display the Code. Sorry for the inconvenience.
<%@ Application Language="C#" %>
script runat="server">
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
}
void Application_End(object sender, EventArgs e)
{
// Code that runs on application shutdown
}
void Application_Error(object sender, EventArgs e)
{
// Code that runs when an unhandled error occurs
}
void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
Session.Add("string", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~") + "\\App_Data\\UCB.mdb");
Session.Add("login", "false");
Session.Add("Operation","");
}
void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
// Note: The Session_End event is raised only when the sessionstate mode
// is set to InProc in the Web.config file. If session mode is set to StateServer
// or SQLServer, the event is not raised.
}
/script>
--
Thanks and Regards
Meetu Choudhary
 Attachments
Global.asax (21722-91011-Global.asax)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|