Problems with vb.net, xml and xmlignoreattribute

[Jan Nielsen]

Hi all
I have a typed dataset (vb.net) that the wizard created.
I have a photo in the dataset that I do not want to get xml serialized.
I use the function dataset.WriteXml() to serialize.

It seems that I should use the XmlIgnoreAttribute.
But where do I use this???

The dataset.vb is a very complex class

And what if I edit the dataset? Do I have to add the xmlignoreattribute
again?

tia

Jan

 

[Cor Ligthert]

Jan,

When you use a photo it is almost serialized in a dataset (database).
It is in the format of a byte arrea.
(What is very easy to do by the way)

The other method is to save the path of the pictures as a string.

Therefore where don't I understand you?

Cor

 

[Jan Nielsen]

Hi Cor
Thanks for answering.
I have a dataset with data about persons.
It contain columns like firstname, surname and a photo.
Now I would like to save my dataset as XML excluding a certain column
containing photos.
Here is an xml example (generated by the .WriteXML function of the dataset):
.....
.....
tPersoner>
<Apartment>tv</Apartment>
<ApartmentPhoneNo>50561925</ApartmentPhoneNo>
<ChristianName>Alexan</ChristianName>
<City>Ikke angivet</City>
<Code>4000</Code>
<Country>Danmark</Country>
<DateOfBirth>1993-09-18T00:00:00.0000000+02:00</DateOfBirth>
<Email>[email protected]</Email>
<Email2>Jan er her</Email2>
<Floor>3</Floor>
<Forælder1Fornavn>Signe</Forælder1Fornavn>
<Forælder2Fornavn>Lennard</Forælder2Fornavn>
<Gender>Male</Gender>
<ID>110</ID>
<Klassetrin>10</Klassetrin>
<MiddleName>Engstrup</MiddleName>
<Nationalitet>3.</Nationalitet>
<Persontype>Barn</Persontype>
<Photo>/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/wAALCACVAHQBAREA/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/APs/WdZu/EWoyXN3JIQXLRRO+4RA9h27DtzjNRRwfKePz6VMkHy524Pb0qRI8AgZPFSRxnrgcU4RjHPNEs0duheVtqDGTjOBSG/gDuvnR7goYpuH3T0P096qy69YxQmaW8t4Yhnc7yqoH1JqKLxLpc0iQx30E1y/SGKQMx/D8R+Yq3HcwTs6pKjtGdrqDyD71MbfIOOoppgyPoMc96jeEKcjp3rd0jx5quj2KWiiC4jj4Q3AZmUf3QQw4Hb06dAK5uODdhsHOKsrbqO34VLsAxhT9R9KURZJPQmngcYJ5968x+K/7QXhT4RQPFqd01zqmzdFY2qM8j+mTjC/jz7EV8o/EX9vTxXq9sq+HNIh0BS4JMhE7kAng5AHIA7CvAdX+MXjnxRFdLd6zqk8EpHm24lKowDFguM4ABZiB0rB/wCEu1u5jgt767knt4BtiSV2Ozk52jqv6V1GkfGLxbpDxNp2uXWnydHa2HMgPGWI+9kdc/T2r6K+DH7W13aaysfie1guYptkUuoK7BwAMbiMNvOPoePrX2l4e8Tab4qsI7zTb2K8hcBleFs5B746j8a1jGVB5IPtUDIVU7QM1EUU/eOTUqQkEcc+oq1FH6gUuxSpOMfQ0jKEOSST/Kvlb9pz9psaFFd+FPCV039rHcl3qEJ4tsYyqNnl+xI+7z3r5FJutf3XN7ezXl3K+5ppZPmc98k8kduSc9+tVr7RlEkaSRJmNAGkVdrNznLsOWPOPmycAAYAArH1XRpJFK292keOcKQW/LOTWfpvgi81OSRwzSCNSWOSBxz0qg2jT2ly0bBwOPQDjA68egrV0a0kjcyQkCTP3PmOa9a+Gvxf8SfCzxDbahp4E1pJ+7mtJSxjcHqCASQepBAz9elfo74U8S6f400C11fTJhNazjI6EqRwVPJ5B4POMjgnrWphJVDIQwPdelQtEQeAD+FWljOwYPtU6L8pGQab5QwM8V4T+058aJvAGmRaHoj7dd1CMs9yDj7JD03f77chfTBPGBXwTrGmTXyCC3kLyyddg3PIeuSe/Su48F/BbWplhluZPsyy43dCyrjoB6/416V4f/Z9064uJG1C4mkjBG1C+Ce+Tjr2rrIP2bfDErs4aZhwdnr9a6O2+BeiadDiGEEspHIGRnjrj3rgvEf7NuluXkFxKCeQABgf1rg7v4JSabFK0MokdMhsjB9iD/nrXnnizQ7zQXV7m0aJFfCXBXjOehz/ACPHSvsr9jXxvBr3hXUNEkATUrCUTOVYkSq4++R2OV5Pfg9Sa+jGTcOP/r1DtAJB/QVLEuOnUetWIxlen1onPlRF1GSOgr83vjf4gn8c/EbWrpZ2mtVmaCEbuWRDjH04DfiaT4Q+E1ubmTUrmEOwIEe4fd+gr6E0iw81iVUADgD2711uk+H1nZSchAMe5rq7bRooVATAUY454q62mtKNuPxFUrzRCAA0RI5w23jiuY1Pwuh8wiIDzBz6GvNPG/g2z1GxuLW4t1khmQq4IHP/ANeuY/ZSjbwd8aZNMMnlx3ltLancAfMwBJGc/RGFfcDKBweuKgKKTyCPwzSouSOMcVOoKnPHJ9ap65craaPezNkLHA75zjgAk/yr8xbm7/fXU4j+ZncHA6kgDPpXqPw6uUNnHGp2lcZA/U17npFrttkcZIK9QO9dzocCqio4BHXJ710itEsRBRQMHp2NQKVuCd48sLwMc5756fWnTwbV3M2R9OtULxIpIyqqW+uK4DxNYK8bnAOeCMfyrx7SidE+PPhsxnynluoVLegZtrD8Qa+2FYY+7jPrSNHuOQBj60Rjd1P41MFxkAYA7iuZ+Jk4tPh74jlZioXT5+QM4ymK/OGS9tpr140dcKm48D34r0T4dQmW0abkKGGOPvc19C+FHEtghLgAcYPrXXWs6RuhVx9B1/nW7axxzABm+Zuc55A4p1xF9mDMsqso5GKnLR3EClXUnAJB69Kxb5lXByBweCcfzrkNYnie2eQsMHjBArxiO3/tP9oPwmsSZUTo2PUDJOfpivtQKMKR6elRnr97HtUyrx9f1qUDGAea8r/aL8SQab8P7nRpEcvrKPaKwbaIwQMuT3wSBj39K/PS70C/8Na7cQ3MR3KDhuzDPBFexfD++L+HYSOCpJI45xXoeiaxeT2wt7YYJI3MR0/EVb1fV59GgAn8V6foW9hgXz/O2MfdGeaqaDN4jivTPB4pbUk+9t8towwz23gj8q9S8O61e3wFveKVaRRhycgj8Km13X5fD8Q2lpGBKIiHJz6GvJvGPiDVrvzJrvxHB4cgYdWZieTxu2ggfmKz7DSp9RsDND42t9ewn3F4we/fd+lN+DVg7fHTSTeEztHDKySjsfLYDOevGR+Ir7J6D5cfjULISTkfrVtYgqAEnFTpEVXGenXNeLftG2P2m10Y7VKYuEO7p91cfmSPyNeA6x4T0zVLa2iv7owySRsttLJh3DAfdPPTqRk5wDjOKyfA+iC0sBbjiUko3Hbca9ki0Af2e8dlGYblo/lwowp7n9a8y8Wfsvan4yls57XVlt7iE757mZBK0xyeTkjB56DgYHHFex6R4WXSotPieCOOO0gSGeRV3mbAA3HkANx16+uahutTitL60jtcbUJIOckAnjPvUfibVPtV7ayXPzRMShK8Yz/nFc18Svg1/wALN0OO1TUhp5WYzxXaW6secYVgTggY/nWOnwoutBsNJt3u/On03Oy7iOJJAzZZTjjb7HjrjHbofhtawwfFzSJUR1JSWMD04Oc/p+dfUTqcHnJx0qFyeOnTua0AikjPBpSMAtnAx0rg/jBo66r4OuZCgke1InwR2HDfoSfwrw+9XRbqARSgHzHVfLkA4BwM+3JrgfDkqQ6vcQgYAuXUAD7uGr2/TZhDCgLcYA64Nb1lqcER3LGWPYgf0qLXLqfULFi8flJwAmMZ5Fee6ips7pTLlWOCT7CrHiO5jm0aJlBLbgSxAH0roPC15Pb2/lKRL/FsY5A+n61b1ieGSE4Ufd/iHT6VgfC6BG+JdkcB2VpiOOg8v1+tfRjRgjnj61C0Yz939atp275pzcrz9096ztUtI9Qsp7edA0E6sjL/AHlPH8q+adV0B/Cmt3Fhq8fm28gKW0u35ZUJ6g+vYjtXmqR/ZPF9wo+6LluD1wckfpXqejXMt15ZLcHIIJNdxo9lCWBkOF64qTxHfiLSLn7LGrOiER7u7dRXlGo6hHd2yvd30EGRndLKqYHpzW5qOu6NbeCWefahSMjzzIoXk8VP4B1MXekicSK6LIQrq2QR/hmtPXJkMRKkZ29c4qx8CtIkufE+paoyH7PbR+VG/ZnY5OPoM/mK93cfLz0NMUKByTmpUAXbnGfWpc7kGR9KpXKgL3OPasXVNKtdWtXt7u3ingbqki559vT8K+SPiBpMehfE/WLSA4hSWORQWJIUxqf613uiW2YUbcBxzXWW98mn2cjySYQcbzkVyGueMZb2H7LZxsynlnUEk57frXL6Xp11ctPP9kKsEJZQgVjkYxwORn9Kpat4GvFt7dykj24UsI2P7uGQHIODwDyf1xirnhfxTP4YV4L6aNrfkJ7c5wfwzXVX+rRX8RNuTsdMg4+79K9c+C9g9l4JgdgBJNNI5/77K/yArv23AE96YTjqeasptU4xRK+M4HHTFU7kg5zx7VntktxyD618l/F1Vg+MGrysSPPEQx1wREgI/QV1Phi8jlQIHJwvGe9adxpzeJLcwQlo1Z9zA8HuPxHWuHg0CXwZqPkalLf6hYmUESpMBldy8MOMYGTkH8q7Hws/grUbqDz7yUCN7iOQ3N1JF5gEhWMklwBwOO54OKi8R3ngK30+BF1Fr6ZVZXiMss28sMqcZIGMEZ964Cy8CaN4z8fXN6tosFipKwQbmwSON+CcAn0xXY39vHp161tbxqfs0OwjbuzIxwBnPXFfRnhLTP7C8PafZy53wQqjnr8wHJ/Otw8qO4qJsZ5ODV0BVU4FJJg5GMEdqo3IA+bBHbpVRxkECvkz4taU+q+K9SuYQfOjvZhkDrghQf8Axz9ai8KajIWUbseqnqp9+a7nRtUbTdS2OUbzj8rAYx6/qM1u+VBqjCVwrEHDBumOtVb3RNKs/NWbTUWFlB80oGx9M9OnUetYieH9F1X97FDuKn5gAOPyFZ15cQeFt1ztSKNTkY9O38xW78KfD8nirxGL67XfbWri6l3AjdMfuKR7AZ/4CPWvoeADb0B+tTlgG9PYVE2CcgdatxBzuO/HogHXr1OaZcTxWrKJJApbpms7UdWsrV9ss65xnAINcR4u+Jtp4Zit9ltLcS3G5YU2kbyMd+gHIyT+Ga8q0yFfEc017NEonuZGmZQDtG5txArL8Q+DpNFl+32SHyjzKi5/MVxvjLxWtmmnlphBHIxLSkgHAA47Hnn/ACa7Dw18SLPcoaVArKBkHI/H8BXUtrH9uyNbgkQkYJHcc9/wrEk3+EklWNz5DZOZW3H8+1eeeOPFR8Raja6TbxCSe4mjiVVB+8WAx+dfWngXwvD4T0C2swqm4I8yeQDO+Q9Tn24A9gK6qM5xycZ5NStkk4GRVZpSDik1LxbpeknZJcLJLz+5iIZ/x54/Gqlpqraw5lMJVSMBW7D396sQ+FbWS6mu5I/MkkG07snH0rI+J3gtL7w4Li3iWSSxBdAqD7hHzAH8Afwrx3wdaGG2UAD5CYz6cHArrb22hNo7XGCgXknoB61418SfhYms27m0C7WO+MDld3Tj868HhXV/B908Nzp0gjO/BYE/iCPevSvD/wAVItOhIZ2BVj2DBVJ45qzq3xHtplLpIZ0KsCCOWHsPXk1S+EvgnVPGnjOHUyPIt7O48xMj5lBDc/XKgj0zmvsS21LUNPj/AH8a3aDunDY9a2rDXbW6YIJBFJ3il+Vv16/hWkcZJz171WkAZs/0rhdD8EzxyLK5BPUgCvQtMshGiKwwwGK2ooyOpx7YpSm2NkxuRhgg/lXkup+C18M3kyRgyWU0jSwux6BiTtOfTOPpTEVJFPmgBazbyygWIOiAxnnIrGvfC+m6wmy4tI5wV/iAJHODzXGa/wDBDQrlw0Vs1uw4HlOcfr9a5G5+FljpdyIILiSQkc7xnH0r3n4Q+DU8MeE2fYFkvX8wEnkqOFP48mvR5rNWtVRhyw6VBd6DBeJl413Y6kYNZn9lXVku22vJYx1C7ty/kc1NFqWrxrteKJ2H8QyufwrpEt/LOVA56Zq5EpjPy8cce9W0lDk5A4HFTHO0A8H2PWquoWUV9A1vOA0Tc9OR7j6Vw+s+Dbqx+eH/AEq3+8HQcj6iudvLZ2hwoKmsRpvs/JOD29qp6h4gVFIEYLEYyTxVfwZ4Rn8XaibiZdlmjjzpvb+4vqx/T8s+yRWwkuIoY1VIIgMKOigDAA+g4rQC+c3yn5FGBU32YbgRnHTntVaS3UnAOT/KmG3jY5OST3xXRazp6WN8VQkow3gH+H2qnuxjipIgFBYDqKsCUsyoR+NPdA5INNjkMTfL09KqalodjqKlprdSx43L8rfp/hXI6j8NLWTLx3ciL/dZAf5YrMtfhdYzyefPcPIsfOxU2k/jniujtbaHT9OjW2hSCEZRI4xgKMEk+596u2VsqWznJJAxn2p9qoDdOoqW4lIUY4ByeKhH7xSTzXQaN4etbzTopptxZ8kAY4GSMcg+n61//9kA</Photo>
<PreAddress>Møllehusvej</PreAddress>
<Sal>Rød sal</Sal>
......
......

