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

ASP.NETÖÐtreeviewÓ¦Óã¨ÓÃSQL×÷Êý¾ÝÔ´£©


treeview.aspxÖдúÂëÈçÏ£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="treeview.aspx.cs" Inherits="treeview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>ÎÞ±êÌâÒ³</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TreeView ID="TreeView1" runat="server" ImageSet="Msdn" NodeIndent="10">
            <ParentNodeStyle Font-Bold="False" />
            <HoverNodeStyle BackColor="#CCCCCC" BorderColor="#888888" BorderStyle="Solid" Font-Underline="True" />
            <SelectedNodeStyle BackColor="White" BorderColor="#888888" BorderStyle="Solid" BorderWidth="1px"
                Font-Underline="False" HorizontalPadding="3px" VerticalPadding="1px" />
            <NodeStyle Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px"
                NodeSpacing="1px" VerticalPadding="2px" />
        </asp:TreeView>
   
    </div>
    </form>
</body>
</html>
 
 
treeview.aspx.csÖдúÂëÈçÏ£º
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using Sy


Ïà¹ØÎĵµ£º

SQL Server 2008ºÍ΢ÈíÊý¾Ýƽ̨¿ª·¢

Microsoft SQL Server
2008ºÍMicrosoftÊý¾Ýƽ̨Ϊ¿ª·¢ÈËÔ±ÌṩÁËÒ»¸ö×ۺϵıà³Ì¼Ü¹¹£¬ÓÃÓÚ´´½¨Õë¶ÔÒÆ¶¯É豸¡¢×ÀÃæµçÄÔ¡¢Web·þÎñÆ÷£¬ºÍÆóÒµ·þÎñÆ÷µÄ»ùÓÚÊý¾ÝµÄ½â
¾ö·½°¸¡£Õâ¸öÊý¾Ý±à³Ì»·¾³½«Êý¾Ý·ÃÎʺ͹ÜÀí¼¯³Éµ½Ò»¸öÓ¦ÓóÌÐòµÄÒµÎñÂß¼­ÖУ¬´Ó¶øÌá¸ßÁË¿ª·¢ÈËÔ±µÄÉú²úÁ¦¡£ËüÌṩÁËÒ»¸öÓÃÓÚ¶ÔÒì¹¹Êý¾ÝÔ´µÄÊý¾Ý·ÃÎʺ͹ÜÀí
µÄ ......

SQL SERVERÐÞ¸ÄÅÅÐò¹æÔò

1.sp_helpsort
SELECT SERVERPROPERTY ('Collation')
²é¿´ÄãµÄÅÅÐò¹æÔò.
²»¹ýÄãµÄÕâ¸öÓ¦¸ÃºÍ×Ö·û¼¯ÓйØ.
2.¸ü¸Ä·þÎñÆ÷ÅÅÐò¹æÔò
¸ü¸Ä SQL Server 2005 ʵÀýµÄĬÈÏÅÅÐò¹æÔòµÄ²Ù×÷¿ÉÄÜ»á±È½Ï¸´ÔÓ£¬°üÀ¨ÒÔϲ½Ö裺
È·±£¾ßÓÐÖØÐ´´½¨Óû§Êý¾Ý¿â¼°ÕâЩÊý¾Ý¿âÖеÄËùÓжÔÏóËùÐèµÄÈ«²¿ÐÅÏ¢»ò½Å±¾¡£
ʹÓù¤¾ß£¨ÀýÈç´óÈÝÁ ......

SQL ServerÖÐ charÓëvarchar  

¹Ì¶¨³¤¶È(char)Óë¿É±ä³¤¶È(varchar)×Ö·ûÊý¾ÝÀàÐÍ
char[(n)]
³¤¶ÈΪn¸ö×ֽڵĹ̶¨³¤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪn¸ö×Ö½Ú¡£charÔÚSQL-92ÖеÄͬÒå´ÊΪcharacter¡£
varchar[(n)]
³¤¶ÈΪn¸ö×ֽڵĿɱ䳤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪ ......

ASP.NET 2.0ÖÐOWCÉú³ÉÖù״ͼºÍ±ý״ͼ

1¡¢Ê×ÏÈÏÂÔØowc11£ºowc11(http://www.svnhost.cn/Download/Detail-60.shtml)
2¡¢ÒýÓÃOWC£º´ò¿ª"½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷"Ãæ°å£¬Êó±êÓÒ¼üµ¥»÷"ÒýÓÃ"£¬Ñ¡Ôñ"Ìí¼ÓÒýÓÃ"²Ëµ¥£¬ÔÚµ¯³öµÄ"Ìí¼ÓÒýÓÃ"¶Ô»°¿òÖе¥»÷"COM"¿¨Æ¬£¬ÕÒµ½"Microsoft Office Web Components 10.0(office 2003ÊÇ11.0)"£¬µ¥»÷"Ñ¡Ôñ"ºÍ"È·¶¨"°´Å¥£¬OWC¾Í±»Ìí¼Óµ½ÁËÒý ......

[Asp.Net]Êý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«(ת)

SQL·þÎñÆ÷ ODBCÁ¬½Ó·½Ê½
±ê×¼°²È«Á¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÐÅÈÎÁ¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
ÌáʾÊäÈëÓû§ÃûºÍÃÜÂ뷽ʽ
Õâ¸öÓÐÒ»µãÎÊÌ⣬Ê×ÏÈÄãÐèÒªÉèÖÃÒ»¸öPro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