.NET SQLServer2005 XML×Ö¶Î
//ÕâÊÇÌí¼Ó
private void button1_Click(object sender, EventArgs e)
{
string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
using (SqlConnection conn = new SqlConnection(s))
{
using (SqlCommand cmd1 = new SqlCommand("INSERT testxml VALUES(@ID, @XmlData)", conn))
{
conn.Open();
cmd1.Parameters.Add("@ID", SqlDbType.Int, 4);
cmd1.Parameters[0].Value = 2;
cmd1.Parameters.Add("@XmlData", SqlDbType.Xml);
cmd1.Parameters[1].Value = GetXmlData();
cmd1.ExecuteNonQuery();
}
}
}
&nbs
Ïà¹ØÎĵµ£º
xmlÖÐÓÐÒÔÏÂ×Ö·û²»ÄܳöÏÖ£¬·ñÔò£¬xml½«²»Äܱ»ÕýÈ·½âÎö£º
&><'
Èç¹ûÔÚxmlÖгöÏÖÁË·Ç·¨×Ö·ûÄØ±ØÐ뽫Æä¹ýÂ˵ô£¡¹ýÂ˵ķ½·¨ºÜ¼òµ¥£¬Ìæ»»¾Í¿ÉÒÔÁË£º
ÀýÈçÔÚphp xml_parser_create ÖУ¬¾Í¿ÉÒÔÕâô×ö£º
$parser = xml_parser_create(); //´´½¨Ò»¸öparser±à¼Æ÷
xml_set_element_handler($parser, "startElement", " ......
VC½âÎöXML--ʹÓÃCMarkupÀà½âÎöXML
(Ò») ÏȽ²Ò»ÏÂXMLÖеÄÎïÊâ×Ö·û£¬ÊÖ¶¯ÌîдʱעÒâһϡ£
×Ö·û ×Ö·ûʵÌå
& &nb ......
DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......
»ñÈ¡sqlserverÊý¾Ý¿âÖÐËùÓп⡢±í¡¢×Ö¶ÎÃûµÄ·½·¨
2009Äê03ÔÂ12ÈÕ ÐÇÆÚËÄ ÏÂÎç 12:51
1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ± ......
flexºÍspring+hibernateÕûºÏÍê³Éºóweb.XML³öÏÖÈçÏ´íÎó
The content of element type "web-app" must match "(icon?,display-name?,description?,distributable?,context-param*,filter*,filter-mapping*,listener*,servlet*,servlet-mapping*,session-config?,mime-mapping*,welcome-file-list?,error-page*,taglib*,reso ......