Sorry Mate, but did u explore the other tables in the dataset(output)?. There is an another table called 'Authentication' in it in which u could find the values/data u r expecting.
Well，if possible，please put all of your complete codes for TimoYang，nice contributor：）
Sorry that maybe you have a different kind of way but we cannot understand……:(， and I copied the TimoYang's sample to have a test，the result isn't actually right……:(
Probably I've misunderstood you，but plz show us your real codes fully……
timoYang
timoYang
I know that you are very careful and want to make contributions to the community，but plz be kind and patient enough next time：-）
Sorry but to be very honest, your answer isn't right……Your user table doesn't include authentication values, and you've splitted values from xml contents into two tables, that's not what the author wanted!
I'm afraid, I don't have any other option to achieve this
So, u just have 2 options, either
- Reformat (simplify) xml as
Decker Don suggessted (as below) and use the above suggessed code to see everything u expect in a single table ('User') and then bind it to any databound control
- Use the input xml as it is and use the code we suggessted , which will output more than a table (User, Authentication, etc.). U could then construct a new datatable by merging whatever table u want and bind to any databound control. Please note that u
have to merge tables manually as these tables have different schemas.
Thanks for the responses. The problem with reformatting the xml is....I have no control over the XML as it comes from a query of a firewall.
I'm working on an application that I can query different portions of the configuration.
I do have the xsd files for the data, would applying that somehow make this more 'doable'? My concern there is that they are generally 40-50mb in size.
TimoYang
Contributor
3732 Points
1275 Posts
Re: DataSet.XMLRead not making any tables
May 25, 2012 08:53 AM|LINK
Not at all！！！！！！！！！！！！！！！
Plz leave your email and I'll send you one sample
TimoYang
Contributor
3732 Points
1275 Posts
Re: DataSet.XMLRead not making any tables
May 25, 2012 08:58 AM|LINK
What's does that mean？
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: DataSet.XMLRead not making any tables
May 26, 2012 01:47 AM|LINK
Well，if possible，please put all of your complete codes for TimoYang，nice contributor：）
Sorry that maybe you have a different kind of way but we cannot understand……:(， and I copied the TimoYang's sample to have a test，the result isn't actually right……:(
Probably I've misunderstood you，but plz show us your real codes fully……
I know that you are very careful and want to make contributions to the community，but plz be kind and patient enough next time：-）
TimoYang
Contributor
3732 Points
1275 Posts
Re: DataSet.XMLRead not making any tables
May 27, 2012 08:50 AM|LINK
Hi Ramesh T,
Sorry but to be very honest, your answer isn't right……Your user table doesn't include authentication values, and you've splitted values from xml contents into two tables, that's not what the author wanted!
Ramesh T
Contributor
5079 Points
821 Posts
Re: DataSet.XMLRead not making any tables
May 29, 2012 03:23 PM|LINK
@TimoYang
I'm afraid, I don't have any other option to achieve this
So, u just have 2 options, either
- Reformat (simplify) xml as Decker Don suggessted (as below) and use the above suggessed code to see everything u expect in a single table ('User') and then bind it to any databound control
<configuration> <user> <name>joeuser</name> <uid>2001</uid> <class>xyz</class> <authentication>askldjfc;acmealsiefja;flcnsdlkm</authentication> </user> <user> <name>bobuser</name> <uid>2002</uid> <class>xyz</class> <authentication>your value2</authentication> </user> <user> <name>joeuser</name> <uid>2002</uid> <class>xyz</class> <authentication>your value3</authentication> </user> </configuration>- Use the input xml as it is and use the code we suggessted , which will output more than a table (User, Authentication, etc.). U could then construct a new datatable by merging whatever table u want and bind to any databound control. Please note that u have to merge tables manually as these tables have different schemas.
bluelinenetw...
Member
139 Points
217 Posts
Re: DataSet.XMLRead not making any tables
May 29, 2012 04:17 PM|LINK
Hi all,
Thanks for the responses. The problem with reformatting the xml is....I have no control over the XML as it comes from a query of a firewall.
I'm working on an application that I can query different portions of the configuration.
I do have the xsd files for the data, would applying that somehow make this more 'doable'? My concern there is that they are generally 40-50mb in size.
Web Based Self Service Password Reset for Active Directory Accounts (OpenSource Project)
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: DataSet.XMLRead not making any tables
May 30, 2012 01:14 AM|LINK
Sorry to hear that——So：
1）Either do what the contributor Richard's said。
2）Or you can output your whole xml contents into a temporary file and do modifications as what I said，and then Read them into a DataTable。