problem with the SQL connection

[Ananta]

Hi

I am having a problem with the SQL server connected in VC#.net

I am using the SQLDataAdaptors to access and fill the data to the
DataSets.

There are certain pages in sequence which run one after the another as
a process based on the user interaction. All the pages (even pages
before entering this process) have the data connection to the SQL
server 2000. On some of the specific pages the data connection is
close. If catch the error and open the connection the catch block i
am able to open the connection there. So, does not seem like to be a
problem with the pooling.

I am not sure where the problem is.

Can anyone help?

[Nicholas Paldino [.NET/C# MVP]]

Ananta,

You say that on some of the specific pages the data connection is
closed. Within the context of a page, you should always close the
connection when you are done. Keeping connections open and passing them
between page processing is not a good idea.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Ananta" <an************@thedetail.info> wrote in message
news:d5**************************@posting.google.c om...

Hi

I am having a problem with the SQL server connected in VC#.net

I am using the SQLDataAdaptors to access and fill the data to the
DataSets.

There are certain pages in sequence which run one after the another as
a process based on the user interaction. All the pages (even pages
before entering this process) have the data connection to the SQL
server 2000. On some of the specific pages the data connection is
close. If catch the error and open the connection the catch block i
am able to open the connection there. So, does not seem like to be a
problem with the pooling.

I am not sure where the problem is.

Can anyone help?