Code for storing a typical XML file into SQl server database in 1 or more tables using asp.net using C#.
<?xml version="1.0" ?> <!DOCTYPE PubmedArticleSet (View Source for full doctype...)> - <PubmedArticleSet> - <PubmedArticle> - <MedlineCitation Owner="NLM" Status="In-Data-Review"> <PMID Version="1">22500280</PMID> - <DateCreated> <Year>2012</Year> <Month>04</Month> <Day>13</Day> </DateCreated> - <Article PubModel="Print-Electronic"> - <Journal> <ISSN IssnType="Electronic">2093-6516</ISSN> - <JournalIssue CitedMedium="Internet"> <Volume>45</Volume> <Issue>2</Issue> - <PubDate> <Year>2012</Year> <Month>Apr</Month> </PubDate> </JournalIssue> <Title>The Korean journal of thoracic and cardiovascular surgery</Title> <ISOAbbreviation>Korean J Thorac Cardiovasc Surg</ISOAbbreviation> </Journal> <ArticleTitle>Analysis.</ArticleTitle> - <Pagination> <MedlinePgn>101-9</MedlinePgn> </Pagination> - <Abstract> <AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">small cell lung cancer.</AbstractText> <AbstractText Label="MATERIALS AND METHODS" NlmCategory="METHODS"> molecular markers were selected.</AbstractText> <AbstractText Label="RESULTS" NlmCategory="RESULTS"> recurrence.</AbstractText> <AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS"> disease-free survival.</AbstractText> </Abstract> <Affiliation>Korea.</Affiliation> - <AuthorList CompleteYN="Y" Type="authors"> - <Author ValidYN="Y"> <LastName>Cho</LastName> <ForeName>Sukki</ForeName> <Initials>S</Initials> </Author> - <Author ValidYN="Y"> <LastName>Park</LastName> <ForeName>Tae In</ForeName> <Initials>TI</Initials> </Author> - <Author ValidYN="Y"> <LastName>Lee</LastName> <ForeName>Eung-Bae</ForeName> <Initials>EB</Initials> </Author> - <Author ValidYN="Y"> <LastName>Son</LastName> <ForeName>Shin-Ah</ForeName> <Initials>SA</Initials> </Author> </AuthorList> <Language>eng</Language> - <PublicationTypeList> <PublicationType>Journal Article</PublicationType> </PublicationTypeList> - <ArticleDate DateType="Electronic"> <Year>2012</Year> <Month>04</Month> <Day>03</Day> </ArticleDate> </Article> - <MedlineJournalInfo> <Country>Korea (South)</Country> <MedlineTA>Korean J Thorac Cardiovasc Surg</MedlineTA> <NlmUniqueID>101563922</NlmUniqueID> <ISSNLinking>2233-601X</ISSNLinking> </MedlineJournalInfo> </MedlineCitation> - <PubmedData> - <History> - <PubMedPubDate PubStatus="received"> <Year>2011</Year> <Month>9</Month> <Day>09</Day> </PubMedPubDate> - <PubMedPubDate PubStatus="revised"> <Year>2011</Year> <Month>9</Month> <Day>28</Day> </PubMedPubDate> - <PubMedPubDate PubStatus="accepted"> <Year>2011</Year> <Month>10</Month> <Day>16</Day> </PubMedPubDate> - <PubMedPubDate PubStatus="epublish"> <Year>2012</Year> <Month>4</Month> <Day>03</Day> </PubMedPubDate> - <PubMedPubDate PubStatus="entrez"> <Year>2012</Year> <Month>4</Month> <Day>14</Day> <Hour>6</Hour> <Minute>0</Minute> </PubMedPubDate> - <PubMedPubDate PubStatus="pubmed"> <Year>2012</Year> <Month>4</Month> <Day>14</Day> <Hour>6</Hour> <Minute>0</Minute> </PubMedPubDate> - <PubMedPubDate PubStatus="medline"> <Year>2012</Year> <Month>4</Month> <Day>14</Day> <Hour>6</Hour> <Minute>0</Minute> </PubMedPubDate> </History> <PublicationStatus>ppublish</PublicationStatus> - <ArticleIdList> <ArticleId IdType="doi">10.5090/kjtcs.2012.45.2.101</ArticleId> <ArticleId IdType="pubmed">22500280</ArticleId> </ArticleIdList> </PubmedData> </PubmedArticle> </PubmedArticleSet>
Ads