Programming - Best Practice

[bigHairy]

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
......
Catch
......
Finally

If (Not IsNothing(dbCon n)) Then
dbConn.Close()
End If

End Try

Will my data connection always close using this method or should I
just use dbConn.close?

I have a program that seems to be holding onto its connection - am I
missing something?

[Herfried K. Wagner [MVP]]

"Cor Ligthert [MVP]" <no************ @planet.nlschri eb:

>Not really. Imagine an exception gets thrown when opening the
connection.

Absolutely not Herfried that is in your control, I did not say you should
not use Try and Catch. I mean there should not be needed a question as "If
connection is open"

Why not? Pseudo code:

\\\
Dim c As New Connection()
Try
c.Open()
c.DoSomething()
Catch
...
Finally
c.Close()
End Try
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Cor Ligthert [MVP]]

Herfried,

In your sample you don't know if it is an opening error or a processing
error.

It depend of course of the situation, I think that in a common situation (I
don't remember me that I did the first one in a real situation) that I am to
lazy for the first one, however asked was Best Practice.

Your sample is often used to show how finally can work. In my opinion that
is not because it is the best way how to do an open and close but there are
not so many more simple samples.

:-)

Cor

"Herfried K. Wagner [MVP]" <hi************ ***@gmx.atschre ef in bericht
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

"Cor Ligthert [MVP]" <no************ @planet.nlschri eb:

>>Not really. Imagine an exception gets thrown when opening the
connection.

Absolutely not Herfried that is in your control, I did not say you should
not use Try and Catch. I mean there should not be needed a question as
"If connection is open"

Why not? Pseudo code:

\\\
Dim c As New Connection()
Try
c.Open()
c.DoSomething()
Catch
...
Finally
c.Close()
End Try
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Spam Catcher]

pf******@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.

[Stephany Young]

That is not correct.

When a DataAdapter 'starts' it's operation it determines thae current state
of the Connection. If the Connection was already open then it leaves it open
when it finishes. If it needs to open the Connection then it closes the
Connection when it finishes.

In other words, it leaves the Connection in the state that it found it.
"Spam Catcher" <sp**********@r ogers.comwrote in message
news:Xn******** *************** **********@127. 0.0.1...

pf******@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

>I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.

[aaron.kempf]

Spam

that is not an acceptable answer.

Your ADO.net _CRAP_ is unusable

UNNECESSARY CHANGE IS NOT SEXY
UNNECESSARY CHANGE IS NOT WANTED
UNNECESSARY CHANGE IS NOT ACCEPTABLE


On Feb 17, 12:31 pm, Spam Catcher <spamhoney...@r ogers.comwrote:

pfc_s...@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.

[aaron.kempf]

Stephany

I don't care whether is 'says' it is open or not.
it does not maintain the same spid; you and Microsoft merely play word
games.

ADO.net is not usable, UNNECESSARY CHANGE IS NOT ACCEPTABLE


On Feb 17, 12:38 pm, "Stephany Young" <noone@localhos twrote:

That is not correct.

When a DataAdapter 'starts' it's operation it determines thae current state
of the Connection. If the Connection was already open then it leaves it open
when it finishes. If it needs to open the Connection then it closes the
Connection when it finishes.

In other words, it leaves the Connection in the state that it found it.

"Spam Catcher" <spamhoney...@r ogers.comwrote in message

news:Xn******** *************** **********@127. 0.0.1...

pfc_s...@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.- Hide quoted text -

- Show quoted text -

[PFC Sadr]

Spam

ok.. ok.. how we're getting somewhere

if I just use datareaders (why in the hell would I want to use
datasets?)
then it will keep the same SPID even with 20 people hitting the
database?

I just think that the whole 'automagically close connections' is
misguided
and when MS Press sits there and says crap like 'uh you guys cant
remember to use the .MoveNext method so we've fixed it for you by
using the .Read' method

I just get a little bit defensive

I didn't ask for MIcrosoft to talk down to us-- just because we use
the WORLDS MOST POPULAR PROGRAMMING LANGUAGE
I mean; are you guys not pissed off by the tone of that authors voice?

it's just reflective of what M$ thinks of VB people

so... _FUCK_MS_


On Feb 17, 12:31 pm, Spam Catcher <spamhoney...@r ogers.comwrote:

pfc_s...@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.

[PFC Sadr]

I don't WANT to manually close it.
I want to leave it OPEN.
I don't see the point of opening it and re-opening it and all that
crap
and you can't utilize temp tables if your provider keeps on randomly
closing connections

uh; like seriously here

let's talk about programming apps for small business.
why would I constantly open and close and open and close connections??

On Feb 17, 12:31 pm, Spam Catcher <spamhoney...@r ogers.comwrote:

pfc_s...@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the reader/connection.

[Cor Ligthert [MVP]]

PFC,

I have the same, when I have to drive less than 150miles an hour, than I
hate that, why would I do that, just for security by instance like opening
and closing the connections to prevent that there are pooling of whatever
problems.

Cor
"PFC Sadr" <pf******@hotma il.comschreef in bericht
news:11******** **************@ l53g2000cwa.goo glegroups.com.. .

>I don't WANT to manually close it.
I want to leave it OPEN.
I don't see the point of opening it and re-opening it and all that
crap
and you can't utilize temp tables if your provider keeps on randomly
closing connections

uh; like seriously here

let's talk about programming apps for small business.
why would I constantly open and close and open and close connections??

On Feb 17, 12:31 pm, Spam Catcher <spamhoney...@r ogers.comwrote:

>pfc_s...@hotma il.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.go oglegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the
reader/connection.

[aaron.kempf]

Cor

I don't understand what you're trying to say to me here.

Are you saying that you are GLAD that they automagically close
connections?

IT SHOULD BE OPTIONAL NOT MANDATORY

JUST LIKE IT WAS IN ADO; USING CONNECTION SHARING


On Feb 19, 8:32 pm, "Cor Ligthert [MVP]" <notmyfirstn... @planet.nl>
wrote:

PFC,

I have the same, when I have to drive less than 150miles an hour, than I
hate that, why would I do that, just for security by instance like opening
and closing the connections to prevent that there are pooling of whatever
problems.

Cor

"PFC Sadr" <pfc_s...@hotma il.comschreef in berichtnews:11* *************** ******@l53g2000 cwa.googlegroup s.com...

I don't WANT to manually close it.
I want to leave it OPEN.

I don't see the point of opening it and re-opening it and all that
crap
and you can't utilize temp tables if your provider keeps on randomly
closing connections

uh; like seriously here

let's talk about programming apps for small business.
why would I constantly open and close and open and close connections??

On Feb 17, 12:31 pm, Spam Catcher <spamhoney...@r ogers.comwrote:

pfc_s...@hotmai l.com wrote in news:1171659636 .108644.239340
@q2g2000cwa.goo glegroups.com:

I just don't understand; why do you even need to close a connection if
you can't leave a connection OPEN?

It depends on the reader you use. If you use a data adapter, it'll close
for you.

However, datareaders use a firehose mode to read from the database, thus
you need to manually close it when you're done with the
reader/connection.- Hide quoted text -

- Show quoted text -