ADO.NET :: Closing Sql Connection Properly And Handle Errors?

Mar 31, 2011

This morning I found myself dealing with A SQL POOLING ERROR 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. I did fix this with resetting my pooling and setting a pooling max =100 Anyway now Im starting to rethink how I open connections, dealing with errors and proper closing of connections Would you say this code below is a good way of opening, closing connections (even when errors occurred)

Dim Connection As SqlConnection
Dim myConn As String = (ConfigurationManager.ConnectionStrings("MyConnString").ConnectionString)
Connection = New SqlConnection(myConn)
Try
Dim DBCommand As SqlCommand
Dim dt As New DataTable()
Dim myDataSet As New DataSet
Connection.Open()
DBCommand = New SqlCommand("GetAllCategories_", Connection)
DBCommand.CommandType = CommandType.StoredProcedure
DBCommand.Parameters.Add("@HomePageID", SqlDbType.Int).Value = HiddenChosenVirtualMainID.Value
Dim mySqlAdapter As New SqlDataAdapter(DBCommand)
mySqlAdapter.Fill(dt)
SecondLevelChildDatalist.DataSource = dt
SecondLevelChildDatalist.DataBind()
Catch ex As Exception
'Error goes here
SqlConnection.ClearAllPools()
Finally
'close the connction
Connection.Close()
Connection.Dispose()
End Try

View 5 Replies


Similar Messages:

ADO.NET :: Properly Closing Connection To SQL

Jan 17, 2011

I'm trying to make sure a block of code behind properly closes a connection to SQL after it's finished. But when I add the line "cmd.Connection.Close();" Visual Studio underlines "cmd" in green and says "unreachable code detected" What does that mean and how do I correct it?

[Code]....

View 4 Replies

Access :: Closing Datasource Connection?

Jul 20, 2010

I am using a AccessDatasource for getting values from a accessdatabase for a Dropdown list. After i load the page and close it, a .ldb file is created. After wards i am not able to open the database manually. How to close the connection. I have given Network service Modify access [URL] to share permission, still no go.

View 3 Replies

How To Handle Errors On Server Logs

Dec 30, 2010

I am seeing a lot of these errors on the server logs.

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 12/29/2010
Time: 9:16:28 AM
User: N/A
computer: LFIWEB1
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/29/2010 9:16:28 AM
Event time (UTC): 12/29/2010 3:16:28 PM
Event ID: 7843d62e326c41f1a7c819ec2b362418
Event sequence: 549
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1733199574/Root/ComfortlinkNET-1-129381012604990336
Trust level: Full
Application Virtual Path: /ComfortlinkNET
Application Path: D:WebappsComfortlinkNet
Machine name: LFIWEB1
Process information:
Process ID: 3896
Process name: w3wp.exe
Account name: NT AUTHORITYNETWORK SERVICE
Exception information:
Exception type: InvalidCastException
Exception message: Conversion from string "cindye" to type 'Integer' is not valid.
Request information:
Request URL: xxxxxxxxxxxxxxxx
Request path: xxxxxxxxxxxxxxxxxx
User host address:xxxxxxxxxxxxxx
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITYNETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITYNETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)

View 3 Replies

How To Handle Errors During Async Postbacks

Jan 5, 2010

We have an ASP.NET page which uses an update panel for partial page postbacks. On the server side, the postback performs some database work and updates several UI elements. The database code is all contained in several transactions, so the state will still be consistent if an exception is thrown. We're working on some error handling code now, and my first thought was to log the exception thrown, reload the last consistent UI state, and show some sort of modal popup or other ui element with a brief error message for the user (this is an intranet page, so we're automatically notified of the bug, and the users know where to find us.

View 1 Replies

C# - Handle Errors On Certain Pages Differently?

Mar 28, 2011

I have an Application_Error handler in my Global.asax file. However, I load many pages using an XHR request and would rather these "sub pages" return javascript or a real 500 code for my main app to process, rather than an error page.

Is it possible to handle errors on certain pages in a different way? Can a master page handle its own errors in a page extending it without bubbling it up to Global.asax?

View 4 Replies

Web Forms :: How To Handle 404 Errors When Using URL Routing

May 7, 2015

I have been using using System.Web.Routing for url routing in global.asax file  code is as below.

