The type or namespace name 'SQLConnection' could not be found

Question

Something seems wrong with the c# database for Accounts:

Right at the database I get the error message of:

Error 1 The type or namespace name 'Connection' could not be found (are you missing a using directive or an assembly reference?)

What am I possibly doing wrong with it? I would like to connect to the database in the Accounts

Code 1:

 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:-

    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;     }     } } 

Answer 1

using System.Data.SqlClient; 

Along with the above line we need to also check if the actual system assembly reference is there or not. In my case I had the directive but assembly reference was missing.

To add assembly we can do the following.

Browse dll file for SqlClient in and add it.

--or--- simpler way is to install nuget package.

Right Click on Project > Manage Nuget Packages > Search & install 'System.Data.SqlClient'

Make sure it is compatible with the type of project (Core/Standard);

Answer 2

You are missing the using Directive statement in your code.

using System.Data.SqlClient;