mohammad qasim

mohammad qasim

  • NA
  • 408
  • 0

how to generate xml file and set its value from db

Mar 25 2014 3:51 AM

how to creat xml file in asp.net

and 
how to set its value from db

for example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:anb="http://www.anb.com.sa/">

   <soapenv:Header/>

   <soapenv:Body>

      <anb:CustCreditRptInqRq>

         <anb:MsgRqHdr>

            <anb:RqUID>BKF2404200140000001</anb:RqUID>

            <anb:SCId>BKF</anb:SCId>

            <anb:FuncId>22000000</anb:FuncId>

            <anb:BranchName>ConsLoan</anb:BranchName>

           <anb:UsrId>432123</anb:UsrId>

            <anb:Sec>

               <anb:Info>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</anb:Info>                                               ---  Encypted password

               <anb:InfoType>1</anb:InfoType>

            </anb:Sec>

            <anb:AgentId>XXXXX</anb:AgentId>                                                                                                       --- LDAP UserID

            <anb:ClientDt>2012-01-01T10:31:22</anb:ClientDt> 

         </anb:MsgRqHdr>

         <anb:Body>

            <anb:SrcSys>BKF</anb:SrcSys>

            <anb:SrcIP>10.96.34.135</anb:SrcIP>

            <anb:ForceSIMAHInqFlg>Y</anb:ForceSIMAHInqFlg>

            <anb:SvcName>ENQUIRY</anb:SvcName>

            <anb:RqAction>A_SC</anb:RqAction>

            <anb:RqHdr>

               <anb:MemberId>111</anb:MemberId>

               <anb:UsrId>FTSANBB</anb:UsrId>

               <anb:RunNum>49</anb:RunNum>

               <anb:TrnItems>5</anb:TrnItems>

            </anb:RqHdr>

            <anb:RqMsg>

               <anb:Inq>

                  <anb:InqLang/>

        </anb:Body>

      </anb:CustCreditRptInqRs>

   </soapenv:Body>

</soapenv:Envelope>



i need to genearate it into xml file .how can i ???

and 

set its value like user id and pwd from DB ( etc ) ... how to do it as well??


thanks 


Answers (1)