1¡¢ ´«Èëij¸öÊôÐÔµÄset·½·¨µÄÒþº¬²ÎÊýµÄÃû³ÆÊÇʲô£¿
Value
2¡¢ ÈçºÎÔÚC££ÖÐʵÏּ̳У¿
: ÀàÃû£¨Ã°ºÅ¼ÓÀàÃû£©
3¡¢ C#Ö§³Ö¶àÖؼ̳Ðô£¿
²»Ö§³Ö
4¡¢ ±»protectedÐÞÊεÄÊôÐÔ/·½·¨Ôںδ¦¿ÉÒÔ·ÃÎÊ£¿
ÀàÄÚ²¿¼°¼Ì³ÐÀàÖÐ
5¡¢ ˽ÓгÉÔ±»á±»¼Ì³Ðô£¿
»á£¬µ«ÊDz»Äܱ»·ÃÎÊ¡£ËùÒÔ¿´ÉÏÈ¥ËûÃÇËƺõÊDz»Äܱ»¼Ì³ÐµÄ£¬µ«Êµ¼ÊÉÏȷʵ±»¼Ì³ÐÁË¡£
6¡¢ ÇëÃèÊöһϷÃÎÊÐÞÊηûprotected internal.
ÔÚͬһ¸öAssemblyÖУ¬ËûµÄ·ÃÎʼ¶±ðºÍpublicÒ»Ñù£¬¶ø¿çAssembly·ÃÎÊʱ£¬ËûµÄ·ÃÎʼ¶±ðͬprotectedÒ»Ñù¡£¼´protectedµÄ·¶Î§ + internalµÄ·¶Î§¡£
7¡¢ C#Ìṩһ¸öĬÈϵÄÎÞ²ÎÊý¹¹Ô캯Êý£¬µ±ÎÒʵÏÖÁËÁíÒ»¸öÓÐÒ»¸ö²ÎÊýµÄ¹¹Ô캯Êýʱºò£¬»¹Ïë±£ÁôÕâ¸öÎÞ²ÎÊýµÄ¹¹Ô캯Êý£¬ÕâÑùÎÒÓ¦¸Ãд¼¸¸ö¹¹Ô캯Êý£¿
2¸ö£¬Ò»µ©ÄãʵÏÖÁËÒ»¸ö¹¹Ô캯Êý£¬C#¾Í²»»áÔÙÌṩĬÈϵĹ¹Ô캯ÊýÁË£¬ËùÒÔÐèÒªÊÖ¶¯ÊµÏÖÄǸöÎÞ²ÎÊý¹¹Ô캯Êý
8¡¢ C#ÖÐËùÓжÔÏó¹²Í¬µÄ»ùÀàÊÇʲô£¿
System.Object
9¡¢ ÖØÔغÍÖØдÓÐʲôÇø±ð£¿
ÖØÔØÊÇָͬÃû·½·¨£¬²»Í¬µÄ²ÎÊý£¬²»Í¬µÄʵÏÖ
¶øÖØдÔòÊǸ²¸Ç¸¸ÀàÖеķ½·¨ÊµÏÖ
10¡¢ ÔÚ·½·¨¶¨ÒåÖУ¬virtualÓÐʲôº¬Ò⣿
Virtual±ê¼Ç·½·¨ÎªÐé·½·¨£¬¿ÉÒÔÔÚ×ÓÀàÖÐÓÃnewÀ´¸²¸ÇÖØд£¬¶àÓÃÓÚʵÏÖ¶à̬
11¡¢ ¿ÉÒÔÖØд˽ÓеÄÐé·½·¨Ã´£¿
²»¿ÉÒÔ
12¡¢ Äܹ»×èֹijһ¸öÀà±»ÆäËûÀà¼Ì³Ðô£¿
¿ÉÒÔ£¬Ó÷â×°Àà
13¡¢ Äܹ»ÊµÏÖÔÊÐíij¸öÀà±»¼Ì³Ð£¬µ«²»ÔÊÐíÆäÖеÄij¸ö·½·¨±»ÖØдô£¿
¿ÉÒÔ£¬±ê¼ÇÕâ¸öÀàΪpublic£¬²¢±ê¼ÇÕâ¸ö·½·¨Îªsealed
14¡¢ ÈçºÎÇø±ðÖØÔØ·½·¨£¿
²»Í¬µÄ²ÎÊýÀàÐÍ£¬²»Í¬µÄ²ÎÊý¸öÊý£¬²»Í¬µÄ²ÎÊý˳Ðò
15¡¢ ConstºÍreadonlyÓÐʲôÇø±ð£¿
const¿ÉÒÔÓÃÓÚ¾Ö²¿³£Á¿£¬¶øreadonly£¬Êµ¼ÊÊÇÀàµÄinitonly×ֶΣ¬ÏÔÈ»²»ÄÜÊǾֲ¿µÄ¡£
16¡¢ ÈçºÎÔÚ±íÖÐËæ»úÈ¡¼Ç¼Êý100Ìõ£¿Çëд³öʾÀýSQLÓï¾ä¡££¨Êý¾Ý¿âÖ¸SQL Server£¬ÏÂͬ£©
SELECT TOP 100 * FROM table_name ORDER BY NEWID()
17¡¢ ÇëÁоٳö¼¸ÖÖÓÐЧ·ÀÖ¹SQL×¢È멶´µÄ´ëÊ©£¿
1¡¢³ÌÐòÖйýÂ˵ô¡°¡¯¡±¡°%¡±¡°[¡±¡°]¡±µÈ×Ö·û
2¡¢Ê¹Óô洢¹ý³Ì´«µÝ²ÎÊý£¬²¢ÔÚ´æ´¢¹ý³ÌÖв»Ê¹ÓÃsqlÓï¾äÞÕ½Ó²éѯÌõ¼þ¡£
18¡¢ ɾ³ý±íÖÐÖظ´µÄ¼Ç¼£¨Ö¸Ä³Á½Ìõ»ò¶àÌõ¼Ç¼µÄËùÓÐ×Ö¶ÎÖµ¾ùÏàͬ£©£¬µ«Ðè±£Áô1Ìõ¡£Çëд³öʾÀýSQLÓï¾ä¡£
select distinct * into #Tmp from tableName
drop table tableName
select * into tableName from #Tmp
drop table #Tmp
19¡¢ ÏòÓбêʶ£¨IDENTITY£©ÁÐ×ֶεıíÌí¼Ó¼Ç¼ÊÇ·ñ¿ÉÐУ¬Èç¹û¿ÉÐУ¬Ó¦ÈçºÎ²Ù×÷£¿¿ÉʹÓÃSQLÓï¾ä˵Ã÷¡£
¿ÉÒÔ£¬ÒÔÏÂÓï¾ä±íʾ½«ÏÔʽ²åÈëµÄ¿ª¹Ø´ò¿ª£¬Ð´Èë¼Ç¼£¬È»ºó¹Ø±ÕÏÔʽ²åÈë
SET IDENTITY_INSERT Game_ActivityUserTotal ON
insert Game_ActivityUserTotal(id) values(1)
SET IDENTITY_INSERT Game_ActivityUserTotal OFF
20¡¢ ¼ÙÉè±íDataTableDictTB°üº¬Ò»¸ö×Ö¶ÎMaxID(INT)£¬ÇÒ½öÓÐÒ»Ìõ¼Ç¼¡£ÈçºÎÔÚ²¢·¢²Ù×÷Çé¿öÏ£¬ÐÞ¸ÄMaxID×ֶμÓÒ»£¬²¢È¡³ö¸üкóµÄMaxIDÊýÖµ£¬Í¬Ê±ÒªÇó¶ÁÈ¡³öÀ´µÄ½á¹û²»Öظ´£¿Çëд³öʾÀýSQLÓï¾ä¡£
²Î¿¼´ð°¸1£º
DECLARE @MaxID INT
UPDATE
DataTableDictTB
SET
MaxID = MaxID + 1,
@MaxID = MaxID + 1
²Î¿¼´ð°¸2£º
DECLARE @MaxID INT
BEGIN TRAN
BEGIN
UPDATE
DataTableDictTB
SET
MaxID = MaxID + 1
SELECT @MaxID = MaxID FROM DataTableDictTB
END
21¡¢ Ò³ÃæA.aspxµÄÄÚÈÝÈçÏ£º
<script>
Window.open(¡°B.aspx id=1&CodeName=ͨѶӦÓÃÀࡱ)
Ò³ÃæB.aspxµÄÄÚÈÝÈçÏ£º
<%=System.Web.HttpContext.Current.Request.QueryString["CodeName"].ToString()%>
ΪºÎÒ³ÃæB.aspxÊä³öµÄCodeNameÄÚÈÝÊÇÂÒÂ룬ÈçºÎ½â¾ö£¿
Ò³ÃæA.aspxµÄÄÚÈÝÐÞ¸ÄÈçÏ£º
<script>
Window.open(¡°B.aspx id=1&CodeName=¡± + escap(¡®Í¨Ñ¶Ó¦ÓÃÀ࡯))
22¡¢ ½ûÓÃaspxÒ³ÃæµÄViewState»áµ¼ÖÂÄÄЩ¹¦Äܲ»¿ÉÓã¿
1¡¢ Ò³ÃæÖеÄʼþÇý¶¯Ê§Ð§
2¡¢ Óû§Ìá½»µÄÐÅÏ¢½«ÔÚÌá½»ºóµÄ²»ÔÙ±£´æÏÔʾ
3¡¢ Ò³ÃæÖеÄViewStateÐÅÏ¢²»ÔÙ´æÔÚ£¬ÕâÑù´ïµ½Ò³ÃæÊÝÉí½ø¶øÌṩҳÃæÏÔʾÐÔÄÜ
23¡¢ ʹÓÃAsp.net¿ª·¢µÄÍøÕ¾ÓÐÄļ¸ÖÖsessionState´æ´¢·½Ê½£¬·Ö±ð¸÷ÊÇʲô£¿
1¡¢ ½ø³ÌÄÚ£¨InProcess£©´æ´¢·½Ê½
2¡¢ ½ø³ÌÍ⣨SessionStateService£©´æ´¢·½Ê½
3¡¢ Êý¾Ý¿â£¨SQL Server£©´æ´¢·½Ê½
24¡¢ ʹÓÃÄÄЩ·½Ê½µÄµ¯³öÒ³Ãæ»á±»´ó²¿·ÖÒ³ÃæÀ¹½Ø¹¤¾ßËùÀ¹½Ø£¬Ïà·´ÄÄЩÓÖ²»»á±»À¹½Ø£¿
1¡¢ »á±»À¹½ØµÄ·½Ê½£ºwindow.open
2¡¢ ²»»á±»À¹½ØµÄ·½Ê½£º¡¢window.showModalDialog
25¡¢ Çë¼òÒªµÄ̸̸Äã¶ÔAjax¼¼ÊõµÄÈÏʶ¡£
XMLHttpÊÇajaxµÄ×î³£Óô«Ê䷽ʽ
26¡¢ ¶ÔÓÚ³¤Ê±¼ä×°ÔصÄASP.NETÒ³ÃæÈçºÎÔÚ¿Í»§¶Ëä¯ÀÀÆ÷ÖÐÏÔʾ½ø¶È£¨½öÄ£Ä⣬²»ÒªÇó¾«È·ÏÔʾ£©£¿
1¡¢ ¿ÉÒÔÔÚµ½´ïÄ¿µÄÒ³Ãæ֮ǰ£¬ÏÈä¯ÀÀ´øÓÐÏÔʾ½ø¶ÈÌõµÄÒ³Ã棬ÔÙÍ£¶Ù¼¸Ãëºóµ½´ïÄ¿µÄÒ³Ãæ
2¡¢ ÈçÔÚ°´Å¥Ê¼þÖмÓÈëÈçÏ´úÂ룺
Response.Write(¡°
¡±);
Response.Write(¡°_¡±);
Response.Write(¡°
¡±);
Response.Write(¡°<script>mydiv.innerText = ¡±;¡±);
Response.Write(¡°<script language=java script>;¡±);
Response.Write(¡°var dots = 0;var dotmax = 10;function ShowWait()¡±);
Response.Write(¡°{var output; output = ¡®ÕýÔÚ×°ÔØÒ³Ã桯;dots++;if(dots>=dotmax)dots=1;¡±);
Response.Write(¡°for(var x = 0;x < dots;x++){output += ¡®¡¤¡¯;}mydiv.innerText = output;}¡±);
Response.Write(¡°function StartShowWait(){mydiv.style.visibility = ¡®visible¡¯; ¡°);
Response.Write(¡°window.setInterval(¡®ShowWait()¡¯,1000);}¡±);
Response.Write(¡°function HideWait(){mydiv.style.