title: The type or namespace name 'SQLConnection' could not be found
body: <p>Something seems wrong with the c# database for Accounts:</p>
  
  <p>Right at the database I get the error message of:</p>
  
  <blockquote>
    <p>Error 1   The type or namespace name 'Connection' could not be found
    (are you missing a using directive or an assembly reference?)</p>
  </blockquote>
  
  <p>What am I possibly doing wrong with it? I would like to connect to the database in the Accounts</p>
  
  <p><img src="https://i.stack.imgur.com/7Rd4w.png" alt="Table"></p>
  
  <p>Code 1:</p>
  
  <pre><code> public void setCustAccounts(String custId) {
  
          SQLConnection connect = acctsConnect();
          Command statement = null;
          ResultSet result = null;
          String sql = "SELECT acctNo FROM Accounts Where Cid = '" + custId + "';";
  
          try{
              statement = connect.createStatement();
              result = statement.executeQuery(sql);
  
  
              while (result.next()){
                  result.getRow();
                  Account acct = new Account(result.getString("acctNo"));
                  custAccounts.add(acct);                
              }
          }
  
          finally {
              connect.close();
          }
      }
  </code></pre>
  
  <p><strong>code:-</strong></p>
  
  <pre><code>    public SQLConnection acctsConnect(){
          try{
              Class.forName("C:\\ChattBankMDB.mdb");
          }catch(ClassNotFoundException e){
              Console.WriteLine("Error: " + e);
          }
  
          SQLConnection connect = null;
  
          try{
              connect = DriverManager.getConnection("C:\\ChattBankMDB.mdb");
          }catch(SQLException e){
              Console.WriteLine("Error: " + e);
          }
  
          return connect;
      }
      }
  }
  </code></pre>