Hello.
I am trying to create a database from an XML file. I am able to create a dataset from the XML doc, but how can I create a database schema from the dataset and populate the database? Or is this even possible using VS.NET 2003?
Part of the XML file follows. Thanks for any help.
Steven
VS.NET 2003 and C# newbie!
----- Part of the XML (one full record across several tables) --------
<!DOCTYPE PubmedArticleSet...>
- <PubmedArticleSet>
- <PubmedArticle>
- <MedlineCitation Owner="NLM" Status="Completed"><PMID>11604973</PMID>
- <DateCreated><Year>2001</Year><Month>10</Month><Day>17</Day></DateCreated>
- <DateCompleted><Year>2002</Year><Month>02</Month><Day>14</Day></DateCompleted>
- <Article>
- <Journal><ISSN>1569-6332</ISSN>
- <JournalIssue PrintYN="Y"><Volume>10</Volume><Issue>Pt 2</Issue>
- <PubDate><Year>2001</Year></PubDate></JournalIssue></Journal><ArticleTitle>Personal health information-seeking: a qualitative review of the literature.</ArticleTitle>
- <Pagination><MedlinePgn>1484-8</MedlinePgn></Pagination>
- <Abstract><AbstractText>This ...</AbstractText></Abstract><Affiliation>Division of Biomedical Informatics and Outcomes Research, Oregon Health Sciences University, Portland, OR, USA. zs*****@theriver.com</Affiliation>
- <AuthorList CompleteYN="Y">
- <Author><LastName>Stavri</LastName><ForeName>P Z</ForeName><Initials>PZ</Initials></Author></AuthorList><Language>eng</Language>
- <PublicationTypeList><PublicationType>Journal Article</PublicationType><PublicationType>Review</PublicationType><PublicationType>Review Literature</PublicationType></PublicationTypeList></Article>
- <MedlineJournalInfo><Country>Netherlands</Country><MedlineTA>Medinfo</MedlineTA><NlmUniqueID>7600347</NlmUniqueID></MedlineJournalInfo><CitationSubset>IM</CitationSubset>
- <MeshHeadingList>
- <MeshHeading><DescriptorName MajorTopicYN="N">Health Education</DescriptorName><QualifierName MajorTopicYN="Y">utilization</QualifierName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="N">Health Services Accessibility</DescriptorName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="N">Health Services Needs and Demand</DescriptorName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="N">Human</DescriptorName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="N">Information Services</DescriptorName><QualifierName MajorTopicYN="Y">utilization</QualifierName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="Y">Patient Acceptance of Health Care</DescriptorName></MeshHeading>
- <MeshHeading><DescriptorName MajorTopicYN="N">Patient Participation</DescriptorName></MeshHeading></MeshHeadingList><NumberOfReferences>63</NumberOfReferences></MedlineCitation>
- <PubmedData>
- <History>
- <PubMedPubDate PubStatus="pubmed"><Year>2001</Year><Month>10</Month><Day>18</Day><Hour>10</Hour><Minute>0</Minute></PubMedPubDate>
- <PubMedPubDate PubStatus="medline"><Year>2002</Year><Month>2</Month><Day>15</Day><Hour>10</Hour><Minute>1</Minute></PubMedPubDate></History><PublicationStatus>ppublish</PublicationStatus>
- <ArticleIdList><ArticleId IdType="pubmed">11604973</ArticleId><ArticleId IdType="medline">21490760</ArticleId></ArticleIdList></PubmedData></PubmedArticle>
- <PubmedArticle>