Issue in reading content from XML file

Question

1.00/5 (1 vote)

See more:

I tried to read the data from a XML file. And it's working fine with one project. But the same code is not working with other project which could not figure it out... for the difference.

With one project, I am able to read the content properly with:

VB

xrReader.GetAttribute(0) ' Output example : BANKNIFTY23101244200CE

With other project by using the same code, I am able to get the wrong output data....' Output example: BANKNIFTY.......44200CE
I need to know what could be the reason for not getting the proper data reading from two different projects.

What I have tried:

VB

Using xrReader As XmlReader = XmlReader.Create(source)
Do While xrReader.Read()
If xrReader.GetAttribute(0).ToString.StartsWith("BANKNIFTY") Then
BankNiftyMappingPresentExpiryDateTextBox.Text = xrReader.GetAttribute(0)
End If
Loop
End Using

Please find out here the sample XML source file for your reference. Using thw same for both projects from same data path.

XML

<mapping symbol="BANKNIFTY23101244200CE" name="44200CE" exchange="">
<mapping symbol="BANKNIFTY23101244200PE" name="44200PE" exchange="">
<mapping symbol="BANKNIFTY23101244300CE" name="44300CE" exchange="">
<mapping symbol="BANKNIFTY23101244300PE" name="44300PE" exchange="">

Posted 28-Oct-23 9:31am

OMG_Live

Updated 5-Nov-23 0:39am

Deeksha Shenoy

v3

Add a Solution

Comments

Richard MacCutchan 29-Oct-23 10:52am

Is this the exact text you see in the TextBox, with 7 dots?

Out put example : BANKNIFTY.......44200CE

OMG_Live 29-Oct-23 11:03am

Sour file example :
<mapping symbol="BANKNIFTY01NOV2344200CE" name="44200CE" exchange="">
<mapping symbol="BANKNIFTY01NOV2344200PE" name="44200PE" exchange="">
<mapping symbol="BANKNIFTY01NOV2344300CE" name="44300CE" exchange="">
<mapping symbol="BANKNIFTY01NOV2344300PE" name="44300PE" exchange="">

Out put example on second project : BANKNIFTY.................44200CE

Richard MacCutchan 29-Oct-23 12:26pm

Well that is just a repeat (but not an accurate one) of what you posted earlier, rather than actually answering my question. It also disproves your assertion to M Imran Ansari below, that the XML data is exactly the same. So we are left guessing as to what actually happens on your different systems.

Richard Deeming 30-Oct-23 6:14am

Firstly, before Dave shouts at you :) - GetAttribute returns a string. There is absolutely no need to call .ToString on it.

Secondly, try debugging your code to check that:

a) the source is exactly the same in both applications, and points to exactly the same file; and
b) what the exact value returned from GetAttribute(0) is. Perhaps your display control in the second application is truncating the value if it's too long to display fully?

OMG_Live 30-Oct-23 11:30am

Thanks for your reply. As per your guidance I verified.

01. The source file which is common form both the project.
02. I am getting the value from GetAttribute(0) as BANKNIFTY.................44200CE.

The same output is showing on message box and even on TextBox also.

OMG_Live 1-Nov-23 3:28am

I have created multiple data path with same XML data file

If RadioButton1.Checked Then
source = "C:\Program Files (x86)\Live Feed\watchlist.xml"
ElseIf RadioButton2.Checked Then
source = "C:\Program Files (x86)\Test\watchlist.xml"
ElseIf RadioButton3.Checked Then
source = "C:\watchlist.xml"
ElseIf RadioButton4.Checked Then
source = "C:\Omega Version\watchlist.xml"
End If

As I observed, if I try to read XML data from source = "C:\Program Files (x86)\Live Feed\watchlist.xml", then data is not reading properly with GetAttribute(0) and its showing BANKNIFTY.................44200CE

But with other data source as I mentioned above, its working fine and the value getting as "BANKNIFTY01NOV2344200CE".

Is there any reason for the issue while reading data from "C:\Program Files (x86)\Live Feed\watchlist.xml" ?...Please guide me

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)

M Imran Ansari · Answer 1 · 2023-10-28T10:11:00

When dealing with XML files, it's crucial to ensure that the structure and the data of the XML file is consistent and the data you are trying to access exists in the same format across different projects. It's possible that the XML file structure or data might be slightly different in the two projects. In the second project it's eliminating the date part of XML.
In the first output the date value '231012' is coming between BANKNIFTY and 44200CE, which is eliminating in the second project.
Further, you can ensure the XML structure, attribute index and data integrity to identify the root cause of the issue and ensure that the data reading process is consistent across both projects.