Visual Studio .NET - sql connection problem

I am writing my connection string in the app code folder as follows

private static SqlConnection connection;
 public static SqlConnection GetOpenConnection()
    {
        if (connection == null)
        {
            connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HandicapIndia"].ConnectionString);
            connection.Open();
            return connection;
        }
        else
            return connection;
    }


It's is working fine. But after some hours it get an error on the page where i am using it as follows

SqlCommand com = new SqlCommand("commandText, db.GetOpenConnection());

Please help me.

Thanks

Hi,

any specific error?

Thanks for your response.

But why after some hours it is giving error.
Is it right to return open connection from the app code folder.

Thanks Again.

Hi,

what error you are getting ?

Thanks

RE

Thanks for response.

I am using executscalor in one of my aspx pages.

There I am getting error Required open connection.

Thanks once again.

due to session timeout,

u should check for that.

I got the solution. Basically I was not checking the state of the connection.

The right code is what I have written and is working for me is

private static SqlConnection connection;
    public static SqlConnection GetOpenConnection()
    {
        if (connection == null || connection.State==ConnectionState.Closed || connection.ConnectionString!="")
        {
            connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HandicapIndia"].ConnectionString);
            connection.Open();
            return connection;
        }
        else
            return connection;
    }

Thanks Once Again