Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

.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


Ïà¹ØÎĵµ£º

grails½âÎöxmlÎļþ

xmlÎļþ£º
<?xml version="1.0" encoding="iso-8859-1"?>
<Products>
    <product>
        <name>lovechoosesun</name>
        <buyNowURL>http://merch.danecook ......

½«XMLÊý¾ÝÌî³äµ½TreeViewÖÐ

Îĵµ¼°´úÂëÏÂÔØ£ºhttp://www.dingos.cn/index.php?topic=1899.0
½éÉÜ

µ±²Ëµ¥ÏîÊǾ­³£¸Ä±äʱ£¬´ÓXMLÎĵµÖд´½¨TreeView²Åµ±ÊǷdz£ÓÐÓõġ£ÀýÈ磬ʹÓÃXML×÷ΪÊý¾Ý¿â´æ´¢¼Ç¼¡£
ÕâÀïÓиö¼òµ¥Ê¾Àý¡£ÒÔ·À»ìÏýÕâ¸öÀý×ӱȽϼòµ¥¡£
±³¾°
¶ÔXML¡¢TreeView¿Ø¼þµÄÓ¦Óã¬ÔÚVisual StudioÖÐÓÐÖúÓÚÀí½âÕâЩ²½Öè¡£
ʹÓôúÂë
×¢Òâ ......

[SQL Server]SQLServer ÅúÁ¿²åÈëÊý¾ÝµÄÁ½ÖÖ·½·¨

ÔÚSQL Server ÖвåÈëÒ»ÌõÊý¾ÝʹÓÃInsertÓï¾ä£¬µ«ÊÇÈç¹ûÏëÒªÅúÁ¿²åÈëÒ»¶ÑÊý¾ÝµÄ»°£¬Ñ­»·Ê¹ÓÃInsert²»½öЧÂʵͣ¬¶øÇһᵼÖÂSQLһϵͳÐÔÄÜÎÊÌâ¡£ÏÂÃæ½éÉÜSQL ServerÖ§³ÖµÄÁ½ÖÖÅúÁ¿Êý¾Ý²åÈë·½·¨£ºBulkºÍ±íÖµ²ÎÊý(Table-Valued Parameters)¡£
   ÔËÐÐÏÂÃæµÄ½Å±¾£¬½¨Á¢²âÊÔÊý¾Ý¿âºÍ±íÖµ²ÎÊý¡£
´úÂëÈçÏÂ:
--Create D ......

»ñÈ¡sqlserverÊý¾Ý¿âÖÐËùÓп⡢±í¡¢×Ö¶ÎÃûµÄ·½·¨

»ñÈ¡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':±íʾËùÓÐϵͳ± ......

»ù´¡£ºxml£¬xsdºÍÊý¾Ý¿â

1. »ù´¡£º¶ÔXML½øÐмòµ¥µÄ²éѯ, ²åÈë, ɾ³ý, ±à¼­²Ù×÷
ÔÚÊý¾ÝÁ¿²»ÊǺܴóµÄÇé¿öÏ£¬¿ÉÒÔÓÃxml´úÌæÊý¾Ý¿â´æ´¢Êý¾Ý£¬µ«ÊÇÒª¶¨ÒåxsdÎļþÀ´ÑéÖ¤xmlÎļþ£¬±£Ö¤xmlÊý¾Ý¸ñʽ¡£
ÒÔÏÂÍøÒ³½éÉÜÁËÈçºÎÀûÓÃC#ʵÏÖxmlµÄ²éѯ£¬²åÈ룬ɾ³ýºÍ¸üвÙ×÷£¬Õâ±íÃ÷xml¿ÉÒÔ´úÌæÊý¾Ý¿â´æ´¢Ò»¶¨Á¿µÄÊý¾Ý¡£
http://blog.csdn.net/cmoonc/archive/20 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