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>te****@test.dk</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/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCw sNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/wAALCACVAHQBAREA/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJ xFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3O Dk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIW Gh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx 8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/9oACAEBAAA/APs/WdZu/EWoyXN3JIQXLRRO+4RA9h27DtzjNRRwfKePz6VMkHy524Pb0qR I8AgZPFSRxnrgcU4RjHPNEs0duheVtqDGTjOBSG/gDuvnR7goYpuH3T0P096qy69YxQmaW8t4Yhnc7yqoH1JqKLxLp c0iQx30E1y/SGKQMx/D8R+Yq3HcwTs6pKjtGdrqDyD71MbfIOOoppgyPoMc96jeEKcjp 3rd0jx5quj2KWiiC4jj4Q3AZmUf3QQw4Hb06dAK5uODdhsHOKs rbqO34VLsAxhT9R9KURZJPQmngcYJ5968x+K/7QXhT4RQPFqd01zqmzdFY2qM8j+mTjC/jz7EV8o/EX9vTxXq9sq+HNIh0BS4JMhE7kAng5AHIA7CvAdX+MXjnxRFdL d6zqk8EpHm24lKowDFguM4ABZiB0rB/wCEu1u5jgt767knt4BtiSV2Ozk52jqv6V1GkfGLxbpDxNp2uXW nydHa2HMgPGWI+9kdc/T2r6K+DH7W13aaysfie1guYptkUuoK7BwAMbiMNvOPoePrX2l4 e8Tab4qsI7zTb2K8hcBleFs5B746j8a1jGVB5IPtUDIVU7QM1E UU/eOTUqQkEcc+oq1FH6gUuxSpOMfQ0jKEOSST/Kvlb9pz9psaFFd+FPCV039rHcl3qEJ4tsYyqNnl+xI+7z3r5FJ utf3XN7ezXl3K+5ppZPmc98k8kduSc9+tVr7RlEkaSRJmNAGkV drNznLsOWPOPmycAAYAArH1XRpJFK292keOcKQW/LOTWfpvgi81OSRwzSCNSWOSBxz0qg2jT2ly0bBwOPQDjA68egr V0a0kjcyQkCTP3PmOa9a+Gvxf8SfCzxDbahp4E1pJ+7mtJSxjc HqCASQepBAz9elfo74U8S6f400C11fTJhNazjI6EqRwVPJ5B4P OMjgnrWphJVDIQwPdelQtEQeAD+FWljOwYPtU6L8pGQab5QwM8 V4T+058aJvAGmRaHoj7dd1CMs9yDj7JD03f77chfTBPGBXwTrG mTXyCC3kLyyddg3PIeuSe/Su48F/BbWplhluZPsyy43dCyrjoB6/416V4f/Z9064uJG1C4mkjBG1C+Ce+Tjr2rrIP2bfDErs4aZhwdnr9a6O2 +BeiadDiGEEspHIGRnjrj3rgvEf7NuluXkFxKCeQABgf1rg7v4 JSabFK0MokdMhsjB9iD/nrXnnizQ7zQXV7m0aJFfCXBXjOehz/ACPHSvsr9jXxvBr3hXUNEkATUrCUTOVYkSq4++R2OV5Pfg9Sa+ jGTcOP/r1DtAJB/QVLEuOnUetWIxlen1onPlRF1GSOgr83vjf4gn8c/EbWrpZ2mtVmaCEbuWRDjH04DfiaT4Q+E1ubmTUrmEOwIEe4fd+ gr6E0iw81iVUADgD2711uk+H1nZSchAMe5rq7bRooVATAUY454 q62mtKNuPxFUrzRCAA0RI5w23jiuY1Pwuh8wiIDzBz6GvNPG/g2z1GxuLW4t1khmQq4IHP/ANeuY/ZSjbwd8aZNMMnlx3ltLancAfMwBJGc/RGFfcDKBweuKgKKTyCPwzSouSOMcVOoKnPHJ9ap65craaPezNk LHA75zjgAk/yr8xbm7/fXU4j+ZncHA6kgDPpXqPw6uUNnHGp2lcZA/U17npFrttkcZIK9QO9dzocCqio4BHXJ710itEsRBRQMHp2NQKV uCd48sLwMc5756fWnTwbV3M2R9OtULxIpIyqqW+uK4DxNYK8bn AOeCMfyrx7SidE+PPhsxnynluoVLegZtrD8Qa+2FYY+7jPrSNH uOQBj60Rjd1P41MFxkAYA7iuZ+Jk4tPh74jlZioXT5+QM4ymK/OGS9tpr140dcKm48D34r0T4dQmW0abkKGGOPvc19C+FHEtghLg AcYPrXXWs6RuhVx9B1/nW7axxzABm+Zuc55A4p1xF9mDMsqso5GKnLR3EClXUnAJB69Kx b5lXByBweCcfzrkNYnie2eQsMHjBArxiO3/tP9oPwmsSZUTo2PUDJOfpivtQKMKR6elRnr97HtUyrx9f1qUDG Aea8r/aL8SQab8P7nRpEcvrKPaKwbaIwQMuT3wSBj39K/PS70C/8Na7cQ3MR3KDhuzDPBFexfD++L+HYSOCpJI45xXoeiaxeT2wt7 YYJI3MR0/EVb1fV59GgAn8V6foW9hgXz/O2MfdGeaqaDN4jivTPB4pbUk+9t8towwz23gj8q9S8O61e3wFv eKVaRRhycgj8Km13X5fD8Q2lpGBKIiHJz6GvJvGPiDVrvzJrvx HB4cgYdWZieTxu2ggfmKz7DSp9RsDND42t9ewn3F4we/fd+lN+DVg7fHTSTeEztHDKySjsfLYDOevGR+Ir7J6D5cfjULIS TkfrVtYgqAEnFTpEVXGenXNeLftG2P2m10Y7VKYuEO7p91cfmS PyNeA6x4T0zVLa2iv7owySRsttLJh3DAfdPPTqRk5wDjOKyfA+ iC0sBbjiUko3Hbca9ki0Af2e8dlGYblo/lwowp7n9a8y8Wfsvan4yls57XVlt7iE757mZBK0xyeTkjB56Dg YHHFex6R4WXSotPieCOOO0gSGeRV3mbAA3HkANx16+uahutTit L60jtcbUJIOckAnjPvUfibVPtV7ayXPzRMShK8Yz/nFc18Svg1/wALN0OO1TUhp5WYzxXaW6secYVgTggY/nWOnwoutBsNJt3u/On03Oy7iOJJAzZZTjjb7HjrjHbofhtawwfFzSJUR1JSWMD04Oc/p+dfUTqcHnJx0qFyeOnTua0AikjPBpSMAtnAx0rg/jBo66r4OuZCgke1InwR2HDfoSfwrw+9XRbqARSgHzHVfLkA4Bw M+3JrgfDkqQ6vcQgYAuXUAD7uGr2/TZhDCgLcYA64Nb1lqcER3LGWPYgf0qLXLqfULFi8flJwAmMZ5F ee6ips7pTLlWOCT7CrHiO5jm0aJlBLbgSxAH0roPC15Pb2/lKRL/FsY5A+n61b1ieGSE4Ufd/iHT6VgfC6BG+JdkcB2VpiOOg8v1+tfRjRgjnj61C0Yz939atp2 75pzcrz9096ztUtI9Qsp7edA0E6sjL/AHlPH8q+adV0B/Cmt3Fhq8fm28gKW0u35ZUJ6g+vYjtXmqR/ZPF9wo+6LluD1wckfpXqejXMt15ZLcHIIJNdxo9lCWBkOF64qT xHfiLSLn7LGrOiER7u7dRXlGo6hHd2yvd30EGRndLKqYHpzW5q Ou6NbeCWefahSMjzzIoXk8VP4B1MXekicSK6LIQrq2QR/hmtPXJkMRKkZ29c4qx8CtIkufE+paoyH7PbR+VG/ZnY5OPoM/mK93cfLz0NMUKByTmpUAXbnGfWpc7kGR9KpXKgL3OPasXVNKtd WtXt7u3ingbqki559vT8K+SPiBpMehfE/WLSA4hSWORQWJIUxqf613uiW2YUbcBxzXWW98mn2cjySYQcbzk VyGueMZb2H7LZxsynlnUEk57frXL6Xp11ctPP9kKsEJZQgVjkY xwORn9Kpat4GvFt7dykj24UsI2P7uGQHIODwDyf1xirnhfxTP4 YV4L6aNrfkJ7c5wfwzXVX+rRX8RNuTsdMg4+79K9c+C9g9l4Jg dgBJNNI5/77K/yArv23AE96YTjqeasptU4xRK+M4HHTFU7kg5zx7VntktxyD618 l/F1Vg+MGrysSPPEQx1wREgI/QV1Phi8jlQIHJwvGe9adxpzeJLcwQlo1Z9zA8HuPxHWuHg0CXw ZqPkalLf6hYmUESpMBldy8MOMYGTkH8q7Hws/grUbqDz7yUCN7iOQ3N1JF5gEhWMklwBwOO54OKi8R3ngK30+BF 1Fr6ZVZXiMss28sMqcZIGMEZ964Cy8CaN4z8fXN6tosFipKwQb mwSON+CcAn0xXY39vHp161tbxqfs0OwjbuzIxwBnPXFfRnhLTP 7C8PafZy53wQqjnr8wHJ/Otw8qO4qJsZ5ODV0BVU4FJJg5GMEdqo3IA+bBHbpVRxkECvkz4 taU+q+K9SuYQfOjvZhkDrghQf8Axz9ai8KajIWUbseqnqp9+a7 nRtUbTdS2OUbzj8rAYx6/qM1u+VBqjCVwrEHDBumOtVb3RNKs/NWbTUWFlB80oGx9M9OnUetYieH9F1X97FDuKn5gAOPyFZ15cQe Ft1ztSKNTkY9O38xW78KfD8nirxGL67XfbWri6l3AjdMfuKR7A Z/4CPWvoeADb0B+tTlgG9PYVE2CcgdatxBzuO/HogHXr1OaZcTxWrKJJApbpms7UdWsrV9ss65xnAINcR4u+Jtp4 Zit9ltLcS3G5YU2kbyMd+gHIyT+Ga8q0yFfEc017NEonuZGmZQ DtG5txArL8Q+DpNFl+32SHyjzKi5/MVxvjLxWtmmnlphBHIxLSkgHAA47Hnn/ACa7Dw18SLPcoaVArKBkHI/H8BXUtrH9uyNbgkQkYJHcc9/wrEk3+EklWNz5DZOZW3H8+1eeeOPFR8Raja6TbxCSe4mjiVVB+ 8WAx+dfWngXwvD4T0C2swqm4I8yeQDO+Q9Tn24A9gK6qM5xycZ 5NStkk4GRVZpSDik1LxbpeknZJcLJLz+5iIZ/x54/Gqlpqraw5lMJVSMBW7D396sQ+FbWS6mu5I/MkkG07snH0rI+J3gtL7w4Li3iWSSxBdAqD7hHzAH8Afwrx3wda GG2UAD5CYz6cHArrb22hNo7XGCgXknoB61418SfhYms27m0C7W O+MDld3Tj868HhXV/B908Nzp0gjO/BYE/iCPevSvD/wAVItOhIZ2BVj2DBVJ45qzq3xHtplLpIZ0KsCCOWHsPXk1S+Ev gnVPGnjOHUyPIt7O48xMj5lBDc/XKgj0zmvsS21LUNPj/AH8a3aDunDY9a2rDXbW6YIJBFJ3il+Vv16/hWkcZJz171WkAZs/0rhdD8EzxyLK5BPUgCvQtMshGiKwwwGK2ooyOpx7YpSm2NkxuR hgg/lXkup+C18M3kyRgyWU0jSwux6BiTtOfTOPpTEVJFPmgBazbyyg WIOiAxnnIrGvfC+m6wmy4tI5wV/iAJHODzXGa/wDBDQrlw0Vs1uw4HlOcfr9a5G5+FljpdyIILiSQkc7xnH0r3n4 Q+DU8MeE2fYFkvX8wEnkqOFP48mvR5rNWtVRhyw6VBd6DBeJl4 13Y6kYNZn9lXVku22vJYx1C7ty/kc1NFqWrxrteKJ2H8QyufwrpEt/LOVA56Zq5EpjPy8cce9W0lDk5A4HFTHO0A8H2PWquoWUV9A1vO A0Tc9OR7j6Vw+s+Dbqx+eH/AEq3+8HQcj6iudvLZ2hwoKmsRpvs/JOD29qp6h4gVFIEYLEYyTxVfwZ4Rn8XaibiZdlmjjzpvb+4vqx/T8s+yRWwkuIoY1VIIgMKOigDAA+g4rQC+c3yn5FGBU32YbgRnH TntVaS3UnAOT/KmG3jY5OST3xXRazp6WN8VQkow3gH+H2qnuxjipIgFBYDqKsCU syoR+NPdA5INNjkMTfL09KqalodjqKlprdSx43L8rfp/hXI6j8NLWTLx3ciL/dZAf5YrMtfhdYzyefPcPIsfOxU2k/jniujtbaHT9OjW2hSCEZRI4xgKMEk+596u2VsqWznJJAxn2p9q oDdOoqW4lIUY4ByeKhH7xSTzXQaN4etbzTopptxZ8kAY4GSMcg +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" <no************@planet.nl> skrev i en meddelelse
news:O9**************@TK2MSFTNGP15.phx.gbl...
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" <Re**************@tiscali.dk> 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