.NET (Core and Framework)

11-Oct-07 20:16

Hi,

I have an xml file having hex values in the format 0x3fa and other values..and a xml schema for it having data type hexBinary for the corresponding hex values. When I create a dataset using the xml file and the schema, all the hex values are missing when displayed but the integer and string are fine.

Does anybody have any suggestion or idea for what I could be missing.

Thanks
Sumy

Dave Kreskowiak12-Oct-07 4:14

Dave Kreskowiak

12-Oct-07 4:14

Hex is just a representation of a number. It's no different than an integer.

What does the code look like that's outputting the XML file?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

sumysarin12-Oct-07 7:29

12-Oct-07 7:29

Hi Dave,

Yes, i understand that hex is a representation of a number.

But when I loop through the tables and column values in the dataset to print them, the hex values are not getting printed. This is only when I represent it as hexBinary in the XML Schema. But if I represent the same hex value dataType in the schema as NMTOKEN, I can see it getting printed.

Actually I want to eventually load this to the MS SQL Server database. So I have the column datatype as binary for all these hex values.

Thanks
Sumy

Luc Pattyn12-Oct-07 7:42

12-Oct-07 7:42

Here is an idea (C# syntax):

int.TryParse("12", NumberStyles.HexNumber); // works (expected)
int.TryParse("0x12", NumberStyles.HexNumber); // does not work (expected) 
int.TryParse("0x12", NumberStyles.HexNumber|NumberStyles.AllowHexSpecifier); // DOES NOT WORK

so what I am saying is:
1. check the "0x" prefix is present
2. maybe whatever reads the XML file uses the same code that fails to accept hex specifiers.

BTW: the hex specifiers are language-dependent (0x in C#, &H in VB.NET). Wouldn't that
make XML language-dependent?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

sumysarin12-Oct-07 14:08

12-Oct-07 14:08

Luc,

Thanks for your response. But my coding is almost dynamic, I am creating my database tables with the datatypes that I have in the schema and then I am loading all the values from the xml file to the database.

I am including a small part of my code where I am just printing the values by looping through the dataset and where the hex values are getting omitted.

foreach(DataTable table in dataset.Tables)
{
Console.WriteLine("TableName = " + table.TableName);
Console.WriteLine ("{0}", "---------");
Console.WriteLine("Columns ...");

foreach(DataColumn column in table.Columns)
{
Console.Write("{0,-22}",column.ColumnName);
}
Console.WriteLine("\r\nNumber of rows = {0}", table.Rows.Count.ToString());
Console.WriteLine("Rows ...");

foreach(DataRow row in table.Rows)
{
foreach(Object value in row.ItemArray)
{
Console.Write("{0,-22}",value.ToString());
}
Console.WriteLine();
}
Console.WriteLine();
}

Luc Pattyn12-Oct-07 14:16

Re: hex value missing in dataset [modified]

12-Oct-07 14:16

I don't see anything refering to ints or hex. Don't know what to think of it.

If you want real help, I suggest you show the code that writes the file, then
a part of the XML file showing how the hex numbers look like, then the code that
reads/shows the file.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

sumysarin15-Oct-07 20:42

15-Oct-07 20:42

I have included a sample schema file, xml file and my sample code.

Any help is appreciated.

XML Schema is as follows: sample.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="System">
<xs:complexType>
<xs:sequence>
<xs:element ref="SystemInfo"/>
<xs:element ref="Memory_Block"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="SystemInfo">
<xs:complexType>
<xs:attribute name="SystemName" use="required" type="xs:NMTOKEN"/>
<xs:attribute name="TotalThreadAvailable" use="required" type="xs:integer"/>
<xs:attribute name="TotalSystemMemorySize" use="required" type="xs:hexBinary"/>
<xs:attribute name="ThreadAvailableMap" use="required" type="xs:hexBinary"/>
</xs:complexType>
</xs:element>
<xs:element name="Memory_Block">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" ref="Range"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Range">
<xs:complexType>
<xs:attribute name="EndAddress" use="required" type="xs:hexBinary"/>
<xs:attribute name="StartAddress" use="required" type="xs:hexBinary"/>
</xs:complexType>
</xs:element>
</xs:schema>

XML File is as follows: sample.xml
<?xml version="1.0" encoding="UTF-8"?>
<System>
<SystemInfo SystemName="xyz" TotalThreadAvailable="8" TotalSystemMemorySize="0x0" ThreadAvailableMap="0x3030303"/>
<Memory_Block>
<Range EndAddress="0x0aaa" StartAddress="0x0"/>
<Range EndAddress="0x0bbb" StartAddress="0x0"/>
<Range EndAddress="0x0ddd" StartAddress="0x0"/>
<Range EndAddress="0x0ccc" StartAddress="0x0"/>
</Memory_Block>
</System>

My sample code:

myXmlDataDocument = new XmlDataDocument();
myStreamReader = new StreamReader("sample.xsd");
myXmlDataDocument.DataSet.ReadXmlSchemamyStreamReader);
myXmlDataDocument.Load("sample.xml");
DisplayTables(myXmlDataDocument.DataSet);

private void DisplayTables(DataSet dataset)
{
// Navigate Dataset
Console.WriteLine("\r\nContent of Tables ...");
foreach(DataTable table in dataset.Tables)
{
Console.WriteLine("TableName = " + table.TableName);
Console.WriteLine ("{0}", "---------");
Console.WriteLine("Columns ...");
foreach(DataColumn column in table.Columns)
{
Console.Write("{0,-22}",column.ColumnName);
}
Console.WriteLine("\r\nNumber of rows = {0}", table.Rows.Count.ToString());
Console.WriteLine("Rows ...");
foreach(DataRow row in table.Rows)
{
foreach(Object value in row.ItemArray)
{
Console.Write("{0,-22}",value.ToString());
}
Console.WriteLine();
}
Console.WriteLine();
}
}

-- modified at 11:10 Tuesday 16th October, 2007

Luc Pattyn15-Oct-07 23:32

15-Oct-07 23:32

When showing HTML or XML, it is necessary to check the "ignore HTML tags" checkbox,
otherwise everything gets eaten by the HTML interpreter...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

sumysarin17-Oct-07 7:18

17-Oct-07 7:18

Yes, I did that by modifying the mail.Should I resubmit it?

Luc Pattyn17-Oct-07 14:25