What I do not want is the <Photo> element.
I only want the text part

Best regards

Jan

 

[Cor Ligthert]

Jan,

Than just remove the tablecolumn in a same way as you add it.
\\\
mydataset.tables.columns.remove("Photo")
///
http://msdn.microsoft.com/library/d...mdatadatacolumncollectionclassremovetopic.asp

I hope this helps?

Cor

 

[Jan Nielsen]

Hi again Cor
It doesn't really help.
I still need the column in the dataset and in the form.
It is only when I xml serialize the dataset I want to ignore the photo
column.
And I am sure I have to use xmlignoreattribute somewhere and somehow. I just
can't figure out how

Jan

 

[Cor Ligthert]

Jan,

How you serialize the dataset, that is something I almost never do (only to
get it as a string). Normaly that is done automaticly mostly by the
ds.writeXML(path)

However when you need the photo afterwards, you can copy the dataset maybe
first before you do the ds.writexml

http://msdn.microsoft.com/library/d...html/frlrfsystemdatadatasetclasscopytopic.asp

I hope this helps?

Cor

"Jan Nielsen"
...

 

[Jan Nielsen]

Hi again Cor
It does help a as a workaround. you can copy the dataset, remove the column
and then save it as xml.
But I would have liked to do it properly with the xmlignoreattribute.
Well, you can't win them all.
Thanks for your time

Jan