how to maintain connection in vb.

[shashankkale]

how to maintain connection in vb,there any way to declare con.open or rs.open
so i can easily close it.

thanks

[Montravont]

I think more detail might be needed as to what you're trying to accomplish.

On a technical level, if you don't call con.close the connection will stay open indefinitely. This, will likely cause problems... but that's what it is. (to my understanding)

If this isn't quite what you meant, please elaborate a little as to your needs and I'm sure we'll be able to help.