> Ps: In the others providers the databind method set the property
> datareader
> property isclosed to true only if the CommandBehavior is to
> CloseConnection;
> So i think that all the problem is in the dispose implementation !
^
Hello:
> In fact when the second parameter of the dbenumerator constructor is
> true the datareader is automatically close at the end of the iteration;
> "MSDN said" :
>
> [DbEnumerator (IDataReader, Boolean)
>
> Initializes a new instance of the DbEnumerator class using the
> specified DataRea
> What about this one:
>
> return new DbEnumerator(this, =
>
> this.IsCommandBehavior(CommandBehavior.CloseConnection));
In fact when the second parameter of the dbenumerator constructor is
true the datareader is automatically close at the end of the iteration;
"MSDN said" :
[DbEnumerator (IDa
> Hello:
>> I try the new dispose implemmentation but it doesn't work the properties
>> have not changed and the connection still open :(
>>
>> I search also but for the moment i don't find witch method is called by t=
>> he data binding method to close the datareader and the connection :(
>> =
Hello:
> OK i found the solution in fact when a control do a databind with a
> datareader the overiden GetEnumerator is called and now it returns "New
> Dbenumerator(this)" or it sould return "New
> DbEnumerator(this,(CommandBehavior.Default !=
> (CommandBehavior.CloseConnection & this._behavior))
Hello:
> I try the new dispose implemmentation but it doesn't work the properties
> have not changed and the connection still open :(
>
> I search also but for the moment i don't find witch method is called by the
> data binding method to close the datareader and the connection :(
>
And is the D
> The problem is that the connection is not closed after the gridview
> databind
> and the property fbdatareader.isclosed is false or with other provider as
> oracle or sql server the connection is closed
>
>
>
> It'is a bug or not ?
OK i found the solution in fact when a control do a databind wit
> Hello:
>> After a databind of course :)
> Ok change committed into the CVS could you give a try to it when it's
> ready for pserver connections ??
>
I try the new dispose implemmentation but it doesn't work the properties
have not changed and the connection still open :(
I search also but for
It maybe ... i will try to confirm it .. if possible
Can you check in the case of sql server what is the state of the data reader
immediatly after the instruction where you do the data binding ??
the data reader state after the data binding in the sql server provider
is :
PROPERTY : I
It maybe ... i will try to confirm it .. if possible :P
Can you check in the case of sql server what is the state of the data reader
immediatly after the instruction where you do the data binding ??
the data reader state after the data binding in the sql server provider
is :
PROPERTY
Hello:
After a databind of course :)
Ok change committed into the CVS could you give a try to it when it's
ready for pserver connections ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
No hay un solo rey que no descienda de un esclavo,
ni un esclavo que no haya tenido
Hello:
i do some search and the isclosed property of sqldatareader is set to true
after a databind only if the commandbehavior is set to closeconnection !
So i put a breakpoint in the fbdatareader close method and she is never
called. More over the last fbdatareader method called by the
databind
On 29.5.2006 14:13 +0200 le roy arnaud wrote:
Do you have pooling swithced off?
No pooling is on why ?
I think, that the problem is, that the connection is in pool for next use,
to save time for opening connection again.
Try to switch it off.
--
Jiri Cincura
http://www.cincura.net/
--
I put a breakpoint into the fbdatareader close method and this method is
never called !
After a databind of course :)
---
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest numb
Pooling is on by default.
I think the difference agaisnt sqlclient maybe in the dispose implementation,
i have it modified in my local tree but i want to wait first to see if you
can answer my last question, before commit something
I put a breakpoint into the fbdatareader close method and thi
Hello:
No pooling is on why ?
Pooling is on by default.
I think the difference agaisnt sqlclient maybe in the dispose
implementation, i have it modified in my local tree but i want to wait
first to see if you can answer my last question, before commit something
--
Carlos Guzmán Álvarez
Vi
> Do you have pooling swithced off?
No pooling is on why ?
---
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical
i do some search and the isclosed property of sqldatareader is set to true
after a databind only if the commandbehavior is set to closeconnection !
So i put a breakpoint in the fbdatareader close method and she is never
called. More over the last fbdatareader method called by the
databind is Read
Hello:
The problem is that the connection is not closed after the gridview databind
and the property fbdatareader.isclosed is false or with other provider as
oracle or sql server the connection is closed
If that happens is because the Close Method is not being called, can you
try to build the p
On 26.5.2006 11:07 +0200 le roy arnaud wrote:
The problem is that the connection is not closed after the gridview databind
and the property fbdatareader.isclosed is false or with other provider as
oracle or sql server the connection is closed
It'is a bug or not ?
Do you have pooling swithc
Hello,
I have a problem with this code in an asp.net 2.0 applicattion:
FbDataReader d;
FbConnection fb = new
FbConnection(ConfigurationManager.ConnectionStrings["Template"].ConnectionString);
fb.Open();
FbCommand fc = new FbCommand("select * from categories", fb);
d = fc.ExecuteReader(CommandBeha
21 matches
Mail list logo
