ASP.NETÎÞÏÞ¼¶Ê÷Ðβ˵¥SQL+XML+TreeView
´ÓÊý¾Ý¿â¶Á³öÉú³ÉÊ÷ÐÎXMLÎĵµ
ÔÚ°ó¶¨TreeView¿Ø¼þÉÏÉú³ÉÊ÷Ðβ˵¥
ËÓÐÕâÑùµÄÊÂÀý°¡?
ллÁË
ËÓÐʵÀý·¢µ½ÎÒÓÊÏäÉÏkaerle@126.comллÁË
ûÓÐÕâÑùµÄʵÀý
ÊÂʵÉÏ¿ÉÒÔÓÃXmlDataSource¾ÍºÜ¼òµ¥Å¶!!
Ö»ÒªÉèÖÃXmlDataSourceËù¶ÔÓ¦µÄxmlÎĵµ¾Í¿ÉÒÔÁË!!
<root>
<node id="n1">
<name>ÎҵĵçÄÔ </name>
<icon>images/tree_icon_computer.gif </icon>
<explain>ÏÔʾÁ¬½Óµ½´Ë¼ÆËã»úµÄÇý¶¯Æ÷ºÍÓ²¼þ </explain>
</node>
<node id="2" parentid="n1">
<name>Ó²ÅÌÇý¶¯Æ÷ (C:) </name>
<icon>images/tree_icon_driver.gif </icon>
</node>
<node id="3">
<name>ÍøÉÏÁÚ¾Ó </name>
<icon>images/tree_icon_net.gif </icon>
<explain>ÏÔʾµ½ÍøÕ¾£¬ÍøÂç¼ÆËã»úºÍFTPÕ¾µãµÄ¿ì½Ý·½Ê½ </explain>
</node>
<node id="4" parentid="n1">
<name>Ó²ÅÌÇý¶¯Æ÷ (D:) </name>
<icon>images/tree_icon_driver.gif </icon>
</node>
<node id="5" parentid="2">
<name>Windows </name>
</node>
</root>
/* CSS Document */
/* Tree Style*/
#tree {
width: 200px; <
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
<?xml version="1.0"?>
<root>
<status>433</status>
<msg>Õâ¸öÊǺº×Ö</msg>
<serialno>123</serialno>
</root>
ÈçºÎÓÃASP¶ÁÈ¡ statusÖµ ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......