DataAdapters and Connections

[JJ]

I was wondering if I have an existing DataAdapter created
and I had killed the connection to it. How do I setup a
new connection to same DataAdapter without having to
resetup the DataAdapter? So reconnect the DataAdapter
after a disconnect is what I'm after.

Thanks,

JJ

[Klaus H. Probst]

Why? Just destroy it and create a new one. Why do you want to hold on to it?

--
____________________
Klaus H. Probst, MVP
http://www.vbbox.com/

"JJ" <an*******@discussions.microsoft.com> wrote in message
news:93****************************@phx.gbl...

I was wondering if I have an existing DataAdapter created
and I had killed the connection to it. How do I setup a
new connection to same DataAdapter without having to
resetup the DataAdapter? So reconnect the DataAdapter
after a disconnect is what I'm after.

Thanks,

JJ

[JJ]

Do u mean the DataAdapter Destroy or the connection?

JJ

-----Original Message-----
Why? Just destroy it and create a new one. Why do you want to hold on to it?
--
____________________
Klaus H. Probst, MVP
http://www.vbbox.com/

"JJ" <an*******@discussions.microsoft.com> wrote in messagenews:93****************************@phx.gbl...

I was wondering if I have an existing DataAdapter created and I had killed the connection to it. How do I setup a
new connection to same DataAdapter without having to
resetup the DataAdapter? So reconnect the DataAdapter
after a disconnect is what I'm after.

Thanks,

JJ

.

[Jon Skeet [C# MVP]]

JJ <an*******@discussions.microsoft.com> wrote:

I was wondering if I have an existing DataAdapter created
and I had killed the connection to it. How do I setup a
new connection to same DataAdapter without having to
resetup the DataAdapter? So reconnect the DataAdapter
after a disconnect is what I'm after.

What kind of DataAdapter is it? If you change the connection within
each of the Command objects of a SqlDataAdapter, for instance, I would
imagine that would do the trick.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too