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

ASP.NET×Ô¶¯Ö´ÐÐSQLµÄ·½·¨Ịֽ̀¡

ÏÖÔÚÏëÔÚÕ¾µãÔËÐÐÆÚ¼ä£¬Ã¿Ìì¹Ì¶¨Ä³¸öʱ¼ä£¬×Ô¶¯Ö´ÐÐijÌõSQLÓï¾ä£¡
¼´Ê¹½ñÌìÕâ¸öÕ¾»¹Ã»ÓÐÈË·ÃÎÊ£¬Ò²ÄÜÖ´ÐÐÕâÌõSQLÓï¾ä£¬Óа취½â¾öÂð£¿
Êý¾Ý¿âÀïµÄ¼Æ»®ÈÎÎñ¿ÉÒÔ½â¾ö

ÀûÓÃÊý¾Ý¿âÀïµÄ×÷Òµ»¹ÊǼƻ®ÈÎÎñÀ´×ŵľͿÉÒÔ½â¾ö¡£

ÎÒ¾ÍÊDz»ÏëÓÃÊý¾Ý¿âÀïµÄ×÷ÒµÀ´½â¾ö£¬ÒòΪÊÇÒª·Åµ½ÐéÄâÖ÷»úÉÏÈ¥¡£²»¿ÉÄÜÈÃÄãÈ¥ÉèÖÃ×÷Òµ¡£

»òÕßÓÃSystem.TimersÔÚGlobal.asaxд¶¨Ê±Æ÷

http://bbs.51cto.com/archiver/tid-34202.htmlSQL Server£º¶¨Ê±×÷ÒµµÄÉèÖ÷½·¨

ÏÖÔÚÏëÔÚÕ¾µãÔËÐÐÆÚ¼ä£¬Ã¿Ìì¹Ì¶¨Ä³¸öʱ¼ä£¬×Ô¶¯Ö´ÐÐijÌõSQLÓï¾ä£¡ 
¼´Ê¹½ñÌìÕâ¸öÕ¾»¹Ã»ÓÐÈË·ÃÎÊ£¬Ò²ÄÜÖ´ÐÐÕâÌõSQLÓï¾ä£¬Óа취½â¾öÂð£¿
ûÓÐÈË·ÃÎÊ£¬Ö´ÐÐҲûÓÐÒâ˼£¬Ê×Ò³½øÈëµÄʱºòÖ´ÐУ¬Ç°ÃæÃ»ÓÐÖ´ÐеIJÙ×÷¾ÍÐÐÁË


SQL Server£º¶¨Ê±×÷ÒµµÄÉèÖ÷½·¨ 
--------------------------------------------------------------------------------

Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ£¬¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£ 

1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ 

2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->·ÖÀà´¦¿ÉÑ¡ÔñÒ²¿ÉÓÃĬÈϵÄ[δ·ÖÀà(±¾µØ)]->ËùÓÐÕßĬÈÏΪµÇ¼SQL ServerÓû§[Ò²¿ÉÑ¡ÆäËüµÄµÇ¼]->ÃèÊö[Ìîд±¾´Î¹¤×÷ÏêϸÃèÊöÄÚÈÝ]£» 

´´½¨×÷Òµ·ÖÀàµÄ²½Ö裺 SQL Server´úÀí->×÷Òµ->ÓÒ¼üÑ¡ËùÓÐÈÎÎñ->Ìí¼Ó¡¢Ð޸ġ¢É¾³ý 

3¡¢Ð½¨×÷ÒµÊôÐÔ(²½Öè)->н¨->²½ÖèÃû[×Ô¶¨ÒåµÚÒ»²½ÖèÃû³Æ]->ÀàÐÍ[Transact-SQL(TSQL)½Å±¾]->Êý¾Ý¿â[Òª²Ù×÷µÄÊý


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......

winform±à³ÌÓëASP.NETÓÐÁ¬ÏµÂð - .NET¼¼Êõ / C#

ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼­Åжϵȶ¼ÐèÒªwinform»ù´¡

C#ÓïÑÔ 
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹

Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