Не удалось найти тип или имя пространства имен «SQLConnection». ⇐ C#

[Anonymous]

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

Источник: https://stackoverflow.com/questions/297 ... t-be-found