How to get the values from a XML file in VB.NET and than this value put into a table in database?

Question

1.00/5 (1 vote)

See more:

I have  to get the values from a XML file . I have to create a class or sth in  vb.net and than this value put into a table in database. The values in  XML file change each time so it means...each time we have a diff XML file.    Please Help . Thank you
<pre lang="xml"> <pre><title>DROGHE D'ABUSO SCREEENING</title>
                    <component>
                        <section>
                            <code code="32010" codeSystemName="Codifica Interna Laboratorio" displayName="Oppiacei">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Oppiacei</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTI</td>
                                           <td/>
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32010" codeSystemName="Codifica Interna Laboratorio" displayName="Oppiacei">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32010" codeSystemName="Codifica Interna Laboratorio" displayName="Oppiacei">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTI</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="32020" codeSystemName="Codifica Interna Laboratorio" displayName="Metadone">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Metadone</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32020" codeSystemName="Codifica Interna Laboratorio" displayName="Metadone">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32020" codeSystemName="Codifica Interna Laboratorio" displayName="Metadone">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="32030" codeSystemName="Codifica Interna Laboratorio" displayName="Cannabinoidi(THC)">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Cannabinoidi(THC)</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32030" codeSystemName="Codifica Interna Laboratorio" displayName="Cannabinoidi(THC)">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32030" codeSystemName="Codifica Interna Laboratorio" displayName="Cannabinoidi(THC)">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="32065" codeSystemName="Codifica Interna Laboratorio" displayName="Amfetamine/Metamfetamine/Ecstasy">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Amfetamine/Metamfetamine/Ecstasy</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32065" codeSystemName="Codifica Interna Laboratorio" displayName="Amfetamine/Metamfetamine/Ecstasy">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32065" codeSystemName="Codifica Interna Laboratorio" displayName="Amfetamine/Metamfetamine/Ecstasy">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="32050" codeSystemName="Codifica Interna Laboratorio" displayName="Cocaina">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Cocaina</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32050" codeSystemName="Codifica Interna Laboratorio" displayName="Cocaina">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32050" codeSystemName="Codifica Interna Laboratorio" displayName="Cocaina">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="35520" codeSystemName="Codifica Interna Laboratorio" displayName="Benzodiazepine">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Benzodiazepine</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="35520" codeSystemName="Codifica Interna Laboratorio" displayName="Benzodiazepine">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="35520" codeSystemName="Codifica Interna Laboratorio" displayName="Benzodiazepine">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="35530" codeSystemName="Codifica Interna Laboratorio" displayName="Barbiturici">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Barbiturici</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="35530" codeSystemName="Codifica Interna Laboratorio" displayName="Barbiturici">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="35530" codeSystemName="Codifica Interna Laboratorio" displayName="Barbiturici">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216121035" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                    <component>
                        <section>
                            <code code="32080" codeSystemName="Codifica Interna Laboratorio" displayName="Buprenorfina">
                                <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                            </code>
                            <text>
                                <paragraph>
                                </paragraph>
                                <table>
                                    <thead>
                                        <tr>
                                            <th>Esame</th>
                                            <th>Esito</th>
                                            <th>Abnormal Flag</th>
                                            <th>Unita di misura</th>
                                            <th>Range di riferimento</th>
                                            <th>Metodo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>Buprenorfina</td>
                                            <td>Negativo</td>
                                            <td></td>
                                            <td></td>
                                            <td>ASSENTE</td>
                                            <td />
                                        </tr>
                                    </tbody>
                                </table>
                                <footnote></footnote>
                                <paragraph>
                                </paragraph>
                                <!--Inizio Microbiologia sezione humane readable-->
                                <!--Fine   Microbiologia sezione humane readable-->
                            </text>
                            <entry typeCode="DRIV">
                                <!-- INIZIO MONO RISULTATO -->
                                <act classCode="ACT" moodCode="EVN">
                                    <code code="32080" codeSystemName="Codifica Interna Laboratorio" displayName="Buprenorfina">
                                        <!--TRASCODIFICA ANALISI NON DISPONIBILE-->
                                    </code>
                                    <statusCode code="completed" />
                                    <!--(INIZIO) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <!--(FINE) GESTIONE MICROBIOLOGIA MONO RISULTATO -->
                                    <entryRelationship typeCode="COMP">
                                        <observation classCode="OBS" moodCode="EVN">
                                            <code code="32080" codeSystemName="Codifica Interna Laboratorio" displayName="Buprenorfina">
                                                <!--TRASCODIFICA RISULTATI NON DISPONIBILE-->
                                                <!--ANL_COMPLETED-->
                                            </code>
                                            <statusCode code="completed" />
                                            <effectiveTime value="20170216115332" />
                                            <value xsi:type="ST">Negativo</value>
                                            <!---->
                                            <referenceRange typeCode="REFV">
                                                <observationRange classCode="OBS" moodCode="EVN.CRT">
                                                    <value xsi:type="ST">ASSENTE</value>
                                                    <interpretationCode code="N" />
                                                </observationRange>
                                            </referenceRange>
                                        </observation>
                                    </entryRelationship>
                                    <!-- VAL USED -->
                                </act>
                                <!-- FINE MONO RISULTATO -->
                            </entry>
                        </section>
                    </component>
                </section>
            </component>
            <component typeCode="COMP">
                <section classCode="DOCSECT" moodCode="EVN">
                    <!--Completo-->
                    <code code="TOS-DROGHE" displayName="TOSSICOLOGIA D'ABUSO">
                        <!-- TRASCODIFICA PER SPECIALITA' NON DISPONIBILE-->
                    </code>

