C#

private void lvNameList_SelectedIndexChanged(object sender, EventArgs e)
        {
            ClearSearch();
            select = "SELECT * FROM agenda_telefonica WHERE nume = '" + lvNameList.FocusedItem.Text + "' AND prenume = '" + lvNameList.FocusedItem.SubItems[1].Text + "'"; 
            SqlDataReader dr = realSql.Select(select);
            if (!dr.HasRows)
            {
                MessageBox.Show("Information not found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                while (dr.Read())
                {
                    tbName.Text = dr[1].ToString().Trim() + " " + dr[2].ToString().Trim();
                    tbPhoneNumber1.Text = dr[3].ToString().Trim();
                    tbPhoneNumber2.Text = dr[4].ToString().Trim();
                    tbPhoneNumber3.Text = dr[5].ToString().Trim();
                    tbFaxNumber.Text = dr[6].ToString().Trim();
                    tbEmail.Text = dr[7].ToString().Trim();
                    tbCompany.Text = dr[8].ToString().Trim();
                    tbService.Text = dr[9].ToString().Trim();
                    tbEquipment.Text = dr[10].ToString().Trim();
                }
            }
            dr.Close();
            realSql.Close();
        }
    }