title: c# Data from Access won't show on datagridview
body: <p>I'm new to C# and I'm struggling to make data from Access to show on datagridview.
  So I made a database connection and it works fine. But the button to load data got an error that seems to be saying that there's a problem on the line "connection.Open();" </p>
  
  <pre><code>        try
          {
  
              connection.Open();
              OleDbCommand command = new OleDbCommand();
              command.Connection = connection;
              string query = "select Title, Director * from MVDBtable";
              command.CommandText = query;
  
              OleDbDataAdapter da = new OleDbDataAdapter(command);
              DataTable dt = new DataTable();
              da.Fill(dt);
              dataGridView1.DataSource = dt;
  
  
              connection.Close();
          }
  
          //show error message 
          catch (Exception ex)
          {
              MessageBox.Show("Error" + ex);
          }
      }
  </code></pre>