public static void RegisterRoutes(RouteCollection routes) {
routes.MapPageRoute("Home", "", "~/Home.aspx");
routes.MapPageRoute("Posts", "Posts/{blog_url}", "~/blog-description.aspx");
}
protected void Application_Start(object sender, EventArgs e) {
RegisterRoutes( RouteTable.Routes);
}

Now this works fine on local  but when i move the same to live it shows error 404 .I want to create a log actually what url is called.

View 1 Replies

ADO.NET :: Closing Connection To Table After Executing SQL To Delete A Record?

Aug 4, 2010

I have written a routine to delete a record from a table. I want to include a statement to 'close' the connection to the table but I do not know the syntex of the statement that will do this. My code is as follows:

[code]....

View 2 Replies

How To Handle 403.9 HTTP Errors In The Web.config File

Nov 23, 2010

Do anyone of you know how to handle XXX.X IIS HTTP errors in a web.config file? I tried doing the following:

<customErrors mode="On" defaultRedirect="error.aspx">
<error statusCode="403" redirect="error403.aspx" />
<!--NOTE: The following does not work-->
<error statusCode="403.9" redirect="error403.9.aspx" />
<!--ENDNOTE-->
<error statusCode="404" redirect="error404.aspx" />
</customErrors>

But obviously that didn't worked, because the web.config file expects an integer as the statusCode value.
CONTEXT: WinServer 2003 - ASP.NET 3.5

View 1 Replies

AJAX :: How To Handle Errors / Exceptions During Postback

Mar 27, 2010

I really want to switch over to ajax, but i can't seem to get my error handlling perfect. If i can't handle errors correctly, I just can't use it. What I really want to happen is to do a full refresh of the Top Frame. How I normally do this is by a similar call to Response.Write(<script>top.location.href = ""</script>). I was currently doing this in Global.asax. This becomes a problem when I error out in an AJAX postback. I've also noticed that There is an AsycPostbackErrorHandler you can attach to the ScriptManager. This is all find an dandy, but it will still hit my Global.asax Application_Error Event.

I am honestly just not sure how to handle this.

As I said, the result I want is....To Reload the Top Frame with some Error Message...whether I have to do some weird redirection or whatever. My problem lies specifically with the Global.asax file.

View 2 Replies

Handle Errors At Application Or Server Level?

Sep 28, 2010

When setting up asp.net error handlers for things like 404 errors, it is more 'efficient' to do this in IIS, or handle it in the Global.asax Application_Error event? I know the latter will be called, and I want to log this information in a database, but should I then just return without any redirect and let IIS do the redirect, or would it be better to do a response.redirect inside application_error once we've logged it?

View 1 Replies

C# - Handle All Errors/messages In One Place On Page?

May 7, 2010

On my site I put things in Web user controls. For example, I will have a NewsItem Control, an Article Control, a ContactForm control.These will appear in various places on my site.

What I'm looking for is a way for these controls to pass messages up to the Page that they exist on.

I don't want to tightly couple them, so I think I will have to do this with Events/Delegates. I'm a little unclear as to how I would implement this, though.

A couple of examples:

1: A contact form is submitted. After it's submitted, instead of replacing itself with a "Your mail has been sent" which limits the placement of that message, I'd like to just notify the page that the control is on with a Status message and perhaps a suggested behaviour. So, a message would include the text to render as well as an enum like DisplayAs.Popup or DisplayAs.Success

2: An Article Control queries the database for an Article object. Database returns an Exception. Custom Exception is passed to the page along with the DisplayAs.Error enum. The page handles this error and displays it wherever the errors go.

I'm trying to accomplish something similar to the ValidationSummary Control, except that I want the page to be able to display the messages as the enum feels fit.

Again, I don't want to tightly bind or rely a control existing on the Page. I want the controls to raise these events, but the page can ignore them if it wants.I'd love a code sample just to get me started.

I know this is a more involved question, so I'll wait longer before voting/choosing the answers.

View 3 Replies

Web Forms :: How To Handle Not Found Errors When Using URL Routing

May 7, 2015

I have a small problem:

Example:

RouteCollection routes
routes.MapPageRoute("Product","{ProductName}","~/Product.aspx")
Address on browser:
localhost:port/Software/VisualStudio

Error: HTTP Error 403.14 - Forbidden (because that Route is not exists).

How can i catch errors when routes are incorrect or not exist?

View 1 Replies

Databases :: Write Logs Without Opening And Closing The Oracle DB Connection?

Oct 28, 2010

I am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs

