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

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]Êý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«(ת)

SQL·þÎñÆ÷ ODBCÁ¬½Ó·½Ê½
±ê×¼°²È«Á¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÐÅÈÎÁ¬½Ó
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
ÌáʾÊäÈëÓû§ÃûºÍÃÜÂ뷽ʽ
Õâ¸öÓÐÒ»µãÎÊÌ⣬Ê×ÏÈÄãÐèÒªÉèÖÃÒ»¸öPro ......

MVC֮ģÐͲ㣨¸½ÉÏasp.netµÄmvc½á¹¹£©

¡¡MVCϵͳÖеÄÄ£ÐÍ´Ó¸ÅÄîÉÏ¿ÉÒÔ·ÖΪÁ½Àà¨D¨DϵͳµÄÄÚ²¿×´Ì¬ºÍ¸Ä±äϵͳ״̬µÄ¶¯×÷¡£Ä£ÐÍÊÇÄãËùÓеÄÉÌÒµÂß¼­´úÂëÆ¬¶ÎËùÔÚ¡£±¾ÎÄΪģÐÍÌṩÁËÒµÎñʵÌå¶ÔÏó
ºÍÒµÎñ´¦Àí¶ÔÏó£ºËùÓеÄÒµÎñ´¦Àí¶ÔÏó¶¼ÊÇ´ÓProcessBaseÀàÅÉÉúµÄ×ÓÀà¡£ÒµÎñ´¦Àí¶ÔÏó·â×°Á˾ßÌåµÄ´¦ÀíÂß¼­£¬µ÷ÓÃÒµÎñÂß¼­Ä£ÐÍ£¬²¢ÇÒ°ÑÏìÓ¦Ìá½»µ½
ºÏÊʵÄÊÓͼ×é¼þÒÔ²úÉúÏì ......

asp.net 1.1 °²×°ÊÖ²á


 
ÏÈÉý¼¶ieµ½5.5°æÒÔÉÏ
1 ÏÂÔØÖÐÎİæIE6:http://download.microsoft.com/download/ie6sp1/finrel/6_sp1/W98NT42KMeXP/CN/ie6setup.exe
2 ÏÂÔØmdac°²×° Ö±½ÓÏÂÔØ2.8ÖÐÎİæ:http://download.microsoft.com/download/8/b/6/8b6198c0-fe96-4811-9d81-
d5c76dd5fea8/MDAC_TYP.EXE
3 È»ºóÏÂÔØ.NET Framework 1.1°æ¿ÉÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