1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

 
private MySqlDataAdapter sqlDataAdapter;
        private DataTable dataTable;
        private void FillDataGrid()
        {
            string ConString = Globals.Connection;
            string CmdString = string.Empty;
            using (MySqlConnection con = new MySqlConnection(ConString))
            {
                CmdString = "SELECT id, PLZ,NName,Name,Street,EMail,MobileNo FROM Phonebook";
                MySqlCommand cmd = new MySqlCommand(CmdString, con);
                sqlDataAdapter = new MySqlDataAdapter(cmd);
                dataTable = new DataTable("Phonebook");
                sqlDataAdapter.Fill(dataTable);
                datagridview1.ItemsSource = dataTable.DefaultView;
                datagridview1.CanUserAddRows = false;
            }
        }                    

1:
2:
3:
4:
5:

 
  private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
        }