OracleCommand cmd = new OracleCommand();
            cmd.Connection = conn;
// получаем данные
            cmd.CommandText = "select S_TITLE, P_TITLE, P_ADRESS, P_ITN," +
                              "nvl(P_BANKS_CITY, ' '), P_BANK_TITLE, nvl(P_BANK_BRANCH,' '), P_ACCOUNT_SETTLEMENT," +
                              "P_OKPO, P_IEC, P_BIC, P_ACCOUNT_CORR, RANK_ID," +
                              "ADDRESSEE_SURNAME, ADDRESSEE_NAME, PASSPORT_ORGAN, PASSPORT_SERIES, PASSPORT_NUMBER, to_char(PASSPORT_DATE, 'dd.mm.yyyy')" +
                              " from VIEW00 where code = '" + textBox1.Text + "' or ADDRESSEE_SURNAME = '" + textBox2.Text + "'";
            cmd.CommandType = CommandType.Text;
            OracleDataReader dr = cmd.ExecuteReader();
            dr.Read();
//заполняем текстбоксы
            textBox13.Text = dr.GetString(0).ToString();
            textBox12.Text = dr.GetString(1).ToString();
            textBox11.Text = dr.GetString(2).ToString();
            textBox10.Text = dr.GetString(3).ToString();