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 PubmedArticleSe t...>
- <PubmedArticleS et>
- <PubmedArticl e>
- <MedlineCitatio n Owner="NLM" Status="Complet ed"><PMID>11604 973</PMID>
- <DateCreated><Y ear>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"><Vo lume>10</Volume><Issue>P t 2</Issue>
- <PubDate><Year> 2001</Year></PubDate></JournalIssue></Journal><Articl eTitle>Personal health information-seeking: a qualitative review of the literature.</ArticleTitle>
- <Pagination><Me dlinePgn>1484-8</MedlinePgn></Pagination>
- <Abstract><Abst ractText>This ...</AbstractText></Abstract><Affil iation>Division of Biomedical Informatics and Outcomes Research, Oregon Health Sciences University, Portland, OR, USA. zs*****@therive r.com</Affiliation>
- <AuthorList CompleteYN="Y">
- <Author><LastNa me>Stavri</LastName><ForeN ame>P Z</ForeName><Initi als>PZ</Initials></Author></AuthorList><Lan guage>eng</Language>
- <PublicationTyp eList><Publicat ionType>Journal Article</PublicationType ><PublicationTy pe>Review</PublicationType ><PublicationTy pe>Review Literature</PublicationType ></PublicationType List></Article>
- <MedlineJournal Info><Country>N etherlands</Country><Medlin eTA>Medinfo</MedlineTA><NlmU niqueID>7600347 </NlmUniqueID></MedlineJournalI nfo><CitationSu bset>IM</CitationSubset>
- <MeshHeadingLis t>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Health Education</DescriptorName> <QualifierNam e MajorTopicYN="Y ">utilizati on</QualifierName></MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Health Services Accessibility</DescriptorName> </MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Health Services Needs and Demand</DescriptorName> </MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Human</DescriptorName> </MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Informati on Services</DescriptorName> <QualifierNam e MajorTopicYN="Y ">utilizati on</QualifierName></MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="Y ">Patient Acceptance of Health Care</DescriptorName> </MeshHeading>
- <MeshHeading><D escriptorName MajorTopicYN="N ">Patient Participation</DescriptorName> </MeshHeading></MeshHeadingList ><NumberOfRefer ences>63</NumberOfReferen ces></MedlineCitation >
- <PubmedData>
- <History>
- <PubMedPubDat e PubStatus="pubm ed"><Year>200 1</Year><Month>10</Month><Day>18</Day><Hour>10</Hour><Minute>0</Minute></PubMedPubDate>
- <PubMedPubDat e PubStatus="medl ine"><Year>2002 </Year><Month>2</Month><Day>15</Day><Hour>10</Hour><Minute>1</Minute></PubMedPubDate></History><Public ationStatus>ppu blish</PublicationStat us>
- <ArticleIdList> <ArticleId IdType="pubmed" >11604973</ArticleId><Arti cleId IdType="medline ">21490760</ArticleId></ArticleIdList></PubmedData></PubmedArticle>
- <PubmedArticl e>