How to Convert xml to DataTable and Display in Asp.Net Gridview
Response Xml Data:
<DepTrnInqData>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>1</SlNum10>
<Typ10>20</Typ10>
<PstDt8>17/08/20 14:15</PstDt8>
<JrnlNum9>46001967</JrnlNum9>
<TrnDescptn14>MB/FT/00460310009555/00080310005975/SOD</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>2</SlNum36>
<Typ36>1</Typ36>
<PostDt3>17/08/20 14:15</PostDt3>
<JrnlNum31>46001967</JrnlNum31>
<ValDt15>17/08/20</ValDt15>
<TrnAmt22>47600.00 DR</TrnAmt22>
<CrntBal12>50.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>Withdrawl Transfer</TrnDescptn36>
<TrnAmt23>1055</TrnAmt23>
<Brch19>1</Brch19>
<Term12/>
<Usr20>1508</Usr20>
<BatchNo>0</BatchNo>
<Narr3>MB/FT/00460310009555/00080310005975/SOD</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>MB/FT/00460310009555/00080310005975/SOD</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>3</SlNum10>
<Typ10>20</Typ10>
<PstDt8>17/08/20 14:13</PstDt8>
<JrnlNum9>46001950</JrnlNum9>
<TrnDescptn14>MB/FT/00460310009555/00460310009537/Gas Bill</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>4</SlNum36>
<Typ36>1</Typ36>
<PostDt3>17/08/20 14:13</PostDt3>
<JrnlNum31>46001950</JrnlNum31>
<ValDt15>17/08/20</ValDt15>
<TrnAmt22>2350.00 DR</TrnAmt22>
<CrntBal12>47650.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>Withdrawl Transfer</TrnDescptn36>
<TrnAmt23>1055</TrnAmt23>
<Brch19>1</Brch19>
<Term12/>
<Usr20>1508</Usr20>
<BatchNo>0</BatchNo>
<Narr3>MB/FT/00460310009555/00460310009537/Gas Bill</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>MB/FT/00460310009555/00460310009537/Gas Bill</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>5</SlNum10>
<Typ10>20</Typ10>
<PstDt8>17/08/20 10:49</PstDt8>
<JrnlNum9>46000341</JrnlNum9>
<TrnDescptn14>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>6</SlNum36>
<Typ36>1</Typ36>
<PostDt3>17/08/20 10:49</PostDt3>
<JrnlNum31>46000341</JrnlNum31>
<ValDt15>17/08/20</ValDt15>
<TrnAmt22>10000.00 CR</TrnAmt22>
<CrntBal12>50000.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>DEPOSIT TO DEPOSIT /</TrnDescptn36>
<TrnAmt23>1045</TrnAmt23>
<Brch19>1</Brch19>
<Term12/>
<Usr20>486</Usr20>
<BatchNo>0</BatchNo>
<Narr3>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>7</SlNum10>
<Typ10>20</Typ10>
<PstDt8>16/08/20 18:05</PstDt8>
<JrnlNum9>46007600</JrnlNum9>
<TrnDescptn14>MTBL / 40870260 / 583845 / 020 /</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>8</SlNum36>
<Typ36>1</Typ36>
<PostDt3>16/08/20 18:05</PostDt3>
<JrnlNum31>46007600</JrnlNum31>
<ValDt15>16/08/20</ValDt15>
<TrnAmt22>2500.00 CR</TrnAmt22>
<CrntBal12>40000.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>CORRECTION OS CASH W</TrnDescptn36>
<TrnAmt23>8160</TrnAmt23>
<Brch19>46</Brch19>
<Term12/>
<Usr20>3020</Usr20>
<BatchNo>0</BatchNo>
<Narr3>MTBL / 40870260 / 583845 / 020 /</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>MTBL / 40870260 / 583845 / 020 /</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>9</SlNum10>
<Typ10>20</Typ10>
<PstDt8>16/08/20 18:04</PstDt8>
<JrnlNum9>46007581</JrnlNum9>
<TrnDescptn14>MTBL / 40870260 / 583797 / 020 /</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>10</SlNum36>
<Typ36>1</Typ36>
<PostDt3>16/08/20 18:04</PostDt3>
<JrnlNum31>46007581</JrnlNum31>
<ValDt15>16/08/20</ValDt15>
<TrnAmt22>34000.00 CR</TrnAmt22>
<CrntBal12>37500.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>CORRECTION OS CASH W</TrnDescptn36>
<TrnAmt23>8160</TrnAmt23>
<Brch19>46</Brch19>
<Term12/>
<Usr20>3020</Usr20>
<BatchNo>0</BatchNo>
<Narr3>MTBL / 40870260 / 583797 / 020 /</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>MTBL / 40870260 / 583797 / 020 /</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>11</SlNum10>
<Typ10>20</Typ10>
<PstDt8>04/08/20 10:41</PstDt8>
<JrnlNum9>46000496</JrnlNum9>
<TrnDescptn14>/IB/FT/00460310009555/00080310005975/Locker char</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>12</SlNum36>
<Typ36>1</Typ36>
<PostDt3>04/08/20 10:41</PostDt3>
<JrnlNum31>46000496</JrnlNum31>
<ValDt15>04/08/20</ValDt15>
<TrnAmt22>4500.00 DR</TrnAmt22>
<CrntBal12>3500.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>Withdrawl Transfer</TrnDescptn36>
<TrnAmt23>1055</TrnAmt23>
<Brch19>1</Brch19>
<Term12/>
<Usr20>1508</Usr20>
<BatchNo>0</BatchNo>
<Narr3>/IB/FT/00460310009555/00080310005975/Locker char</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>/IB/FT/00460310009555/00080310005975/Locker char</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>20</TrnTyp2>
<SlNum10>13</SlNum10>
<Typ10>20</Typ10>
<PstDt8>27/07/20 15:49</PstDt8>
<JrnlNum9>46004143</JrnlNum9>
<TrnDescptn14>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</TrnDescptn14>
<CheckerId10>0</CheckerId10>
<ExtnDescptn10/>
<Filler13/>
</Coll>
<Coll>
<EndTag/>
<TrnTyp2>1</TrnTyp2>
<SlNum36>14</SlNum36>
<Typ36>1</Typ36>
<PostDt3>27/07/20 15:49</PostDt3>
<JrnlNum31>46004143</JrnlNum31>
<ValDt15>27/07/20</ValDt15>
<TrnAmt22>8000.00 CR</TrnAmt22>
<CrntBal12>8000.81 CR</CrntBal12>
<ChqNum4>0</ChqNum4>
<TrnDescptn36>DEPOSIT TO DEPOSIT /</TrnDescptn36>
<TrnAmt23>1045</TrnAmt23>
<Brch19>1</Brch19>
<Term12/>
<Usr20>1978</Usr20>
<BatchNo>0</BatchNo>
<Narr3>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</Narr3>
<Narr4/>
<Narr5/>
<CheckerId35>0</CheckerId35>
<ExtnDescptn32>BEFTN Inward / STANDARD CHARTERED BANK LTD. / IP /</ExtnDescptn32>
<Filler39/>
</Coll>
<Coll>
<EndTag>TOT</EndTag>
<TrnTyp2>RA</TrnTyp2>
<Narr50>TOT NUMBER</Narr50>
<Filler51>OF TRANS THIS ACCT</Filler51>
</Coll>
</DepTrnInqData>