insert values in xml

03.31.06 View of ...."> <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> </head> <body> <form name="aspnetForm" method="post" action="ViewForum.aspx?ForumId=168127&" id="aspnetForm"> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTc4MjA5NDIyOWRk2eWSgcA/giw/OSgLieypAem6X3Y=" /> <table cellpadding="0" cellspacing="0" width='100%' border=0> <tr> <td align="left" valign="top" width="200"> <a href='http://www.dotnetspider.com'><img src='http://www.dotnetspider.com/images/spiderlogo.jpg' alt='C# Tutorials and offshore development in India' border=0 /></a> </td> <td align="left" colspan=3 valign="top" > <script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </td> </tr> <tr height="2"> <td colspan="4"></td> </tr> <tr> <td align="center" colspan="4"> <table cellpadding="0" cellspacing="0" width='100%'> <tr> <td class="fillSpacer" width='10%'> </td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/tutorials/'>Tutorials</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/resources/'>Resources</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/forum/'>Forum</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/communities/'>Communities</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/questions/'>Interview</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/jobs/'>Jobs</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='100' align=center><a href='/projects/'>Projects</a></td> <td class='tabSpacer'> </td> <td class='shadeTab' width='170' align=center><a href='/offshore/'>Offshore Development</a></td> <td class='tabSpacer'> </td> <td class="fillSpacer" width='10%'> </td> </tr> </table> </td> </tr> <tr height="20"> <td class="secondBar" colspan="4" align="left"> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td width="5"> </td> <td align="center"> <a href='/tutorials/Silverlight-Tutorials.aspx' class='menu2'>Silverlight Tutorials</a> | <a href='/mentors/' class='menu2'>Mentor</a> | <a href='/convert/' class='menu2'>Code Converter</a> | <a href='/resources/ResourceType-1-Articles.aspx' class='menu2'>Articles</a> | <a href='/resources/ResourceType-5-Code-Snippets.aspx' class='menu2'>Code Factory</a> | <a href='/resources/ResourceType-8-Computer-Jokes.aspx' class='menu2'>Computer Jokes</a> | <a href='/members/index.aspx' class='menu2'>Members</a> | <a href='/appraisal/' class='menu2'>Peer Appraisal</a> | <a href='/it/' class='menu2'>IT Companies</a> | <a href='/bookmarks/' class='menu2'>Bookmarks</a> | <a href='/adsense/' class='menu2'>Revenue Sharing</a> | </td> <td width=25></td> <td> <div id="ctl00_pnlSearch"> <input name="ctl00$txtSearch" type="text" size="20" id="ctl00_txtSearch" /> <input type="submit" name="ctl00$btnSearch" value="Search" id="ctl00_btnSearch" /> </div> </td> </tr> </table> </td> </tr> </table> <table cellpadding=5 cellspacing=1 bgcolor=#B4CFEC height="500" width='100%'> <tr bgcolor=white> <td width='162' valign=TOP> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> Prizes & Awards <table height=110> <tr> <td align=center> <A HREF="javascript:doLink();" onMouseOver="status=url[ct];return true;" onMouseOut="status=''"><IMG NAME="Ad_Image" SRC="/images/general/cash.jpg" BORDER=0></A> </td> </tr> </table> My Profile <ul class='activeList'> <LI><a href='/Members/Login.aspx' runat=server>Sign In</a><LI><a href='/members/Register.aspx' runat=server>Register</a><LI><a href='/adsense/'>AdSense Revenue</a> </ul> <script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> Active Members Today<ul class='activeList'><LI><a href='/member/athiraappukuttan.aspx'>Appukuttan</a> (94)</LI><LI><a href='/member/mooncoder.aspx'>Abhi</a> (72)</LI><LI><a href='/member/babu_akkandi.aspx'>Babu Akkandi</a> (63)</LI></ul>Last 7 Days<ul class='activeList'><LI><a href='/member/athiraappukuttan.aspx'>Appukuttan</a> (619)</LI><LI><a href='/member/babu_akkandi.aspx'>Babu Akkandi</a> (470)</LI><LI><a href='/member/divya_diya.aspx'>divya</a> (321)</LI></ul> <a href='/members/Topperformers.aspx'>more...</a> </td> <td valign=TOP> <table bgcolor="Gold" width="99%" cellpadding="3" cellspacing="1"> <tr bgcolor="white"> <td align="center"> <a href='/communities/'><img src='/images/general/comm_icon.jpg' border='0' /></a> New Feature: <a href="/communities/">Community Sites</a>: Create your own .NET community website and start earning from Google AdSense ! It's Free ! </td> </tr> </table> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <table width='100%' cellpadding="5" cellspacing=1 bgcolor="#ccff99"> <tr> <td class=resourceBar colspan=2 width='65%'> <h1>insert values in xml</h1> Posted Date: 29 Aug 2008 Total Responses: 1 </td> <td class=resourceBar valign="top"> Posted By: <a href='/member/sravanthi.supriya.aspx'>supriya</a> Member Level: <a href='/general/MembershipLevels.aspx' title='Total Points: 24'>Bronze</a> <a href='/General/ContentRating.aspx?EntityType=3&EntityId=168127'>Points</a>: 1 </td> </tr> <tr bgcolor=white> <td valign="top" colspan="3"> <category name="Introducing Seattle"> <image> <date>03.31.06</date> <title>View of Seattle</title> <desc>View of Seattle</desc> </image> </category> from above like that only values will be inserted <table align=left cellpadding=6> <tr> <td> <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </td> <td width='10'></td> <td> <script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </td> </tr> </table> </td> </tr> <tr> <td colspan=3 class=resourceBar> <h1 id="ctl00_ContentPlaceHolder1_responses">Responses</h1> </td> </tr> <tr><TD class='authorBar'>Author: <a href='../member/sankkrit.aspx'>ANIL PANDEY</a> 29 Aug 2008</td><td class='authorBar'>Member Level: <a href='../General/MembershipLevels.aspx' Title='Total Points: 6831'>Diamond</a></td><TD class='authorBar' valign=middle>Rating: <img src='/images/general/yellowstar.jpg' width=20 border=0> <a href='/general/ContentRating.aspx?EntityType=4&EntityId=289231'>Points</a>: 1</td></tr><tr bgcolor=white><td colspan=3> hi, u can refer the following code to create a XML file public XmlDocument get_AllArticle(int lintID) { BLL_Issue BobjIssue = new BLL_Issue(); BLL_Author BobjAuthor = new BLL_Author(); BLL_Search BobjSearch = new BLL_Search(); BLL_Resource BobjRes = new BLL_Resource(); int intCounter; string strTitle; string strTopic; string strAuthor; string strFname; string strLname; string strSummary; string strFileContent; string strAff; string strText; string strID; string strServerIP; char[] chrArray = { (char)34 }; string strQuote = chrArray.ToString(); DateTime dtIDate; DataSet lds = new DataSet(); DataSet ldsIssue = new DataSet(); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); XmlDocument xmlDoc = new XmlDocument(); //Getting the ServerIP strServerIP = BobjRes.GetServerIP(); //Getting the IssueId or ArticleId if (lintID == 0) { string ID; ID = Convert.ToString((SqlHelper.ExecuteScalar(strConnStr, CommandType.Text, "select top 1 ID from tbIssues where IsArchive='true' order by issueDate desc "))); lintID = Convert.ToInt32(ID.ToString()); } lds = SqlHelper.ExecuteDataset(strConnStr, CommandType.Text, "select * from tbArticles where IssueId=" + lintID + " order by ArticleOrderNo");//BobjSearch.getArticleById(lintID); ldsIssue = SqlHelper.ExecuteDataset(strConnStr, CommandType.Text, "select ID,VolumeNo,IssueNo,convert(VARCHAR, IssueDate,107) as IssueDate,PDFFileName,IsArchive from tbIssues where ID=" + lintID);//Convert.ToInt32(.ToString()); XmlTextWriter tw = new XmlTextWriter(sw); tw.Formatting = Formatting.Indented; //for xml tags to be indented// tw.WriteStartDocument(); tw.WriteStartElement("issue"); tw.WriteAttributeString("issueid", ldsIssue.Tables[0].Rows[0]["ID"].ToString()); tw.WriteAttributeString("issueno", ldsIssue.Tables[0].Rows[0]["IssueNo"].ToString()); tw.WriteAttributeString("volume", ldsIssue.Tables[0].Rows[0]["VolumeNo"].ToString()); dtIDate = Convert.ToDateTime(ldsIssue.Tables[0].Rows[0]["IssueDate"].ToString()); tw.WriteAttributeString("date", dtIDate.ToString("MMMM d, yyyy")); tw.WriteAttributeString("archive", ldsIssue.Tables[0].Rows[0]["IsArchive"].ToString()); if (ldsIssue.Tables[0].Rows[0]["PDFFileName"].ToString().Trim() != "") { tw.WriteAttributeString("urlpath", "../uploads/Issue/" + ldsIssue.Tables[0].Rows[0]["PDFFileName"].ToString()); } else { tw.WriteAttributeString("urlpath", "UserPages/printarticle.aspx?pt=" + lintID); } if (strServerIP != "") { tw.WriteAttributeString("serverip", strServerIP); } tw.WriteStartElement("articles"); for (intCounter = 0; intCounter < lds.Tables[0].Rows.Count; intCounter++) { strFileContent = lds.Tables[0].Rows[intCounter]["Contents"].ToString(); string title = string.Empty; XmlDocument doc = new XmlDocument(); doc.Load(new StringReader(strFileContent)); XmlNodeList articleList = doc.GetElementsByTagName("article"); tw.WriteStartElement("article"); foreach (XmlNode node in articleList) { XmlElement articleElement = (XmlElement)node; strID = articleElement.GetElementsByTagName("id")[0].InnerText; tw.WriteAttributeString("id", strID); strTopic = articleElement.GetElementsByTagName("topic")[0].InnerText; tw.WriteElementString("topic", strTopic); strTitle = articleElement.GetElementsByTagName("title")[0].InnerText; tw.WriteElementString("title", strTitle); tw.WriteStartElement("authors"); XmlNodeList authorList = doc.GetElementsByTagName("authors"); foreach (XmlNode node1 in authorList) { tw.WriteStartElement("author"); XmlElement authorElement = (XmlElement)node1; strFname = authorElement.GetElementsByTagName("fname")[0].InnerText; tw.WriteElementString("fname", strFname); strLname = authorElement.GetElementsByTagName("lname")[0].InnerText; tw.WriteElementString("lname", strLname); strAuthor = authorElement.GetElementsByTagName("suffix")[0].InnerText; if (strAuthor != "") { tw.WriteElementString("suffix", strAuthor); } strAff = authorElement.GetElementsByTagName("affiliation")[0].InnerText; tw.WriteElementString("affiliation", strAff); tw.WriteEndElement(); } tw.WriteEndElement(); strSummary = articleElement.GetElementsByTagName("summary")[0].InnerText; tw.WriteElementString("summary", strSummary); strText = articleElement.GetElementsByTagName("text")[0].InnerText; tw.WriteElementString("text", strText); tw.WriteEndElement(); } } tw.WriteEndElement(); tw.WriteEndElement(); tw.Close(); tw.Flush(); xmlDoc.LoadXml(sb.ToString()); return xmlDoc; } // Function for Getting the XML Document For PDF Generation. public XmlDocument get_AllArticleForPDF(int lintID) { BLL_Issue BobjIssue = new BLL_Issue(); BLL_Author BobjAuthor = new BLL_Author(); BLL_Search BobjSearch = new BLL_Search(); BLL_Resource BobjRes = new BLL_Resource(); int intCounter; string strTitle; string strTopic; string strAuthor; string strFname; string strLname; string strFileContent; string strAff; string strText; string strID; string strServerIP; char[] chrArray = { (char)34 }; string strQuote = chrArray.ToString(); DateTime dtIDate; DataSet lds = new DataSet(); DataSet ldsIssue = new DataSet(); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); XmlDocument xmlDoc = new XmlDocument(); //Getting the ServerIP strServerIP = BobjRes.GetServerIP(); //Getting the IssueId or ArticleId if (lintID == 0) { string ID; ID = Convert.ToString((SqlHelper.ExecuteScalar(strConnStr, CommandType.Text, "select top 1 ID from dbo.tbIssues where IsArchive='true' order by issueDate desc "))); lintID = Convert.ToInt32(ID.ToString()); } lds = SqlHelper.ExecuteDataset(strConnStr, CommandType.Text, "select ID,IssueId,Contents,ArticleOrderNo,ModifiedBy,ModifiedDate from dbo.tbArticles where IssueId=" + lintID + " order by ArticleOrderNo");//BobjSearch.getArticleById(lintID); ldsIssue = SqlHelper.ExecuteDataset(strConnStr, CommandType.Text, "select ID,VolumeNo,IssueNo,convert(VARCHAR, IssueDate,107) as IssueDate,PDFFileName,IsArchive from dbo.tbIssues where ID=" + lintID);//Convert.ToInt32(.ToString()); XmlTextWriter tw = new XmlTextWriter(sw); tw.Formatting = Formatting.Indented; //for xml tags to be indented// tw.WriteStartDocument(); tw.WriteStartElement("issue"); tw.WriteAttributeString("issue", ldsIssue.Tables[0].Rows[0]["ID"].ToString()); tw.WriteAttributeString("issueno", ldsIssue.Tables[0].Rows[0]["IssueNo"].ToString()); tw.WriteAttributeString("volume", ldsIssue.Tables[0].Rows[0]["VolumeNo"].ToString()); dtIDate = Convert.ToDateTime(ldsIssue.Tables[0].Rows[0]["IssueDate"].ToString()); tw.WriteAttributeString("date", dtIDate.ToString("MMMM d, yyyy")); tw.WriteAttributeString("archive", ldsIssue.Tables[0].Rows[0]["IsArchive"].ToString()); if (ldsIssue.Tables[0].Rows[0]["PDFFileName"].ToString().Trim() != "") { tw.WriteAttributeString("urlpath", "../uploads/Issue/" + ldsIssue.Tables[0].Rows[0]["PDFFileName"].ToString()); } else { tw.WriteAttributeString("urlpath", "UserPages/printarticle.aspx?pt=" + lintID); } if (strServerIP != "") { tw.WriteAttributeString("serverip", strServerIP); } tw.WriteStartElement("articles"); int intTopicSrNo = 0; for (intCounter = 0; intCounter < lds.Tables[0].Rows.Count; intCounter++) { strFileContent = lds.Tables[0].Rows[intCounter]["Contents"].ToString(); string title = string.Empty; XmlDocument doc = new XmlDocument(); doc.Load(new StringReader(strFileContent)); XmlNodeList articleList = doc.GetElementsByTagName("article"); tw.WriteStartElement("article"); intTopicSrNo++; foreach (XmlNode node in articleList) { XmlElement articleElement = (XmlElement)node; strID = articleElement.GetElementsByTagName("id")[0].InnerText; tw.WriteAttributeString("id", strID); strTopic = articleElement.GetElementsByTagName("topic")[0].InnerText; //tw.WriteElementString("topic", strTopic); tw.WriteStartElement("topic"); tw.WriteAttributeString("id",Convert.ToString(intTopicSrNo)); tw.WriteString(strTopic); tw.WriteEndElement(); strTitle = articleElement.GetElementsByTagName("title")[0].InnerText; tw.WriteElementString("title", strTitle); XmlNodeList authorList = doc.GetElementsByTagName("authors"); string strAuthorFullName = string.Empty; foreach (XmlNode node1 in authorList) { XmlElement authorElement = (XmlElement)node1; strFname = authorElement.GetElementsByTagName("fname")[0].InnerText; strLname = authorElement.GetElementsByTagName("lname")[0].InnerText; strAuthor = authorElement.GetElementsByTagName("suffix")[0].InnerText; strAff = authorElement.GetElementsByTagName("affiliation")[0].InnerText; strAuthorFullName = ""; if (strAuthor != "") { strAuthorFullName = strFname + " " + strLname + " " + strAuthor; } else { strAuthorFullName = strFname + " " + strLname; } if (strAuthorFullName.Trim() == "") { tw.WriteElementString("authors", ""); } else { tw.WriteElementString("authors", strAuthorFullName); } tw.WriteElementString("affiliations",""); } strText = articleElement.GetElementsByTagName("text")[0].InnerText; tw.WriteElementString("fulltext", strText); tw.WriteEndElement(); } } tw.WriteEndElement(); tw.WriteEndElement(); tw.Close(); tw.Flush(); xmlDoc.LoadXml(sb.ToString()); return xmlDoc; } #endregion thanks anil Thanks & Regards Anil Kumar Pandey </td></tr><tr> <td class=resourceBar colspan=2>Post Reply</td> <td class=resourceBar align=right> </td> </tr> <tr bgcolor=white> <td colspan=3> <table> <tr> <td valign="top"> <script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </td> <td valign="top"> You must <a href='../members/Login.aspx?ReturnUrl=/forum/ViewForum.aspx?ForumId=168127&'>Sign In</a> to post a response. </td> <td valign="top"> </td> </tr> </table> </td> </tr> </table> <table width='100%' cellpadding="5" cellspacing=1 bgcolor="#ccff99"> <tr bgcolor=white> <td valign=top width='40%' colspan=1> <table cellspacing="8"> <tr> <td bgcolor="#009900" width="15" height="15"></td> <td>Next : <a href='168061-XML.aspx'>XML</a></td> </tr> <tr> <td bgcolor="#0066ff" width="15" height="15"></td> <td>Previous : <a href='168258-xml-xsl.aspx'>xml and xsl</a></td> </tr> <tr> <td bgcolor="#ff0033" width="15" height="15"></td> <td><a href='index.aspx'>Return to Discussion Forum</a> </td> </tr> <tr> <td bgcolor="yellow" width="15" height="15"></td> <td><a href='PostForum.aspx'>Post New Message</a> </td> </tr> <tr> <td bgcolor="orange" width="15" height="15"></td> <td>Category: <a href='Category26.aspx'>XML</a> </td> </tr> </table> </td> <td colspan=2 valign=top> <table cellspacing="5"> <tr> <td colspan=2> Related Messages<UL><LI><a href='156889-Xml-Html-Conversion.aspx'>Xml to Html Conversion</a> <LI><a href='156971-Hi.aspx'>Hi</a> <LI><a href='157198-xml-version.aspx'>xml version</a> <LI><a href='157203-hai.aspx'>hai</a> <LI><a href='157210-hai.aspx'>hai</a> </UL> </td> </tr> </table> </td> </tr> </table> <hr style="height:1px" color=silver /> <table> <tr> <td valign=TOP width='33%'><script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </td> <td valign=TOP width='33%'><script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </td> <td valign=TOP width='33%'> <a href='http://dotnetslackers.com' target=_blank>dotNet Slackers</a> <a href='http://www.topxml.com' target=_blank>BizTalk Adaptors</a> <a href='http://www.webdevforums.com' target=_blank>Web Design</a>  </td> </tr> </table> </td> </tr> </table> <CENTER> <a href="../general/Contactus.aspx">Contact Us</a> <a href="../general/PrivacyPolicy.aspx">Privacy Policy</a> <a href="../general/TermsOfUse.aspx">Terms Of Use</a> </CENTER> <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct = "UA-4428394-1"; urchinTracker(); </script> <script type="text/javascript">  </script> <script type="text/javascript" src="http://a.lakequincy.com/s.js"></script> </form> </body> </html>