How to bind local db records to datagridview

See more:

C#

Windows

DataGridView

I have a C# windows application with a local db (SQL server express). I added the SQL server express to the application directory, every thing is working fine, i can save to the database, but i found out that there is a copy of the database in the BIN folder, and that is where my saved records are. I am trying to bind a dataGridView to view saved records, the code runs without error, but the grid is not loaded with data as the dataSet table is null.

What I have tried:

private void BindDataGridView()
{
    try
    {
        var select = "SELECT DISTINCT [Country],[State],[City] FROM dbo.StaffRecord ORDER BY [Country] ASC,[State] DESC";
        var c = new SqlConnection(connstring);
        var dataAdapter = new SqlDataAdapter(select, c);

        var ds = new DataSet();
        dataAdapter.Fill(ds);
        dataGridView1.ReadOnly = true;
        dataGridView1.DataSource = ds.Tables[0];

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

My Connection string:

<add name="connection" connectionString = "Data Source=(localdb)\MSSQLLocalDB; Initial catalog=StaffRecord; Integrated Security=true;AttachDBFilename=|DataDirectory|\Database1.mdf;" providerName="System.Data.SqlClient" />

Please i wont to be able to bind the DataGridView to the version of the local DB in the BIN folder since the Records are saved there. Thanks