SqlDataReader FSqldataread; SqlConnection myConnection; private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentCell.Selected == true) { int numExped; numExped = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); string chainecnx = @"chaine de connection"; string req1 "SELECT * FROM PRODEXPED WHERE NUM_EXPED" + numExped; myConnection = new SqlConnection(chainecnx); myConnection.Open(); SqlDataAdapter DA = new SqlDataAdapter(req1, chainecnx); DataSet DS = new DataSet(); DA.Fill(DS, "EXPED"); dataGridView2.DataSource = DS.Tables["EXPED"]; myConnection.Close(); } }