Using C# to connect to MS Access files with SQL

[TabulaRasa]

Hey!

I need to access a MS Access .mdb Database (exported by MS Project 2003) within my C# application.

I tried to use the SQLClient class but couldn't find out which connectionstring allows me to access it. Is this even possible? I'd like to use the sqlcommands for this project.

This is a code snippet of my SQLAccess class:


class SQLAccess
{

public SQLAccess(string connectionstring, string commandstring) //e.g. commandstring = "SELECT name FROM Customers"
{

using (SqlConnection connection = new SqlConnection(connectionstring))
{

connection.Open();

using (SqlCommand command = new SqlCommand(commandstring, connection))
{

using (SqlDataReader DataReader = command.ExecuteReader())
{

//...

}

}

}

}

}

[Janos™]

I would simple create a method for premeters such as:

public void setParameter(String paramAT, String paramTxt)

    {
         OleDbCommand myCommand;
         DbParameter parameter = myCommand.CreateParameter();
         parameter.ParameterName = paramAT;
         parameter.Value = paramTxt;
         myCommand.Parameters.Add(parameter);
      }

public int CreateDVD()

 {
      try

       {
          string strSqldvd ="INSERT INTO DVD(title,locatie)VALUES(@title,@locate?)";

            myCommand = (OleDbCommand)dbconn.MyProvider.CreateCommand();          dbconn.MyConnection.Open();
          myCommand.Connection = dbconn.MyConnection;
          myCommand.CommandText = strSqldvd;
          setParameter("@title",M.Title );
          setParameter("@locate", M.Location);

      }
      catch (Exception)
      {
           throw new ArgumentException();
      }
       int count = myCommand.ExecuteNonQuery();
       dbconn.MyConnection.Close();
       return count;
  }