What I have tried:

I don't know how to start... i start only think a logic...to crate an abstract class that get this values like parameters(but i don't how to implement)... also to create a procedure or something else that after i get the dates from XML i insert into the a table .

Posted 14-Nov-18 2:59am

Member 14032312

Updated 14-Nov-18 4:20am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aydin Homay · Accepted Answer · 2018-11-14T03:21:00

Solution 1

Hi,

A very easy way will be ADO.NET which provides you an object called DataSet which you can use it to read an XML file and then store it into a database.

See DataSet.ReadXml to know how to read XML by dataset.

This link also talks about the same scope.

If you also would like to know how to update your databasse from datasedt you can also go to this link

To know how to work with ADO.Net in VB.Net go to the below link:
ADO.NET code examples | Microsoft Docs[^]

A very trivial example of using Oracle adapter in ADO.NET would be like this:

OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cmdOra = new OracleCommand(StoredProcedureName, Connection);
cmdOra.CommandType = CommandType.StoredProcedure;

da.InsertCommand = cmdOra;
da.Update(dsDataSet);

If you want you can use ODP.NET which is also based on ADO.Net in VB to connect oracle db see the below link PLEASE:

Getting Started with Oracle Data Provider for .NET (VB.NET Version)[^]

If this did not solve your problem then please leave a comment and I will assist you by improving my solution until your problem gets solved.

Cheers,
AH

Posted 14-Nov-18 3:21am

Aydin Homay

Updated 14-Nov-18 4:33am

v6

Comments

Member 14032312 14-Nov-18 9:43am

I am using VB.Net and i dont know how to use ado.net together with vb.net
Can you help me >

Aydin Homay 14-Nov-18 9:50am

Hi Back, I updated the solution and added a link that shows how to use ADO.Net in VB.Net.

Member 14032312 14-Nov-18 9:48am

Can you help me...pls write me at my email :shkelzentarja@gmail.com

Aydin Homay 14-Nov-18 9:51am

We can keep in touch via this platform. Please do not forget to press that accept green button if it worked. ;-)
Git it a try I am sure you can do on your own.

Member 14032312 14-Nov-18 9:59am

i don't understand it ... i am using oracle db not MY SQL ... i think it must be anodher way...if you are sure this way works than help me... i rreally need help... i am a junior developer.

Aydin Homay 14-Nov-18 10:03am

Please be patient and read the link. The ADO.Net has different adapters for different DBMS, it supports Oracle too, for example, go to the same link (the last link that I provided) and read about System.Data.OracleClient. As a programmer, you need to learn how to do search/research and make things working on your own.
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-code-examples#oracleclient

Member 14032312 14-Nov-18 10:07am

I read it all .. but i dont get it and also is in c# i am working with vb.net and i dont know much c#

Aydin Homay 14-Nov-18 10:12am

You can switch the language form the right side upper corner. If you look at to the right upper corner you will see something like </>C# change it to VB. About another part of your question, the only thing that you would need to do is to change the driver in the ADO.Net I will update the solution to show you how ;-)

Member 14032312 14-Nov-18 10:18am

ok

Aydin Homay 14-Nov-18 10:25am

I also sent you an email with an screenshot to see how to switch the language.

Member 14032312 14-Nov-18 10:10am

I dont understand sorry..