C# - SQL Connection In An Application Should Be Called?

Aug 24, 2010

I have an application written in c# and I am using the sqlClient to connect to database. I have several methods and I usually open the connection in a try catch block

try{
**open connection**
//Mehod1()
//Method2()
........
}catch(exception){
//Do something
}finally{
**close connection**
}......................

View 3 Replies


Similar Messages:

MVC :: GetJson Not Called In A Web Application?

Apr 13, 2010

I am trying to make my ASP.NET MVC 2 application working from a test server.

Since I am using IIS 6 in my test server, I have to define in the Global.asax.cs file:

routes.MapRoute(
"Default", // Route name
===> "{controller}.aspx/{action}/{id}", // URL with parameters
new
{
controller = "Home",
action = "Index",
id = UrlParameter.Optional
} // Parameter defaults
);

This complicates the correct definition of the URL in my getJson() calls for my site production version.

When running my site from the test server, I found using Fiddler that the URL reguested by the browser

for getJson() calls is:

/Controller.aspx/Controller Method

which is correct, but probably, not the complete necessary path for getJson() to work.

I think that this is the reason for getJson() calls to give "Page Not Found(404)" in Fiddler and a syntax error in FireBug and to be skipped completely when trying to execute. Of my understanding the complete path should be:

/My Site/Controller.aspx/Controller Method

I use jQuery 1.4.2.

View 5 Replies

JQuery Function Called Over And Over In MVC 2 Application?

Jan 6, 2011

I want to call an action method when an textbox gets focus to get a description of the model object that field is associated with from a database.

I have this jQuery function:

[code]...

It works fine as far as getting the test text, but the problem is if I set a breakpoint in the action method, I see that it gets called over and over, not just when i change focus in the text boxes...

View 1 Replies

Web Forms :: Why Page_load Is Called Twice In Web Application

Mar 29, 2010

Initially in my website page_load for the landing page say test.aspx was called twice everytime when it was getting loaded. Since my application is an upgraded one (from VS 2003 to VS 2005/2008), I commented the "this.load" event in InitializeComponent and it is working fine, when user first logs in, into my web application. But then, whenever user navigates to this page from any other page in my application, page_load gets called twice.

View 9 Replies

C# - Called Generated Web Test Code From Console Application?

Feb 16, 2010

I had a general question about extracting code from a visual studio web test. I used the "generate code" option of a web test and got the following:

[code]....

What I wanted to do is basically put this test into a separate service to run throughout the day for purposes of health checking. I basically want to make sure that users are able to log in throughout the day. What process should I use to get the test into something like a console app? I was running into issues with debugging the webtest code.

View 1 Replies

MVC :: Application_start Event Called Multiple Times In Application

Sep 15, 2010

In my MVC application ,I am updating my web.config at runtime through application_start event.So, ideally it should be done only when the application is started.BUT in MY mvc application the application_start event of global.asax is being called multiple
times , even when i have not restarted the application.

Its being repetadly called when i am calling different actions , so the webconfig is repetedly updating & making my application very very slow. what's the reason & how to handle this .

View 2 Replies

How Many Times Does HttpModule Init() Method Get Called During Application's Life

Jul 30, 2010

Web application initialization is as follows:

As we know when IIS receives the first request for a particular Asp.net application resource, IIS creates an instance of a HttpApplication (defined in global.asax codebehind).When this new instance is created it's initialization happens that also checks all configured HTTP modules.All modules are then instantiated and put in the application's Modules collection (of type HttpModuleCollection)modules are looped through and their Init() method is called (when they register for request events)

As far as I understand it the above scenario happens when a web application is started/initialized (hence application start event).What happens with modules?

Are they (re)instatiated on each request or reused from the Modules property on each consecutive request while the web application is alive? As I understand IIS and Asp.net they are reused through the whole life of a web application.

If they are reused, can we assume that their Init() method is actually a pseudo event handler for application start event? The thing is we can't attach to application level events within http modules. But if they are being reused we could use Init() as application start event and do whatever we'd put in global.asax instead.

Question,Can we assume that module's Init() method is called only on application start event? Could we use this assumption to i.e. register routes for applications whose global.asax codebehind we can't change? web.config is usually accessible and we can change it the way we want.Would this actually work?

Additional info,We can check HttpApplication code and check its InitModulesCommon() method. This one actually calls Init() of each registered HTTP module. What is more interesting is that this method is only used by InitIntegratedModules() and InitModules() methods. Which are both used only in HttpApplication.InitInternal() method. This is the basis of my assumptions, but I would like to know whether someone has abused IHttpModule.Init() for application start event.

View 3 Replies

Web Forms :: How Do You Obtain The Absolute Web Application Path In Class Called From A Referenced Dll In A We...

May 1, 2010

