sql - .NET¼¼Êõ / VB.NET
²éѯ½á¹ûÓ¦¸Ã»áÓÐÁ½Ìõ¼Ç¼£¬ÎÒϱߵĴúÂëÖ»ÄܶÁ³öµÚÒ»ÌõÊý¾Ý£¬ÎªÊ²Ã´£¿
rd.NextResultºÃÏñÎÞЧµÄ£¬ÒªÈçºÎʹÓã¿
VB.NET code:
Dim rd As SqlClient.SqlDataReader = cmd.ExecuteReader()
Dim p As String
p = "--------------------------------------------------------------" & (Chr(13)) & (Chr(10))
Do
rd.Read()
p = p + rd.GetValue(0).ToString & (Chr(13)) & (Chr(10))
Loop While rd.NextResult
While (rd.Read())
rd.Read()
p = p + rd.GetValue(0).ToString & (Chr(13)) & (Chr(10))
rd.NextResult()
End While
NextResult·½·¨ÒªÈçºÎʹÓã¿Ôõô²»»áÒÆ¶¯µ½ÏÂÒ»Ìõ¼Ç¼
Read()·½·¨£ºÊ¹ SqlDataReader ǰ½øµ½ÏÂÒ»Ìõ¼Ç¼¡£
NextResult()·½·¨£ºµ±¶ÁÈ¡Åú´¦Àí Transact-SQL Óï¾äµÄ½á¹ûʱ£¬Ê¹Êý¾Ý¶ÁÈ¡Æ÷ǰ½øµ½ÏÂÒ»¸ö½á¹û¡£
ËùÒÔÄãÕâÑù¸Ä
VB.NET code:
Dim rd As SqlClient.SqlDataReader = cmd.ExecuteReader()
Dim p As String
p = "--------------------------------------------------------------" & (Chr(13)) & (Chr(10))
rd.Read()
Do
Ïà¹ØÎÊ´ð£º
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÏÖÔÚÎÒÏë¸ù¾ÝtreeviewÉÏÿ¸ö½ÚµãµÄȨÏÞ£¬Ã»ÓÐȨÏ޵Ľڵ㲻Äܱ»Ñ¡ÖУ¬¶øÇҳɻÒÉ«£¬ÔõôʵÏÖ£¬ÔÚÏߵȡ£¡£¡£
Õâ¸ö£¿¡£¡£¡£
Ã²ËÆÃ»·¨¡£
ÊÔÊÔÄܲ»ÄܸÄijЩnodeµÄÑÕÉ«£¬¼Ç¼ÏÂÉϴεÄnodeclickÀïµÄnode¡£
Ï´εã»÷µÄÈç¹ ......
xmlDoc1.loadXML(h)×ÜÊÇ·µ»Øfalse£¬ÎªÊ²Ã´£¿Ð»Ð»°ïæ»Ø´ðÒ»ÏÂ
hÊÇÊ²Ã´ÄØ¡£¡£¡£¡£¡£¡£¡£¡£¡£
hÊÇxml¸ñʽµÄ×Ö·û´®
ÄãÊÇÏë´ò¿ª¡£XML¸ñʽµÄÎļþ°É£¿
ÎÒÊǰÑh·ÅÔÚxmlDoc1ÀÓÃxmlDoc1.loadXML(h)£¬È»ºóÈ¡xmlDo ......
dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®
¿´¿´i ......