get connection

protected SqlConnection GetConnection()
{
string connection = ConfigurationManager.AppSettings["connectionString"];
SqlConnection con = new SqlConnection(connection);
if (con.State != ConnectionState.Open)
con.Open();
return con;
}