OleDbConnectionStringBuilder.sConnection is a 'field' but is used like a 'type'
I am trying to connect to my database, and this is what I have typed:
string sConnection;
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=Cars.accdb;"
but, the error message it gives me is:
Invalid token '=' in class, struct, or interface member declaration
as well as:
Error '...OleDbConnectionStringBuilder.sConnection' is a 'field' but
is used like a 'type'
I did use these using statements as well:
using System.Data.OleDb;
using System.Data;
using System.Object;
using System.Data.Common.DbConnectionStringBuilder;
using System.Data.OleDb.OleDbConnectionStringBuilder;
namespace FinalProject
{
class DataAccessLayer
{
public sealed class OleDbConnectionStringBuilder : DataAccessLayer
{
public OleDbCommand dbCmd; //Command object
public OleDbDataReader dbReader; //Data Reader object
string sConnection;
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=Cars.accdb;";
Can you help me figure out why I am receiving these errors?
1 answer
You are having code in the class declaration that could only go in methods.
string sConnection;
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=Cars.accdb;";
is not ok in class declaration. Only in method.
This would be ok in class declaration:
string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=Cars.accdb;";