.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£¨eXtensible Markup Language£©£¬ÊÇÓÉW3C×éÖ¯Öƶ¨µÄ¡£×öΪÓÃÓÚÌæ´úHTMLÓïÑÔµÄÒ»ÖÖÐÂÐ͵ıê¼ÇÓïÑÔ£¬XMLÄÚ²¿ÓÐןܶà»ù±¾±ê×¼£¬XML¾ÍÊÇͨ¹ýÓëÕâЩÏà¹Ø±ê×¼µØ½áºÏ£¬Ó¦ÓÃÓÚ¿Æѧ¼ÆËã¡¢µç×Ó³ö°æ¡¢¶àýÌåÖÆ×÷ºÍµç×ÓÉÌÎñµÄ¡£C££×÷ΪһÖÖÐÂÐ͵ijÌÐòÓïÑÔ£¬ÊÇ.Net¿ò¼ÜµÄÒ»¸öÖØÒª×é³É²¿·Ö£¬ËûºÍXMLµÄ¹ØϵÆÄÉî¡£±¾ÎÄ¾Í´Ó ......
ºÍ & & amp;
µ¥
ÒýºÅ ' & apos;
Ë«Òý
ºÅ "   ......
ÏÈ´´½¨Êý¾ÝÈ»ºóÉú³ÉÏàÓ¦µÄxmlÎļþ
DataSet ds = new DataSet();
#region Parent Table
DataTable dt1 = new DataTable("Parent");
......
select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a
ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......
<
<
СÓÚ
>
>
´óÓÚ
&
&
ºÍºÅ
'
'
µ¥ÒýºÅ
"
"
ÒýºÅ
×¢ÊÍ£ºÔÚ XML ÖУ¬Ö»ÓÐ×Ö·û "<" ºÍ "&" ȷʵÊÇ·Ç·¨µÄ¡£´óÓÚºÅÊǺϷ¨µÄ£¬µ«ÊÇÓÃʵÌåÒýÓÃÀ´´úÌæËüÊÇÒ»¸öºÃÏ°¹ß¡£ ......