how to share the connection?

[dollar]

I got it, thanks

Hi dollar,

What I meant was, do not share a Connection. Open and clase you
Connections
as quickly as possible. If they share the same Connection String
they will
be pooled and reused, without your having to do anything special, du
to the
built-in Connection Pooling in .Net.

Another way to look at it is this: If you come from an AS
background, and
you're used to having to create and reuse a Connection in order t
save
resources used when opening new Connections, you don't have to worr
about
that any more. .Net has built-in Connection Pooling that, in
sense,
handles this for you. In fact, it is much safer and better to ope
and clse
each Connection as quickly as possible. When you close th
Connection, you
release it to the Connection Pool. It is not destroyed immediately
but
pooled by the .Net platform.

Does that help?

--
HTH,

Kevin Spencer
Microsoft MVP
...Net Developer
What You Seek Is What You Get

-
dolla