1.can we add connection string in global.asax??????????
2.what are the default files included when we create new
web application????
Answers were Sorted based on User's Feedback
Answer / deepak
<%@ Import Namespace=”System.Data” %>
<%@ Import Namespace=”System.Data.Odbc” %> <script
language=”C#” runat=”server”>
void Application_Start()
{
//Connection string for SQL Server with trusted
connection
Application.Add (”DB_CONNECTION_STRING”,”DRIVER={SQL
Server};SERVER=ServerName;DATABASE=DataBaseName;Trusted_connection=yes;”);
}
void Session_Start()
{
//open connection to database
OdbcConnection cnConnection = new OdbcConnection
(Application.Get(”DB_CONNECTION_STRING”).ToString());
cnConnection.Open();
Session.Add (”DB_CONNECTION”, cnConnection );
}
void Session_End()
{
//a graceful disconnect
OdbcConnection cnConnection = (OdbcConnection)
Session["DB_CONNECTION"];
cnConnection.Close ();
}
</script>
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / ahmad dawood
Yes you Can add Connection string in Global.aspx in the
[Sub Application_Start] or in the [Sub Session_Start]
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / jerry joseph
Connection String can be stored as an Application Variable.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sandeep
it is possible only by using session but it is not
good practics
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / jom george
we can add connection string in global.asax
2. App_Data,Default.aspx,Webconfif are the default files when we create a new web applications.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chaitali
no,we can't add the connection string in global.asax..
global.asax is a text file,It is use to define the global
variable.
Is This Answer Correct ? | 1 Yes | 7 No |
Answer / himasankar
1)We can't add connection string in global.asax file. we can
create connection string in web.config file only.
2)global.asax,web.config,Default.aspx files and
app_code,app_data,app_themes folders.
Is This Answer Correct ? | 4 Yes | 12 No |
What is state management technique?
Name some asp objects?
What is the difference between ldap and active directory?
How would you turn off cookies on one page of your website?
What is the purpose of url encoding?
How to prevent client side validation from the ASP.NET validation controls?
What is Partial in ASP.NET 2.0?
What is Fragment Caching in ASP.NET?
2 Answers MCN Solutions, pspl, Wipro,
what are the attributes of sitemapnode?
What are the security types in asp.net?
how to use html code in asp source code?
How is mvc different from asp.net? : Asp.Net MVC