C#дXMLµÄ¼òµ¥Àý×Ó
Õâ¸öÀý×ÓÒª°Ñbookstore.xmlÎļþÔö¼ÓÒ»Ìõbook¼Ç¼
1 bookstore.xml
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="love" ISBN="1234123">
<title>who am i </title>
<author>who</author>
<price>999</price>
</book>
</bookstore>
2 bookstore.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
namespace toxml
{
public class ToXml
{
public static void Main(string[] args)
{
//ʵÀý»¯Ò»¸öXmlDocument¶ÔÏó
XmlDocument xmlDoc = new XmlDocument();
//ʵÀý¶ÔÏó¶ÁȡҪдÈëµÄXMLÎļþ
xmlDoc.Load("bookstore.xml");
//²éÕÒ<bookstore>
XmlNode root = xmlDoc.SelectSingleNode("bookstore");
//´´½¨Ò»¸ö<book>½Úµã
XmlElement xe1 = xmlDoc.CreateElement("book");
//ÉèÖøýڵãgenreÊôÐÔ
xe1.SetAttribute("leixing", "music");
//ÉèÖøýڵãISBNÊôÐÔ
xe1.SetAttribute("ISBN", "56756");
 
Ïà¹ØÎĵµ£º
private void save_db(){
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings[""].ToString());
SqlCommand comm = new SqlCommand();
conn.Open();
SqlTransaction rollbk2= conn.BeginTransaction();
& ......
ÒÔÏÂΪһÌìµÄ»ù±¾Ñ§Ï°Çé¿ö£¬°üÀ¨Ñ§Ï°ºÍ¸´Ï°£¬Ä£Ê½²¿·ÖǰǰºóºóÒ²¿´Á˺ܶàÁË£¬µ«ÊÇһֱûÄܼá³Ö¿´Í꣬ϣÍûÕâ´Î¿ÉÒÔ¼á³ÖÏÂÈ¥¡£
ģʽ²¿·ÖÎÒûÓÐÖ±½ÓÈ¥¿´±È½Ï¾µäµÄ¡¶javaÓëģʽ¡·£¬ÕâÊéÌ«ºñÈÝÒ×ÈÃÎÒ¼á³Ö²»ÏÂÈ¥£¬¶øÊDzÉÓÃÁ˳̽ÜдµÄ¡¶´ó»°Éè¼ÆÄ£Ê½¡·£¬
ÕâÊéдµÄºÜÓÐÒâ˼£¬Ò²ºÜÈÝÒ×Àí½â¡£Ï£ÍûÕâÑùµÄÊé¿ÉÒÔ¶àЩ¡£ºÇºÇ£¬µ±È»µÈ¿´ ......
XMLÖÐÒ»ÖÖÀ©Õ¹µÄ±ê¼ÇÓïÑÔ,Ëü¾ßÓкܺõÄÀ©Õ¹ÐÔ±ê¼Ç.±¾ÎÄͨ¹ýXMLʵÏÖ²»Í¬Êý¾Ý¿âµÄ¶¨Òå,ʵÏÖ¶ÔXMLÊý¾Ý¿âµÄ·ÃÎʺÍÒì¹¹Êý¾Ý¿âÖ®¼äµÄ»¥·Ã.
¡¡¡¡¹Ø¼ü´Ê:XML Òì¹¹Êý¾Ý¿â ÐÅÏ¢½»»» Êý¾Ý¿â·ÃÎÊ
1 ÒýÑÔ
¡¡¡¡XML(Extensible Markup Language)ËüÊÇÓÉW3C×éÖ¯ÓÚ1998Äê2Ô &nb ......
ÊÖ»úÉÏÍøÔ½À´Ô½ÆÕ¼°£¬ÊÖ»úÖÖÀàÔ½À´Ô½¶à£¬Òª¿ª·¢Ò»¸ö¹©ÊÖ»ú·ÃÎÊÍøÕ¾²¢¼æÈÝËùÓв»Í¬ÀàÐ͵ÄÊÖ»úºÍä¯ÀÀÆ÷ÊǺܲ»ÈÝÒ׵쬱±¾©Ê¦·¶´óѧ×ÔϰÊÒ²éѯƽ̨µÄÊÖ»ú°æ×î³õÊÇÖ±½ÓÓÃASP.NETʵÏֵģ¬Ö»ÊÇÓÃCSS¶¨Òå³ÉÁËÊʺÏÊÖ»úÆÁÄ»µÄÒ³Ãæ£¬ËäȻͬѧÃÇ·ÃÎÊ»ù±¾Ã»ÓÐÎÊÌ⣬µ«ÊÇҲż¶û»áÓГ²»ÄÜÑ¡ÔñÏÂÀ²Ëµ¥”¡¢“°´Å¥button²»Ä ......
´ó¼Ò¶¼ÖªµÀÔÚSQL ServerÖÐÀûÓà FOR XML PATH Óï¾äÄܹ»°Ñ²éѯµÄÊý¾ÝÉú³ÉXMLÊý¾Ý£¬ÏÂÃæÊÇËüµÄһЩӦÓÃʾÀý¡£
DECLARE @TempTable table(UserID int , UserName nvarchar(50));
insert into @TempTable (UserID,UserName) values (1,'a')
insert into @TempTable (UserID,UserName) values (2,'b')
select UserID, ......