I have a class (.cs) in my web application project called CompanyResponseInfo.cs. This class inherits from a class called, ResponseInfo.cs, which is from a class library which is referenced as a compiled dll in the web application. CompanyResponseInfo is called from the ResponseInfo base class. In the CompanyResponseInfo class I need to build a file path to a file that resides in the directory 'web root/resources/standard.xslt'.

Now i know that because CompanyResponseInfo is instanciated from within the inherited ResponseInfo class from a referenced library, the 'System.Web.HttpContext.Current' object is null so I cannot gain access to MapPath and all the other Server object properties for me to obtain path properties relating to the web application.

I have also tried using 'System.Web.Hosting.HostingEnvironment.MapPath' which did work locally, but when I put the web application on our test IIS server it never worked correctly as it seemed to use the path in which IIS resides.

I guess this would be a common problem, so what are my options in my case when I need to get the absolute web application path so I can use it to get the absolute path for a XSLT file so I can load it into the XslCompiledTransform.Load()?

View 3 Replies

Visual Studio :: Error Unable To Add Data Connection. ExecuteScalar Requires An Open And Available Connection. The Connection's Current State Is Closed?

Sep 13, 2010

I'm using Visual Studio 2008, and my database is SQL Server 2000.

I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.

But when I click OK, I get the error:

Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.

View 3 Replies

ADO.NET :: LINQ And Web Application Connection Strings

Dec 25, 2010

i want define connectionSreing in the web.config and then use it for DataContext ConnectionString. i do that : 1. i creat a class in App_Code :(MisaghDB is my database)

partial class MisaghDataContext
{
partial void OnCreated()
{
this.Connection.ConnectionString =
ConfigurationManager.ConnectionStrings["MisaghDBConnectionString"].ConnectionString;
}
// or
public partial class MisaghDataContext
{
public MisaghDataContext() : base (ConfigurationManager.ConnectionStrings["MisaghDBConnectionString"].ConnectionString)
{
OnCreated();
}
}
}

2. Add the connection string to my web.config file:

<configuration>
<connectionStrings>
<add name="MisaghDBConnectionString" connectionString="Data Source=NAZLIN-HP;Initial Catalog=MisaghDB;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>

3. Right click on the DBML file design surface and chose properties. Select "none" for the Connection property.now should i change DBML file designer.cs (Misagh.designer.cs) ? The code should I delete in this file(DBMLfile designer.cs)? this is a part of my DBMLfile designer.cs :

[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="MisaghDB")]
public partial class MisaghDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
public NorthwindDataContext() :
base(global::WindowsFormsApplication2.Properties.Settings.Default.NorthwindConnectionString, mappingSource)
{
OnCreated();
}
public NorthwindDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public NorthwindDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public NorthwindDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public NorthwindDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
............}

View 4 Replies

SQL Server :: Use Connection Strings From IIS In C# Application

Sep 20, 2010

I have a C# web service where I need to access a MS SQL DB. I see a way of creating a connection string in IIS and using it in the web application when connecting to the DB. In IIS in Connection strings you specify the name of the connection, server, user n pwd How can I use the name of connection string created in IIS in my c# app.? I am currently using

