خواندن فایل XML

[mohammad abedi]

با سلام به همه دوستان
یه فایل XML حجیم دارم که توش مقالات افراد مختلف معرفی شده

دو تا از تگاش واسم مهمه یکی تگ نامش و یکی تگ مربوط به اطلاعات مختلف

سوالم اینه که چه شکلی میتونم نام نویسنده اول و ایمیل اون شخص را خارج نمود و در دیتابیس ذخیره کرد

نمونه تگها به شکل زیره :


<PubmedArticle>
<MedlineCitation Owner="NLM" Status="MEDLINE">
<PMID Version="1">19736400</PMID>
<DateCreated>
<Year>2009</Year>
<Month>09</Month>
<Day>08</Day>
</DateCreated>
<DateCompleted>
<Year>2009</Year>
<Month>11</Month>
<Day>02</Day>
</DateCompleted>
<Article PubModel="Print">
<Journal>
<ISSN IssnType="Electronic">1998-3646</ISSN>
<JournalIssue CitedMedium="Internet">
<Volume>27</Volume>
<Issue>4</Issue>
<PubDate>
<MedlineDate>2009 Oct-Dec</MedlineDate>
</PubDate>
</JournalIssue>
<Title>Indian journal of medical microbiology</Title>
<ISOAbbreviation>Indian J Med Microbiol</ISOAbbreviation>
</Journal>
<ArticleTitle>Distribution of Malassezia species in patients with pityriasis versicolor in Northern Iran.</ArticleTitle>
<Pagination>
<MedlinePgn>321-4</MedlinePgn>
</Pagination>
<Abstract>
<AbstractText Label="PURPOSE" NlmCategory="OBJECTIVE">Malassezia yeasts are globally distributed agents of pityriasis versicolor and are implicated in the pathogenesis of seborrhoeic and atopic dermatitis. The aim of this study is to identify the Malassezia species obtained from pityriasis versicolor patients, using morphological, biochemical, physiological as well as Polymerase Chain Reaction-Restriction Fragment Length Polymorphism (PCR-RFLP) methods.</AbstractText>
<AbstractText Label="MATERIALS AND METHODS" NlmCategory="METHODS">The identification of Malassezia species is performed according to microscopic features and physiological characteristics, including catalase reaction and Tween assimilation tests. The DNA is extracted from cultured Malassezia using the glass bead, phenol-chloroform method. The internal transcribed spacer 1(ITS1) region is amplified and there is restricted digestion of the PCR products with two enzymes Cfo I and Bst F5I.</AbstractText>
<AbstractText Label="RESULTS" NlmCategory="RESULTS">The most commonly isolated species is M. globosa (47.6%). RFLP analysis of the PCR products of the ITS1 region is in complete agreement with those from the DNA sequences of the internal transcribed spacer (ITS) 1 region and the biochemical tests.</AbstractText>
<AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS">Based on the findings of this study, it can be concluded that PCR-RFLP is a relatively simple and quick method, completely comparable to the routine methods used for Malassezia identification.</AbstractText>
</Abstract>
<Affiliation>Department of Medical Mycology and Parasitology, Sari Medical School, Sari, Iran. shokohi.tahereh@gmail.com</Affiliation>
<AuthorList CompleteYN="Y">
<Author ValidYN="Y">
<LastName>Shokohi</LastName>
<ForeName>T</ForeName>
<Initials>T</Initials>
</Author>
<Author ValidYN="Y">
<LastName>Afshar</LastName>
<ForeName>P</ForeName>
<Initials>P</Initials>
</Author>
<Author ValidYN="Y">
<LastName>Barzgar</LastName>
<ForeName>A</ForeName>
<Initials>A</Initials>
</Author>
</AuthorList>
<Language>eng</Language>
<PublicationTypeList>
<PublicationType>Journal Article</PublicationType>
<PublicationType>Research Support, Non-U.S. Gov't</PublicationType>
</PublicationTypeList>
</Article>
<MedlineJournalInfo>
<Country>India</Country>
<MedlineTA>Indian J Med Microbiol</MedlineTA>
<NlmUniqueID>8700903</NlmUniqueID>
<ISSNLinking>0255-0857</ISSNLinking>
</MedlineJournalInfo>
<ChemicalList>
<Chemical>
<RegistryNumber>0</RegistryNumber>
<NameOfSubstance>DNA, Fungal</NameOfSubstance>
</Chemical>
<Chemical>
<RegistryNumber>0</RegistryNumber>
<NameOfSubstance>Polysorbates</NameOfSubstance>
</Chemical>
<Chemical>
<RegistryNumber>EC 1.11.1.6</RegistryNumber>
<NameOfSubstance>Catalase</NameOfSubstance>
</Chemical>
</ChemicalList>
<CitationSubset>IM</CitationSubset>
<MeshHeadingList>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Adolescent</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Adult</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Aged</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Animals</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Catalase</DescriptorName>
<QualifierName MajorTopicYN="N">metabolism</QualifierName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Child</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Child, Preschool</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Cluster Analysis</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">DNA, Fungal</DescriptorName>
<QualifierName MajorTopicYN="N">genetics</QualifierName>
<QualifierName MajorTopicYN="N">isolation &amp; purification</QualifierName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Female</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Genotype</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Humans</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Infant</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N" Type="Geographic">Iran</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Malassezia</DescriptorName>
<QualifierName MajorTopicYN="Y">classification</QualifierName>
<QualifierName MajorTopicYN="N">cytology</QualifierName>
<QualifierName MajorTopicYN="N">genetics</QualifierName>
<QualifierName MajorTopicYN="Y">isolation &amp; purification</QualifierName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Male</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Middle Aged</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Mycological Typing Techniques</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Polymorphism, Restriction Fragment Length</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Polysorbates</DescriptorName>
<QualifierName MajorTopicYN="N">metabolism</QualifierName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Ribotyping</DescriptorName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Tinea Versicolor</DescriptorName>
<QualifierName MajorTopicYN="Y">microbiology</QualifierName>
</MeshHeading>
<MeshHeading>
<DescriptorName MajorTopicYN="N">Young Adult</DescriptorName>
</MeshHeading>
</MeshHeadingList>
</MedlineCitation>
<PubmedData>
<History>
<PubMedPubDate PubStatus="entrez">
<Year>2009</Year>
<Month>9</Month>
<Day>9</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
<PubMedPubDate PubStatus="pubmed">
<Year>2009</Year>
<Month>9</Month>
<Day>9</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
<PubMedPubDate PubStatus="medline">
<Year>2009</Year>
<Month>11</Month>
<Day>3</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
</History>
<PublicationStatus>ppublish</PublicationStatus>
<ArticleIdList>
<ArticleId IdType="pii">IndianJMedMicrobiol_2009_27_4_321_55445</ArticleId>
<ArticleId IdType="doi">10.4103/0255-0857.55445</ArticleId>
<ArticleId IdType="pubmed">19736400</ArticleId>
</ArticleIdList>
</PubmedData>
</PubmedArticle>از این همه تگ فقط اولین تگ <Author

که داخلش واسم نام و نام خانوادگیش مهمه و تگ
<Affiliation>
که داخل اون ایمیل واسم مهمه

و خروجی بره تو یه table که دو تافیلد نام و ایمیل داره

این نکته رو بگم که این نمونه ای که گفتم مرتبا تکرار میشه

ممنون میشم که راهنماییم کنید

[atashsavar]

سلام دوست عزیز
شما میتوانیذ فایل xml خود را داخل یک dataset ریخته و سپس با استفاده از توابع dataset آن کاری که دوست دارید را انجام بدید. با استفاده از دسورات زیر :
ِDataSet ds=new DataSet();ds.ReadXml(destination);

[mohammad abedi]

با سلام و خسته نباشید

میشه لطف کنید و یکم توضیح بدید! چطور میشه به تگ خاصیش دسترسی پیدا کرد ؟