When I drop a SqlConnection on the web form designer, it's created in
InitializeCompo nent. I'd like to use this connection in my Page_Load
method, but I don't see anywhere that it's opened. Do I need to open
it myself? If so, should I close it also, or will I be interfering
with databound controls that use it? If I want to use it in PostBack
methods should I re-open it, or leave it open in Page_Load?
It seems that I would like to have a connection open for the duration
of the page, but I don't know any way to do that while guaranteeing
that it gets closed in case of an error. What is the best practice for
using a connection in Page_Load, PostBacks, and databound controls? 2 1260
<je*********@gm ail.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. . When I drop a SqlConnection on the web form designer, it's created in InitializeCompo nent. I'd like to use this connection in my Page_Load method, but I don't see anywhere that it's opened. Do I need to open it myself? If so, should I close it also, or will I be interfering with databound controls that use it? If I want to use it in PostBack methods should I re-open it, or leave it open in Page_Load?
It seems that I would like to have a connection open for the duration of the page, but I don't know any way to do that while guaranteeing that it gets closed in case of an error. What is the best practice for using a connection in Page_Load, PostBacks, and databound controls?
In most opinions, it is not wise to use a "global" connection object.
Create the object, open it, use it, close it. If done correctly, the
connection will be pooled and can quickly be created/opened again (by
retrieving the object from the pool automatically) and re-used. In this
case, you would just need to make sure the object is closed after an error
by:
' Create connection.
Dim conn As SqlConnection = New SqlConnection(. ..)
conn.Open()
Try
... fill dataset, update database, or something else ...
Finally
conn.Close()
End Try
' Use data retrieved from the database. Connection is no longer needed
here.
HTH,
Mythran
There's not much advantage in trying to keep the connection open for the
life of the page, and NEVER try to keep it open across page requests.
ASP.NET's efficient built-in connection pooling makes this kind of thing
unnecessary. The rule of thumb is to open a connection just before you need
it, and close it as soon as you've retrieved the data you need.
--
I hope this helps,
Steve C. Orr, MCSD, MVP http://SteveOrr.net
<je*********@gm ail.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. . When I drop a SqlConnection on the web form designer, it's created in InitializeCompo nent. I'd like to use this connection in my Page_Load method, but I don't see anywhere that it's opened. Do I need to open it myself? If so, should I close it also, or will I be interfering with databound controls that use it? If I want to use it in PostBack methods should I re-open it, or leave it open in Page_Load?
It seems that I would like to have a connection open for the duration of the page, but I don't know any way to do that while guaranteeing that it gets closed in case of an error. What is the best practice for using a connection in Page_Load, PostBacks, and databound controls? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Pastrovick |
last post by:
I am not sure what the most effective way to organize a db for users
is.
I have 40 users (teachers) and 20 tables (grades, assignments,
students, etc).
Each needs access to its OWN grades, assignemnts, etc.
NOW I am not sure how to orgainize users in the DB. Right now I have
the code for 1 user and need to adapt it to several users.
|
by: John Pastrovick |
last post by:
I am not sure what the most effective way to organize a db for users
is.
I have 40 users (teachers) and 20 tables (grades, assignments,
students, etc).
Each needs access to its OWN grades, assignemnts, etc.
NOW I am not sure how to orgainize users in the DB. Right now I have
the code for 1 user and need to adapt it to several users.
|
by: Peter Foti |
last post by:
Simple question... which is better to use for defining font sizes and why?
px and em seem to be the leading candidates. I know what the general answer
is going to be, but I'm hoping to ultimately get some good real world
examples.
Fire away! :)
Regards,
Peter Foti
|
by: Matt Kruse |
last post by:
http://www.JavascriptToolbox.com/bestpractices/
I started writing this up as a guide for some people who were looking for
general tips on how to do things the 'right way' with Javascript. Their code
was littered with document.all and eval, for example, and I wanted to create
a practical list of best practices that they could easily put to use.
The above URL is version 1.0 (draft) that resulted. IMO, it is not a
replacement for the FAQ,...
|
by: Bob |
last post by:
In our new .NET web applications, we try to limit the use of SqlConnection
to just one instance per page, even if there are multiple accesses to
various queries. The thinking behind is that this reduces the need to
getting and returning connections to the pool repeatedly if a page has
multiple calls to the DB, and each one manages its own connection. However,
this does requires more deliberate coding, like calling the...
| |
by: davihigh |
last post by:
Hello all,
I am looking for a neat and best practice way to layout a number of
items (say, no more than 16 records) in one page, fill in a 4x4 grid.
The most clear way is using <tableto display HTML. But the number of
records is variable, so how i can program to render HTML code
correctly? For example, if we have 5 records, it should appear 4 items
at first row, and 1 item at second row. so on.
I am new to PHP and PHP template, so i...
|
by: bigHairy |
last post by:
Hello.
I have been teaching myself .NET over the last few months and have had
some success. I would like to ask a question though...
A number of examples I have followed have the following in their
finally statement
Try
......
|
by: Justin.Voelker |
last post by:
Hello Everyone:
I am in search of an easier way to develop pages. My most current
website, www.Base2WebDesign.com, has the exact same layout throughout
the entire site. Right now I use a function called "page_top()" and
page_bottom()" that , when called, display the tops and bottoms of
pages. All I have to do on the actual index.php page is call those two
functions and then write the main content on that page. This seems
stupid but...
|
by: at_the_gonq |
last post by:
Hello,
I am hoping to get some guidance on the following scenerio:
I have a password protected site where users have various
permissions. Are sessions the best way of storing the user's id? And
if so, on load of a page should I be hitting the database for their
permissions (based on the session stored user id), or should
everything I need be stored in session variables to save the trip to
the database? I have also wondered about...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |