private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
            try
            {
                string sqlwhr = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
                //Записи с удовлетворяющим ID
                DataRow[] dr = dbDataSet1.Что_ то_там.Select("CL_ID = " + sqlwhr);
                this.Где_то_тамTableAdapter.Fill(this.dbDataSet2.Где_то_там, sqlwhr);
            }
            catch (Exception exp)
            {
                label2.Text = exp.ToString();
            }            
}

this.Где_то_тамTableAdapter.Fill(this.dbDataSet2.Где_то_там, sqlwhr);

private string sqlwhr;
public virtual int Fill(dbDataSet2.Где_то_тамDataTable dataTable, string sqlwhr) {
            this.sqlwhr = sqlwhr;
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((this.ClearBeforeFill == true)) {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }

private void InitCommandCollection() {
            this._commandCollection = new global::System.Data.OleDb.OleDbCommand[1];
            this._commandCollection[0] = new global::System.Data.OleDb.OleDbCommand();
            this._commandCollection[0].Connection = this.Connection;
            this._commandCollection[0].CommandText = "SELECT ID, CL_ID, BEGIN_DATE, END_DATE, PLACE, PASSPORT FROM " +
"Где_то_там WHERE CL_ID" + this.sqlwhr;
            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
        }