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)½Å±¾]->Êý¾Ý¿â[Òª²Ù×÷µÄÊý
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......