Database Connection

class DataManager
    {
        string m_MdbFileName = "";
        OleDbConnection conn = new OleDbConnection();
        OleDbCommand cmd = new OleDbCommand();
        OleDbConnection desconn = new OleDbConnection();
        OleDbCommand descmd = new OleDbCommand();
        string M_desStr = "";

          string M_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + "/db/Unique.mdb;Persist Security Info=True";
        // conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\VilasDB.mdb;Persist Security Info=true"



        public OleDbConnection GetConnection()
        {
            try
            {
                conn.Dispose();
                conn.ConnectionString = M_str;
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();

            }
            catch(Exception exp)
            {

            }
            return conn;
        }

        public OleDbCommand getCommand()
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            conn.Open();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            return cmd;
        }
        public void CloseConnection()
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            else
            {
                conn.Close();
            }
        }
        public System.Data.ConnectionState GetConnectionState()
        {
            GetConnection();
            return conn.State;
        }
    }