CustomerInfo
customerinfo = new
CustomerInfo();
// to return
using
(SqlConnection
connection = new
SqlConnection("server=servername;
initial Catalog=eostartest; Integrated Security=SSPI"))
{...

But I would like to use the name of the connection string created in IIS Connection Strings manager. Do I have to add something in the web.config as well?

View 2 Replies

HTTP Connection Be Passed From IIS / ASP To Another Application Or Service?

Dec 20, 2010

I'm looking into building an ASP.NET MVC application that exposes (other than the usual HTML pages) JSON and XML REST services, as well as Web Sockets. In a perfect world, I would be able to use the same URLs for the Web Sockets interface as I do for the other services (and determine which data to return by what the user agent requests) but, knowing that IIS wasn't built for persistent connections, I need to know if there's a way that I can accept (and possibly even handshake) the Web Sockets connection and then pass the connection off to another service running on the server. I do have a workaround in mind if this isn't possible that basically involves using ASP.NET to check for the Web Sockets connection upgrade headers, and responding with a HTTP/1.1 302 Found that points to a different host that has my Web Sockets service configured to directly listen to the appopriate endpoint(s).

View 4 Replies

Web Forms :: Put Connection String In Application - Encrypt?

Aug 26, 2010

i want to ask about the best place to put my connection string in my web application and also how to encrypt it?

View 1 Replies

Sql - Connection Pool Confined To At The Application Level?

Apr 28, 2010

Does the same connection string used on two different physical servers hosting different web applications that talk to the same database draw connections from the same connection pool? Or are pooled connections confined to at the application level?

I ask because I inherited a 7 year old .NET 1.1 web application which is riddled with in-line SQL, unclosed and undisposed sql connection and datareader objects. Recently, I was tasked to write a small web app that is hosted on another server and talks to the same database and therefore used the same database connection string. I created a LINQ object to read and write the one table required by the app. Now the original .NET 1.1 app is throwing exceptions like

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

Maybe these are unreleated, but wanted to get your opinions to make sure I cover all my bases.

View 2 Replies

Configuration :: Application Deployment - Database Connection?

Sep 28, 2010

I finished an intranet application using webconfig to store my connection string to an Access database which has linked tables to SQL Server 2005.

Everything works perfectly, but when I publish the application on a IIS server service, it seems like all connections fail... :(

I looked up on internet but found nothing on this. I think my webconfig file is correct :

[Code]....

View 16 Replies

SQL Server :: Close DB Connection Upon Application Termination?

Nov 19, 2010

The reason this question came up, is because if I run my website application with a SQL Server data store, and I terminate the browser (terminating the session), I try to open up SSMS to edit the DB. But I can't access the database because I believe there is still an open connection, even after application termination.

Is it recommended to close the database connection upon session/application closing? Or am I way off on what I'm thinking could be the problem?

View 15 Replies

Web Config - Where Should Connection Strings Be Stored In A N-tier Application

Sep 29, 2010

I have an ASP.NET project which is pretty n-tier, by namespace, but I need to separate into three projects: Data Layer, Middle Tier and Front End.

I am doing this because...

A) It seems the right thing to do, and

B) I am having all sorts of problems running unit tests for ASP.NET hosted assemblies.

Anyway, my question is, where do you keep your config info?

Right now, for example, my middle tier classes (which uses Linq to SQL) automatically pull their connection string information from the web.config when instantiating a new data context.

If my data layer is in another project can/should it be using the web.config for configuration info?

If so, how will a unit test, (typically in a separate assembly) provide soch configuration info?

View 3 Replies

C# - Connection Property Hasn't Been Initialized While Running Application From IIS

Apr 4, 2011

I have one intranet based application.I have set windows authentication for it in Web.config as well as from IIS settings. While running my application through the source code, it works fine but while running from directly IIS then its giving me:

"Connection property has not been initialized"

View 1 Replies

C# - How To Run Web Application With Encrypted Web.config/cannot Read Connection String

Mar 19, 2011

How to run asp.net application with encrypted web.config ,is it possible note that ASP.NET application have a database with encrypted connectionstring and a "cannot read connection string " message is generated

View 2 Replies

Forms Data Controls :: Use A Single Connection In One Web Application?

Mar 8, 2010

How can i use a single connection in one web application. Right now i have to create a different connection for every data interchange with SQL. For example: For inserting a data i am creating a connection on button click event. And for fetching a record, i have to create a different connection for data grid view. create a single connection and can use the same connection under complete application.

View 5 Replies

Application Block Connection String From Data Access Layer

Jun 4, 2010

I am making use of 3-Tier architecture while making my project. And in Data Access Layer I am making use of application block, but application gets a connection string from web.config; but ClassLibrary of Data Access Layer doesn't contain web config file. How can I access connection string from Data Access layer?

View 5 Replies

Is It Acceptable To Cache An Instance Of The Database Connection On Application Start

Jan 5, 2010

Is it acceptable to cache an instance of the database connection on application start?

Looking at the MSDN documentation on thread safety, I quote:

Any public static [...] members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Given that, is it acceptable/safe for code such as this example below:

[code]...

View 1 Replies

Web Forms :: Web Parts Connection / Server Error In '/ Webparts' Application?

Feb 26, 2010

I am using ASP.NET 2.0 and SQL Server 2005. I am new in web parts.I used simple calender control in web part zone it is showing an error.web part manager is also in web page.

I did not use any database connection .

Server Error in '/Webparts' Application.

--------------------------------------------------------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

SQLExpress database file auto-creation error:

The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.

Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.

View 2 Replies

Pros/cons Of Reading Connection String From Physical File Versus Application Object

Apr 9, 2010

my ASP.NET application reads an xml file to determine which environment it's currently in (e.g. local, development, production).

It checks this file every single time it opens a connection to the database, in order to know which connection string to grab from the Application Settings.

I'm entering a phase of development where efficiency is becoming a concern. I don't think it's a good idea to have to read a file on a physical disk ever single time I wish to access the database (very often).

I was considering storing the connection string in Application["ConnectionString"].

[code].....

I didn't design the application so I figure there must have been a reason for reading the xml file every time (to change settings while the application runs?) I have very little concept of the inner workings here. What are the pros and cons?

View 2 Replies

Web Forms :: How To Take Application Near Clock Icon,near Local Area Connection Icon In Running Mode

Jul 8, 2010

i am develpping a alarm application when user minimized this it should be minimized appear near the system clock,local area connection icon(as hidden icon).

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved