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 |
Rate yourself in .net and sql database?
1 Answers BrickRed, Infosys, Satyam, SP Software,
How Web Services help Us? What r the difference between Remoting and webservices
5 Answers Protech, TCS, Tech Mahindra,
What is the difference between a multi-layer and multi-tier applications?
I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.
How you will manage the state of ASP.NET controls?
0 Answers Sans Pareil IT Services,
What type of code (server or client) is found in a Code- Behind class?
what are the application layers for a distribute application?
Is object a value type or referenced type?
What does ascx stand for?
What is X-Path?
what is AutoEventWireUp and what is the use of This property explain in details?
suppose i am Admin in my application and i have to terminate the session of the particular user in my application.........how can i do it....?????
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)