using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Odbc;
namespace ConnectionSharing
{
    class SqlConnectionManager : IDisposable
    {
        public SqlConnectionManager() {
            if (ConnectionSharing.Properties.Settings.Default.OdbcSqlConnection == null)
            {
                //you may place any initializer code in here
                //create our connection string
                /*
                 * Driver: The built in Driver to use, for 
                 *         non standard databases this must 
                 *         be installed and setup prior to calling
                 * Server: The location of the server, mine
                 *         happens to be on the local host
                 * Database: Not specified but is recommended 
                 *          if you wish to use for specific reasons
                 * Uid: The user ID of the person connecting 
                 *          specified by the global variables
                 * Pwd: The password of the person connecting 
                 *          specified by the global variables
                 */
                string openSqlConnection =
                        @"Driver=(SQL Server);Server=Localhost;uid=" + ConnectionSharing.Properties.Settings.Default.Username +
                        ";Pwd=" + ConnectionSharing.Properties.Settings.Default.Password + ";";
                //please note that the @ sign on the preceeding line means to interpret the string literally
                this.x_sqlConnection = new OdbcConnection(openSqlConnection);
            }
        }
        //now any methods you create have access to the SQL connection created
        private OdbcConnection x_sqlConnection = null;
 
        //always supply a dispose method when working with disposable objects
        public void Dispose() {
            //cleanup / close the connection
            this.x_sqlConnection.Close();
            this.x_sqlConnection.Dispose();
        }
    }
}