Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

java²Ù×÷xml£¨sax£¬dom£¬jdom£¬dom4j£©Ôöɾ¸Ä²é

×î½üÔÚ¹¤×÷ÖУ¬¾­³£Éè¼Æ±¨±í£¨ireport+jasperReport£©·´¸´ºÍÉè¼ÆÄ£°åxml´ò½»µÀ£¬ÓÚÊǾÍÓÐÁËдÕâÆªÎÄÕµÄÏë·¨ÁË¡£java²Ù×÷xmlÖ÷ÒªÊÇÓÐËÄÖÖ·½Ê½£ºdom£¬sax£¬jdom£¬dom4j¡£ÕâËÄÖÖ·½Ê½¸÷ÓÐÓÅȱµã£º£¨ÒÔϱȽÏÊÇÀ´×ÔÍøÂ磩
1£ºDOM4JÐÔÄÜ×îºÃ£¬Á¬SunµÄJAXMÒ²ÔÚÓÃDOM4J.ĿǰÐí¶à¿ªÔ´ÏîÄ¿ÖдóÁ¿²ÉÓÃDOM4J£¬ÀýÈç´óÃû¶¦¶¦µÄHibernate ......

XML µÄ×ªÒÆ×Ö·û


ºÍ           &      & amp;  
µ¥
ÒýºÅ     '      & apos;  
Ë«Òý
ºÅ     "   ......

ÔÚform ´°Ìå ÀûÓÃxmlºÍxslÀ´ÊµÏÖ±íµÄǶÌ×

ÏÈ´´½¨Êý¾ÝÈ»ºóÉú³ÉÏàÓ¦µÄxmlÎļþ
 DataSet ds = new DataSet();
            #region Parent Table
            DataTable dt1 = new DataTable("Parent");
     ......

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

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

SqlServer ʵÏÖÈÕÆÚ²»Í¬¸ñʽµÄת»»£¡£¡

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

ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