protected int GetRowCounts()
    {
        int iRowCount = 0;


        using (OracleConnection conn = new OracleConnection("DATA SOURCE=DAPP;PASSWORD=APL_SD7#PP4;USER ID=APL_SDP"))
        {
            OracleCommand cmd = new OracleCommand("select count(*) from SDPJ_IMPORT_PROCESSO", conn);
            conn.Open();

            // Executa o SqlCommand e obtendo as contagens da linhas.
            iRowCount = (int)cmd.ExecuteScalar();
        }

        return iRowCount;
    }[![inserir a descrição da imagem aqui][1]][1]