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>

Answer / ahmad dawood

Yes you Can add Connection string in Global.aspx in the
[Sub Application_Start] or in the [Sub Session_Start]

Answer / jerry joseph

Connection String can be stored as an Application Variable.

Answer / sandeep

it is possible only by using session but it is not
good practics

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.

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.

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.

Difference between datareader and dataset ?

4 Answers   Microsoft,

Difference Between ReadOnly and Constant Variable in compile time and Run Time.

3 Answers   Phoenix Technologies, Quadrant,

Why do we need Sessions?

0 Answers   QuestPond,

What is custom control. What is the difference between custom control and user control ?

1 Answers   Microsoft, Synergy,

Explain what is an assembly?

0 Answers  

Which validator control you use if you need to make sure the values in two different controls matched?

0 Answers  

Explain transparent caching with aop?

0 Answers  

How do you register the .Net Component or Assembly?

2 Answers   Accenture,

What is difference in .net 1.1 and .net 2.0?

0 Answers  

Is redux flux?

0 Answers  

What is a Cookie? Where is it used in ASP.NET?

0 Answers   MindCracker,

With example & diagram explain AutoPostBack.

2 Answers