string connStr =
                "Provider=ASAProv;Data source=dsn1;"
                + "User Id=user1;Password=pwd1";
            OleDbConnection c = new OleDbConnection(connStr);
            try
            {
                c.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can't connect to database. Error: " + ex.Message);
            }
            OleDbDataAdapter dAdapter = new OleDbDataAdapter();
            dAdapter.SelectCommand = new OleDbCommand(
                "SELECT name FROM tables.table1", c);
            DataTable dt = new DataTable();
            dAdapter.Fill(dt);
            this.dataGridView1.DataSource = dt.DefaultView;
            this.dataGridView1.Refresh();