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>
<ApartmentPhone No>50561925</ApartmentPhoneN o>
<ChristianName> Alexan</ChristianName>
<City>Ikke angivet</City>
<Code>4000</Code>
<Country>Danmar k</Country>
<DateOfBirth>19 93-09-18T00:00:00.000 0000+02:00</DateOfBirth>
<Email>te****@t est.dk</Email>
<Email2>Jan er her</Email2>
<Floor>3</Floor>
<Forælder1Forna vn>Signe</Forælder1Fornav n>
<Forælder2Forna vn>Lennard</Forælder2Fornav n>
<Gender>Male</Gender>
<ID>110</ID>
<Klassetrin>1 0</Klassetrin>
<MiddleName>Eng strup</MiddleName>
<Nationalitet>3 .</Nationalitet>
<Persontype>Bar n</Persontype>
<Photo>/9j/4AAQSkZJRgABAQE BLAEsAAD/2wBDAAMCAgMCAgM DAwMEAwMEBQgFBQ QEBQoHBwYIDAoMD AsKCwsNDhIQDQ4R DgsLEBYQERMUFRU VDA8XGBYUGBIUFR T/wAALCACVAHQBARE A/8QAHwAAAQUBAQEB AQEAAAAAAAAAAAE CAwQFBgcICQoL/8QAtRAAAgEDAwIE AwUFBAQAAAF9AQI DAAQRBRIhMUEGE1 FhByJxFDKBkaEII 0KxwRVS0fAkM2Jy ggkKFhcYGRolJic oKSo0NTY3ODk6Q0 RFRkdISUpTVFVWV 1hZWmNkZWZnaGlq c3R1dnd4eXqDhIW Gh4iJipKTlJWWl5 iZmqKjpKWmp6ipq rKztLW2t7i5usLD xMXGx8jJytLT1NX W19jZ2uHi4+Tl5u fo6erx8vP09fb3+ Pn6/9oACAEBAAA/APs/WdZu/EWoyXN3JIQXLRRO +4RA9h27DtzjNRR wfKePz6VMkHy524 Pb0qRI8AgZPFSRx nrgcU4RjHPNEs0d uheVtqDGTjOBSG/gDuvnR7goYpuH3T 0P096qy69YxQmaW 8t4Yhnc7yqoH1Jq KLxLpc0iQx30E1y/SGKQMx/D8R+Yq3HcwTs6pK jtGdrqDyD71MbfI OOoppgyPoMc96je EKcjp3rd0jx5quj 2KWiiC4jj4Q3AZm Uf3QQw4Hb06dAK5 uODdhsHOKsrbqO3 4VLsAxhT9R9KURZ JPQmngcYJ5968x+ K/7QXhT4RQPFqd01z qmzdFY2qM8j+mTj C/jz7EV8o/EX9vTxXq9sq+HNI h0BS4JMhE7kAng5 AHIA7CvAdX+MXjn xRFdLd6zqk8EpHm 24lKowDFguM4ABZ iB0rB/wCEu1u5jgt767kn t4BtiSV2Ozk52jq v6V1GkfGLxbpDxN p2uXWnydHa2HMgP GWI+9kdc/T2r6K+DH7W13aay sfie1guYptkUuoK 7BwAMbiMNvOPoeP rX2l4e8Tab4qsI7 zTb2K8hcBleFs5B 746j8a1jGVB5IPt UDIVU7QM1EUU/eOTUqQkEcc+oq1F H6gUuxSpOMfQ0jK EOSST/Kvlb9pz9psaFFd+ FPCV039rHcl3qEJ 4tsYyqNnl+xI+7z 3r5FJutf3XN7ezX l3K+5ppZPmc98k8 kduSc9+tVr7RlEk aSRJmNAGkVdrNzn LsOWPOPmycAAYAA rH1XRpJFK292keO cKQW/LOTWfpvgi81OSRw zSCNSWOSBxz0qg2 jT2ly0bBwOPQDjA 68egrV0a0kjcyQk CTP3PmOa9a+Gvxf 8SfCzxDbahp4E1p J+7mtJSxjcHqCAS QepBAz9elfo74U8 S6f400C11fTJhNa zjI6EqRwVPJ5B4P OMjgnrWphJVDIQw PdelQtEQeAD+FWl jOwYPtU6L8pGQab 5QwM8V4T+058aJv AGmRaHoj7dd1CMs 9yDj7JD03f77chf TBPGBXwTrGmTXyC C3kLyyddg3PIeuS e/Su48F/BbWplhluZPsyy43 dCyrjoB6/416V4f/Z9064uJG1C4mkjB G1C+Ce+Tjr2rrIP 2bfDErs4aZhwdnr 9a6O2+BeiadDiGE EspHIGRnjrj3rgv Ef7NuluXkFxKCeQ ABgf1rg7v4JSabF K0MokdMhsjB9iD/nrXnnizQ7zQXV7m 0aJFfCXBXjOehz/ACPHSvsr9jXxvBr 3hXUNEkATUrCUTO VYkSq4++R2OV5Pf g9Sa+jGTcOP/r1DtAJB/QVLEuOnUetWIxle n1onPlRF1GSOgr8 3vjf4gn8c/EbWrpZ2mtVmaCEb uWRDjH04DfiaT4Q +E1ubmTUrmEOwIE e4fd+gr6E0iw81i VUADgD2711uk+H1 nZSchAMe5rq7bRo oVATAUY454q62mt KNuPxFUrzRCAA0R I5w23jiuY1Pwuh8 wiIDzBz6GvNPG/g2z1GxuLW4t1khm Qq4IHP/ANeuY/ZSjbwd8aZNMMnlx 3ltLancAfMwBJGc/RGFfcDKBweuKgKK TyCPwzSouSOMcVO oKnPHJ9ap65craa PezNkLHA75zjgAk/yr8xbm7/fXU4j+ZncHA6kgD PpXqPw6uUNnHGp2 lcZA/U17npFrttkcZIK9 QO9dzocCqio4BHX J710itEsRBRQMHp 2NQKVuCd48sLwMc 5756fWnTwbV3M2R 9OtULxIpIyqqW+u K4DxNYK8bnAOeCM fyrx7SidE+PPhsx nynluoVLegZtrD8 Qa+2FYY+7jPrSNH uOQBj60Rjd1P41M FxkAYA7iuZ+Jk4t Ph74jlZioXT5+QM 4ymK/OGS9tpr140dcKm4 8D34r0T4dQmW0ab kKGGOPvc19C+FHE tghLgAcYPrXXWs6 RuhVx9B1/nW7axxzABm+Zuc5 5A4p1xF9mDMsqso 5GKnLR3EClXUnAJ B69Kxb5lXByBweC cfzrkNYnie2eQsM HjBArxiO3/tP9oPwmsSZUTo2P UDJOfpivtQKMKR6 elRnr97HtUyrx9f 1qUDGAea8r/aL8SQab8P7nRpEc vrKPaKwbaIwQMuT 3wSBj39K/PS70C/8Na7cQ3MR3KDhuz DPBFexfD++L+HYS OCpJI45xXoeiaxe T2wt7YYJI3MR0/EVb1fV59GgAn8V6 foW9hgXz/O2MfdGeaqaDN4ji vTPB4pbUk+9t8to wwz23gj8q9S8O61 e3wFveKVaRRhycg j8Km13X5fD8Q2lp GBKIiHJz6GvJvGP iDVrvzJrvxHB4cg YdWZieTxu2ggfmK z7DSp9RsDND42t9 ewn3F4we/fd+lN+DVg7fHTST eEztHDKySjsfLYD OevGR+Ir7J6D5cf jULISTkfrVtYgqA EnFTpEVXGenXNeL ftG2P2m10Y7VKYu EO7p91cfmSPyNeA 6x4T0zVLa2iv7ow ySRsttLJh3DAfdP PTqRk5wDjOKyfA+ iC0sBbjiUko3Hbc a9ki0Af2e8dlGYb lo/lwowp7n9a8y8Wfs van4yls57XVlt7i E757mZBK0xyeTkj B56DgYHHFex6R4W XSotPieCOOO0gSG eRV3mbAA3HkANx1 6+uahutTitL60jt cbUJIOckAnjPvUf ibVPtV7ayXPzRMS hK8Yz/nFc18Svg1/wALN0OO1TUhp5WY zxXaW6secYVgTgg Y/nWOnwoutBsNJt3u/On03Oy7iOJJAzZZ Tjjb7HjrjHbofht awwfFzSJUR1JSWM D04Oc/p+dfUTqcHnJx0qF yeOnTua0AikjPBp SMAtnAx0rg/jBo66r4OuZCgke1 InwR2HDfoSfwrw+ 9XRbqARSgHzHVfL kA4BwM+3JrgfDkq Q6vcQgYAuXUAD7u Gr2/TZhDCgLcYA64Nb1 lqcER3LGWPYgf0q LXLqfULFi8flJwA mMZ5Fee6ips7pTL lWOCT7CrHiO5jm0 aJlBLbgSxAH0roP C15Pb2/lKRL/FsY5A+n61b1ieGS E4Ufd/iHT6VgfC6BG+Jdk cB2VpiOOg8v1+tf RjRgjnj61C0Yz93 9atp275pzcrz909 6ztUtI9Qsp7edA0 E6sjL/AHlPH8q+adV0B/Cmt3Fhq8fm28gKW 0u35ZUJ6g+vYjtX mqR/ZPF9wo+6LluD1wc kfpXqejXMt15ZLc HIIJNdxo9lCWBkO F64qTxHfiLSLn7L GrOiER7u7dRXlGo 6hHd2yvd30EGRnd LKqYHpzW5qOu6Nb eCWefahSMjzzIoX k8VP4B1MXekicSK 6LIQrq2QR/hmtPXJkMRKkZ29c 4qx8CtIkufE+pao yH7PbR+VG/ZnY5OPoM/mK93cfLz0NMUKBy TmpUAXbnGfWpc7k GR9KpXKgL3OPasX VNKtdWtXt7u3ing bqki559vT8K+SPi BpMehfE/WLSA4hSWORQWJIU xqf613uiW2YUbcB xzXWW98mn2cjySY QcbzkVyGueMZb2H 7LZxsynlnUEk57f rXL6Xp11ctPP9kK sEJZQgVjkYxwORn 9Kpat4GvFt7dykj 24UsI2P7uGQHIOD wDyf1xirnhfxTP4 YV4L6aNrfkJ7c5w fwzXVX+rRX8RNuT sdMg4+79K9c+C9g 9l4JgdgBJNNI5/77K/yArv23AE96YTjqe asptU4xRK+M4HHT FU7kg5zx7Vntktx yD618l/F1Vg+MGrysSPPEQ x1wREgI/QV1Phi8jlQIHJwv Ge9adxpzeJLcwQl o1Z9zA8HuPxHWuH g0CXwZqPkalLf6h YmUESpMBldy8MOM YGTkH8q7Hws/grUbqDz7yUCN7iO Q3N1JF5gEhWMklw BwOO54OKi8R3ngK 30+BF1Fr6ZVZXiM ss28sMqcZIGMEZ9 64Cy8CaN4z8fXN6 tosFipKwQbmwSON +CcAn0xXY39vHp1 61tbxqfs0Owjbuz IxwBnPXFfRnhLTP 7C8PafZy53wQqjn r8wHJ/Otw8qO4qJsZ5ODV 0BVU4FJJg5GMEdq o3IA+bBHbpVRxkE Cvkz4taU+q+K9Su YQfOjvZhkDrghQf 8Axz9ai8KajIWUb seqnqp9+a7nRtUb TdS2OUbzj8rAYx6/qM1u+VBqjCVwrEH DBumOtVb3RNKs/NWbTUWFlB80oGx9 M9OnUetYieH9F1X 97FDuKn5gAOPyFZ 15cQeFt1ztSKNTk Y9O38xW78KfD8ni rxGL67XfbWri6l3 AjdMfuKR7AZ/4CPWvoeADb0B+tT lgG9PYVE2Ccgdat xBzuO/HogHXr1OaZcTxWr KJJApbpms7UdWsr V9ss65xnAINcR4u +Jtp4Zit9ltLcS3 G5YU2kbyMd+gHIy T+Ga8q0yFfEc017 NEonuZGmZQDtG5t xArL8Q+DpNFl+32 SHyjzKi5/MVxvjLxWtmmnlph BHIxLSkgHAA47Hn n/ACa7Dw18SLPcoaV ArKBkHI/H8BXUtrH9uyNbgk QkYJHcc9/wrEk3+EklWNz5DZ OZW3H8+1eeeOPFR 8Raja6TbxCSe4mj iVVB+8WAx+dfWng XwvD4T0C2swqm4I 8yeQDO+Q9Tn24A9 gK6qM5xycZ5NStk k4GRVZpSDik1Lxb peknZJcLJLz+5iI Z/x54/Gqlpqraw5lMJVSM BW7D396sQ+FbWS6 mu5I/MkkG07snH0rI+J3 gtL7w4Li3iWSSxB dAqD7hHzAH8Afwr x3wdaGG2UAD5CYz 6cHArrb22hNo7XG CgXknoB61418Sfh Yms27m0C7WO+MDl d3Tj868HhXV/B908Nzp0gjO/BYE/iCPevSvD/wAVItOhIZ2BVj2D BVJ45qzq3xHtplL pIZ0KsCCOWHsPXk 1S+EvgnVPGnjOHU yPIt7O48xMj5lBD c/XKgj0zmvsS21LUN Pj/AH8a3aDunDY9a2r DXbW6YIJBFJ3il+ Vv16/hWkcZJz171WkAZs/0rhdD8EzxyLK5BP UgCvQtMshGiKwww GK2ooyOpx7YpSm2 NkxuRhgg/lXkup+C18M3kyRg yWU0jSwux6BiTtO fTOPpTEVJFPmgBa zbyygWIOiAxnnIr GvfC+m6wmy4tI5w V/iAJHODzXGa/wDBDQrlw0Vs1uw4 HlOcfr9a5G5+Flj pdyIILiSQkc7xnH 0r3n4Q+DU8MeE2f YFkvX8wEnkqOFP4 8mvR5rNWtVRhyw6 VBd6DBeJl413Y6k YNZn9lXVku22vJY x1C7ty/kc1NFqWrxrteKJ2 H8QyufwrpEt/LOVA56Zq5EpjPy8 cce9W0lDk5A4HFT HO0A8H2PWquoWUV 9A1vOA0Tc9OR7j6 Vw+s+Dbqx+eH/AEq3+8HQcj6iudv LZ2hwoKmsRpvs/JOD29qp6h4gVFIE YLEYyTxVfwZ4Rn8 XaibiZdlmjjzpvb +4vqx/T8s+yRWwkuIoY1V IIgMKOigDAA+g4r QC+c3yn5FGBU32Y bgRnHTntVaS3UnA OT/KmG3jY5OST3xXRa zp6WN8VQkow3gH+ H2qnuxjipIgFBYD qKsCUsyoR+NPdA5 INNjkMTfL09Kqal odjqKlprdSx43L8 rfp/hXI6j8NLWTLx3ci L/dZAf5YrMtfhdYzy efPcPIsfOxU2k/jniujtbaHT9OjW2 hSCEZRI4xgKMEk+ 596u2VsqWznJJAx n2p9qoDdOoqW4lI UY4ByeKhH7xSTzX QaN4etbzTopptxZ 8kAY4GSMcg+n61//9kA</Photo>
<PreAddress>Møl lehusvej</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******** ******@TK2MSFTN GP15.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.WriteXm l() to serialize.
It seems that I should use the XmlIgnoreAttrib ute.
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 xmlignoreattrib ute
again?
tia
Jan