Method1 Connect (
Try{
Conn.open ()

[code]...

View 7 Replies

Closing-routine / Close Connection Command After Getting Data From The Database?

Oct 4, 2010

I am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?

View 2 Replies

SQL Server :: Implications Of Not Closing An Open Connection Declared Locally?

Oct 5, 2010

I was wondering about something. I'm supporting a .NET C# application which has a number of database connections declared locally as IDbConnection with MS SQL Server and NHibernate. These connections are declared locally and not explicitly closed after a specific operation is performed. Are these connections automatically closed after the local method is executed, or could these connections be floating around somewhere? We're having semaphore max out problems, and I'm trying to see if this may be the culprit. I'm doubtful, as I believe these connections would automatically close, but thought I'd throw out hte possibility.

View 1 Replies

Httpresponse - How To Handle Errors When Using C# To Create A Zipfile For Download

Oct 29, 2010

I'm working on a functionality in my asp.net web site that enables the user to download some files as a zip file. I'm using the DotNetZip library to generate the zip file.

My code looks like this:

protected void OkbtnZipExport_OnClickEvent(object sender, EventArgs e)
{
var selectedDocumentIds = GetSelectedDocIds();
string archiveName = String.Format("archive-{0}.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
AddResponseDataForZipFile(Response, archiveName);
try
{
string errorMessage = Utils.ExportToZip(selectedDocumentIds, arkivdelSearchControl.GetbraArkivConnection(), Response.OutputStream);
if (!string.IsNullOrEmpty(errorMessage)).......

Now, if anything goes wrong, say the Utils.ExportToZip method fails, I want to present an error message to the user and not the download dialog. Do I have to remove some data from the Response object in order to cancel the download operation?

View 2 Replies

ADO.NET :: Handle Errors In Data Access Layer Code?

Feb 28, 2011

I am learning on how to create data access layer code for a web site. I want to ensure I am actually connecting to the datasource, so, I am wanting to use a try/catch block within my data access layer class methods. What I am not sure how to handle is a case where the connectionstate is not open. The method should ideally return a datatable. If an error is thrown would I just return an empty datatable? That is my first thought. My other thought is to return an object and pass a datatable if the connection succeeds or the exception if the connection fails.

View 10 Replies

DataSource Controls :: SqlDataSource Connections Not Closing Maxing Out Connection Pool?

Jul 28, 2010

i have a web application that use a MySql DataBase. In a page, i have used the sqlDatasource control. The problem is that the conection with the database doesn't closed and i have a lot of open conections until show me the error that says me that the conection pool is full.

[code]....

View 9 Replies

VS 2008 How To Handle Null Datetime Values Properly

Oct 25, 2010

I have a class with properties for stuff like FileNumber, OpenedDate, ClosedDate etc.When I Initialise the class I set the datetime variables to Date.MinValue.Then when I populate my textboxes I check if the value of the date variables are Date.Minvalue and I set the textbox text to an empty string.

Code:
If(File.OpenedDate = Date.MinValue, String.Empty, File.OpenedDate.ToString("yyyy/MM/dd"))
However whe I try to save the data to my sql server db I get a datetime out of range error. What is the correct way to handle these null values in my date columns?

View 9 Replies

MVC :: Is There Any Sample Or Guideline Shows How To Properly Handle Session Timeout In Applications

Mar 24, 2011

Is there any sample or guideline shows how to properly handle session timeout in MVC applications?

View 4 Replies

DataSource Controls :: Connection Errors

Mar 7, 2010

Connection Errors

[Code]....

View 5 Replies

Access :: Database Connection Gives Weird Errors?

May 11, 2010

I am trying to do a login page which checks username and password from access database. I think my code is almost done but i am getting some weird error which i just can't decipher where it exactly comes from, as i think i already have every return value it needs. Can anyone check this function and tell me if there is something i am missing or doing wrong? And the error i get isDBConnection(string, string)': not all code paths return a value

[Code]....

View 3 Replies

DataSource Controls :: Connection Strings Errors On Compile

Jun 8, 2010

I have a drop down with different domains(domain_id column) and a textbox (TextBoxComment) for comments. What I am trying to do is select the area, input a comment, click the button and have it save to the db. My connection string errors on compile.

[Code]....

View 8 Replies

Databases :: Mysql Odbc Database - Syntax / Connection Not Close Errors

Aug 18, 2010

[Code]....

I can check whether username exists or not successfully but not for email. any ideas why it isn't working? Error message was that i did not close my connection. using System;

View 1 Replies







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