XML, XSD, DataSet???

[mrathi]

Hi,
I have several questions ...as to i have no clue about this. Any help would be appreciated. Thanks

I have a query in access database that returns 5 columns and about 50 rows. From that query I want to populate a treeview, such as:

Column1
Column2
Column3
Column4
Column5

I could do it correct upto column 4 and then I started getting error:

System.ArgumentException: These
columns don't currently have unique values.

Then I did some research and it seems, it would be a good idea to get my query in a dataset and convert it to xml and then populate the treeview from the xml file.

This is where I am clueless. I use VS 2003, and I created a .xsd file, but apart from that I don't know what and how to do. If anyone can help me in doing this I would appreciate it.

Thanks again.

 

[Veep]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconxmldataset.asp

 

[mrathi]

Hi,
Thanks for your reply.

I tried the getxml and writexml methods. It works fine, but the xml file to which I write show each row with 5 columns as one table element. How can I write so that the elements are shown as I want them to for my treeview purpose.

Thanks

 

[JohnYingling]

See if DataColumn.ColumnMapping Property will help.

http://www.VBCompare.com

Compare Code

 

[mrathi]

That is what I am looking at, can you provide an example of using it?

Thanks

 

[mrathi]

If I have my dataset, without any relations...can I still write to xml with parent-child elements?

Thanks

 

[JohnYingling]

I have not used the ColumnMapping property. Try it. It will not kill you...I don't think.

http://www.VBCompare.com

Compare Code

 

[mrathi]

Actually, I am trying to find some examples on how to use it, that is why I asked for some examples. I am still not sure how to?

Thanks

 

[JohnYingling]

See DataColumn.ColumnMapping on your MSDN disk or on the

http://www.MSDN.microsoft.com

site

http://www.VBCompare.com

Compare Code

 

[mrathi]

Thanks, I finally could figure it out and finish it.