I have a SqlConnection object , Dose calling Dispose() in SqlConnection
Object close the opened connection to database?

Other: When I need to implement IDisposal interface?

Raed,

I always do these instructions below regardless (it never broke):

if(mySQLConnection.State==ConnectionState.Open)
mySQLConnection.Close();
mySQLConnection.Dispose();

BTW: Dispose() is good because you yourself tell the "clr" that it is no
longer useful.

John


"Raed Sawalha" <(E-Mail Removed)> wrote in message
news:574A04A1-BA6B-48E2-9AB4-(E-Mail Removed)...
>I have a SqlConnection object , Dose calling Dispose() in SqlConnection
> Object close the opened connection to database?
>
> Other: When I need to implement IDisposal interface?

Raed Sawalha <(E-Mail Removed)> ha scritto:
> I have a SqlConnection object , Dose calling Dispose() in
> SqlConnection Object close the opened connection to database?

Yes. With reflection you an read the method Diponse in SqlConnection class:
protected override void Dispose(bool disposing)
{
if (disposing)
{
switch (this._objectState)
{
case ConnectionState.Open:
{
this.Close();
break;
}
}
this._constr = null;
}
base.Dispose(disposing);
}

--
AZ [Microsoft - .NET MVP]
Mia Home page: http://ciclismo.sitiasp.it
Asp.Net community: http://www.aspitalia.com
Il mio blog: http://blogs.aspitalia.com/az

Hi Andrea Zani,

I have a question from your posting.

Is it possible to get the code of a method using reflection?

How did you get the code of the Dispose method of the SqlConnection class?
--
Saravanan K V


"Andrea Zani" wrote:

> Raed Sawalha <(E-Mail Removed)> ha scritto:
> > I have a SqlConnection object , Dose calling Dispose() in
> > SqlConnection Object close the opened connection to database?
>
> Yes. With reflection you an read the method Diponse in SqlConnection class:
> protected override void Dispose(bool disposing)
> {
> if (disposing)
> {
> switch (this._objectState)
> {
> case ConnectionState.Open:
> {
> this.Close();
> break;
> }
> }
> this._constr = null;
> }
> base.Dispose(disposing);
> }
>
> --
> AZ [Microsoft - .NET MVP]
> Mia Home page: http://ciclismo.sitiasp.it
> Asp.Net community: http://www.aspitalia.com
> Il mio blog: http://blogs.aspitalia.com/az
>
>
>

Saravanan K V <(E-Mail Removed)> ha scritto:
> Is it possible to get the code of a method using reflection?

I don't think it will be possible directly.

> How did you get the code of the Dispose method of the SqlConnection
> class?

http://www.aisto.com/roeder/dotnet/

--
AZ [Microsoft - .NET MVP]
Mia Home page: http://ciclismo.sitiasp.it
Asp.Net community: http://www.aspitalia.com
Il mio blog: http://blogs.aspitalia.com/az