Início / user-1642206

Rico Strydom's questions

Martin Hope
Rico Strydom
Asked: 2025-04-03 22:51:41 +0800 CST
  • 7

Estou obtendo uma saída de a DataTablepara determinadas colunas que foram definidas em a string array:string[] columnsToBeUnique;

var ordered = dataTable1
                .AsEnumerable()
                .Select(column => columnsToBeUnique.Select(name => column[name]))
                .Order()
                .ToArray()
                ;

Sem o , .Order()estou obtendo a saída desejada. O a saída, no entanto, não é ordenada, então quero ordenar a saída. Quando adiciono o .Order(), um erro Failed to compare two elements in the array.é lançado.

Eu também tentei:

var ordered = dataTable1
                .AsEnumerable()
                .Select(column => columnsToBeUnique.Select(name => column[name]))
                .OrderBy(x=>x)
                .ToList();

O que estou fazendo errado?

c#
Martin Hope
Rico Strydom
Asked: 2025-02-19 03:08:06 +0800 CST
  • 7

Considere o seguinte arquivo xml. Gostaria de obter o ConnectionStringElemento se eu já tiver o Environment/Namevalor e Application/Nameselecionado de diferentes ComboBoxes.

<?xml version="1.0" encoding="utf-8" ?>
<Environments>
    <Environment>
        <Name>DEV</Name>
        <Applications>
            <Application>
                <Name>App1</Name>
                <DBType>Oracle</DBType>
                <ConnectionString>CS1</ConnectionString>
                <Username>user_1</Username>
                <Password>pw_1</Password>               
            </Application>
            <Application>
                <Name>App2</Name>
                <DBType>Oracle</DBType>                     
                <ConnectionString>CS2</ConnectionString>
                <Username>user_2</Username>
                <Password>pw_2</Password>
            </Application>          
        </Applications>
    </Environment>
    <Environment>
        <Name>TEST 1</Name>
        <Applications>
            <Application>
                <Name>App1</Name>
                <DBType>Oracle</DBType> 
                <ConnectionString>CS3sername>
                <Password>pw_3</Password>               
            </Application>
            <Application>
                <Name>App2</Name>
                <DBType>Oracle</DBType>             
                <ConnectionString>CS4</ConnectionString>
                <Username>user_4</Username>
                <Password>pw_4</Password>
            </Application>  
        </Applications>
    </Environment>
</Environments>

É isso que tenho no momento, mas não obtive nenhum resultado.

XDocument xDocument = XDocument.Load("Environments.xml");
        IEnumerable<XElement> ConnectionString = xDocument
        .XPathSelectElements("/Environments/Environment/Applications/Application/ConnectionString")
        .Where(x => x.XPathSelectElements("/Environments/Environment/Name").All(x => x.Value.Equals(Environment1ComboBox.SelectedItem))
                && x.XPathSelectElements("/Environments/Environment/Applications/Application/Name").All(x => x.Value.Equals(Application1ComboBox.SelectedItem)))
        .ToList();
c#
Martin Hope
Rico Strydom
Asked: 2023-11-16 22:11:33 +0800 CST
  • 5

Tenho uma coluna CLOB no meu banco de dados que contém conteúdo como este:

<?xml version="1.0"?>
<tdfmt sel-start="218">31 05 2022 Rico Strydom<br/>
Op verzoek (zie e-mail) garanties overplaatsen....<br/>
    <br/>
OVERBOEKING CREDITGELDEN:<br/>BANKCODE: 1171<br/>T.L.V.: VERP. NL99BANK999999999999<br/>T.G.V.: RC NL00BANK000000000000<br/>
BEDRAG: EUR 9999999<br/>BESCHRIJVING: Vrijgave verpanding creditgelden AA98987987987 ivm overzetten zekerheid naar BGF<br/>
    <br/>
</tdfmt>

Gostaria de atualizar este campo adicionando texto logo após a raiz (tdfmt) seguido por outro</br>

Resultando nisso:

<?xml version="1.0"?>
<tdfmt sel-start="218">THIS TEXT SHOULD GO FIRST</br>
31 05 2022 Rico Strydom<br/>
Op verzoek (zie e-mail) garanties overplaatsen....<br/>
    <br/>
OVERBOEKING CREDITGELDEN:<br/>BANKCODE: 1171<br/>T.L.V.: VERP. NL99BANK999999999999<br/>T.G.V.: RC NL00BANK000000000000<br/>
BEDRAG: EUR 9999999<br/>BESCHRIJVING: Vrijgave verpanding creditgelden AA98987987987 ivm overzetten zekerheid naar BGF<br/>
    <br/>
</tdfmt>

Tentei atualizar meu clob com isso, mas duvido que o CHR(13) seja o caminho a percorrer.

UPDATE OIT SET INFTXT = UPDATEXML(XMLTYPE(OIT.INFTXT),'//tdfmt/text()[1]','THIS TEXT SHOULD GO FIRST' || chr(10)  || EXTRACTVALUE(XMLTYPE(OIT.INFTXT), '//tdfmt/text()[1]', '')).getClobVal()

Espero que meu desejo esteja claro...

oracle