XML ÐòÁл¯Ê¾Àý
XML ÐòÁл¯¿ÉÒÔ²ÉÓôӼòµ¥µ½¸´ÔӵĶàÖÖÐÎʽ¡£ÀýÈ磬¿ÉÒÔÐòÁл¯Ö»°üº¬¹«¹²×ֶκ͹«¹²ÊôÐÔµÄÀ࣬Èç XML ÐòÁл¯¼ò½éÖÐËùʾ¡£ÏÂÃæµÄ´úÂëʾÀýÌÖÂÛ¸÷Öָ߼¶·½°¸£¬°üÀ¨ÈçºÎʹÓà XML ÐòÁл¯Éú³É·ûºÏÌØ¶¨ XML ¼Ü¹¹ (XSD) ÎĵµµÄ XML Á÷¡£
ÐòÁл¯Êý¾Ý¼¯
³ýÁËÐòÁл¯¹«¹²ÀàµÄʵÀýÍ⣬»¹¿ÉÐòÁл¯ DataSet µÄʵÀý£¬ÈçÏÂÃæµÄ´úÂëʾÀýËùʾ¡£
private void SerializeDataSet(string filename){
XmlSerializer ser = new XmlSerializer(typeof(DataSet));
// Creates a DataSet; adds a table, column, and ten rows.
DataSet ds = new DataSet("myDataSet");
DataTable t = new DataTable("table1");
DataColumn c = new DataColumn("thing");
t.Columns.Add(c);
ds.Tables.Add(t);
DataRow r;
for(int i = 0; i<10;i++){
r = t.NewRow();
r[0] = "Thing " + i;
t.Rows.Add(r);
}
TextWriter writer = new StreamWriter(filename);
ser.Serialize(writer, ds);
writer.Close();
}
ÐòÁл¯ XmlElement ºÍ XmlNode
»¹¿ÉÐòÁл¯ XmlElement »ò XmlNode ÀàµÄʵÀý
private void SerializeElement(string filename){
XmlSerializer ser = new XmlSerializer(typeof(XmlElement));
XmlElement myElement=
new XmlDocument().CreateElement("MyElement", "ns");
myElement.InnerText = "Hello World";
TextWriter writer = new StreamWriter(filename);
ser.Serialize(writer, myElement);
writer.Close();
}
private void SerializeNode(string filename){
XmlSerializer ser = new XmlSerializer(typeof(XmlNode));
XmlNode myNode= new XmlDocument().
CreateNode(XmlNodeType.Element, "MyNode", "ns");
myNode.InnerText = "Hello Node";
TextWriter writer = new StreamWriter(filename);
ser.Serialize(writer, myNode)
Ïà¹ØÎĵµ£º
ƽʱ×öÓÎÏ·¿ª·¢µÄʱºò£¬ºÜ´ó³Ì¶ÈÉ϶¼»á²ÉÓÃxmlÀ´×öÅäÖÃÎļþ¡£ÓÐʱºòÐèҪдºÜ¶à£¬È»ºóÓÖÐèÒªÒÀ´ÎÈ¥½âÎö¡£Èç¹ûÓÐÒ»¸ö¹¤¾ßÀ´×Ô¶¯½âÎöÿһ¸öxml£¬²¢ÇÒÌáÈ¡³ö×Ô¼ºÐèÒªµÄÊý¾Ý£¬¶àºÃѽ¡£ËùÒÔ͵Á˸öÀÁ£¬Ð´ÁËÒ»¸ö½âÎöÒ»¶¨¸ñʽµÄxmlºÍ½âÎöÀ࣬°ÑÕâ¸ö¸ñʽ¶ª¸ø²ß»®×Ô¼ºÈ¥µ÷ÕûÊý¾ÝÀ²¡£Í¬Ê±×Ô¼ºÕâ±ßÖ»ÐèÒª½ÓÊÜÏֳɵÄÀà
×¢Ò⣬ÕâÀïµÄÖ¸µÄÀ ......
AjaxºÍjspµÄ¹ÖÏÖÏó
Èç¹ûÓÃAjaxÈ¥ÇëÇóÒ»¸öjspÒ³Ãæ£¬¸ÃjspÒ³Ãæ·µ»ØµÄÊÇxml£¨response.setContentType("text/xml; charset=GB2312");£©£¬²¢ÇÒ¸Ãjsp°üº¬ÏÂÃæÕâЩͷ@pageÖ¸ÁîµÄ»°£¬ÔòÔÚ¿Í»§¶Ëxml=XMLHttpRequest.responseXMLµÃµ½µÄÊÇÒ»¸ö²»°üº¬ÈÎÎñ¶«Î÷µÄxml¶ÔÏ󣬼´xml.childNodes.length½«»áÊÇ0.
......
ŪÁËÁ½Ì죬ÖÕÓڰѸ´ÔÓµÄxmlÎļþµÄÊý¾Ý¸ù¾Ý×Ô¼ºµÄÒªÇó¶Á³öÀ´£¬ÏÔʾÔÚÒ³ÃæÉÏÁË¡£flexͨ¹ýHTTPService×é¼þ·¢ËÍÇëÇ󣬶ÁÈ¡xmlÎļþÖÐÊý¾Ý£¬ÓÃxmllistcollection´æ´¢xmlÖÐijһ²¿·ÖÊý¾Ý£¬²¢°ó¶¨ÔÚgridview¿Ø¼þÉÏ¡£
xml£¬xmllist£¬xmllistcollectionÖÐÖ»ÓÐxmllistcollection¾ßÓÐÐ޸ĸüÐÂÊý¾ ......
´ó¼Ò¶¼ÖªµÀÔÚ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, ......