ASP.netÒ³ÃæÌø×ª·½Ê½±È½Ï
1 response.redirect Õâ¸öÌø×ªÒ³ÃæµÄ·½·¨Ìø×ªµÄËٶȲ»¿ì£¬ÒòΪËüÒª×ß2¸öÀ´»Ø£¨2´Îpostback£©£¬µ«Ëû¿ÉÒÔÌø×ªµ½ÈκÎÒ³Ãæ£¬Ã»ÓÐÕ¾µãÒ³ÃæÏÞÖÆ£¨¼´¿ÉÒÔÓÉÑÅ»¢Ìøµ½ÐÂÀË£©£¬Í¬Ê±²»ÄÜÌø¹ýµÇ¼±£»¤¡£µ«ËÙ¶ÈÂýÊÇÆä×î´óȱÏÝ£¡redirectÌø×ª»úÖÆ£ºÊ×ÏÈÊÇ·¢ËÍÒ»¸ö httpÇëÇ󵽿ͻ§¶Ë£¬Í¨ÖªÐèÒªÌø×ªµ½ÐÂÒ³Ãæ£¬È»ºó¿Í»§¶ËÔÚ·¢ËÍÌø×ªÇëÇóµ½·þÎñÆ÷¶Ë¡£ÐèҪעÒâµÄÊÇÌø×ªºóÄÚ²¿¿Õ¼ä±£´æµÄËùÓÐÊý¾ÝÐÅÏ¢½«»á¶ªÊ§£¬ËùÒÔÐèÒªÓõ½session¡£
2 server.transfer Ëٶȿ죬ֻÐèÒªÒ»´Îpostback ,µ«ÊÇ¡£¡£¡£¡£Ëû±ØÐëÊÇÔÚͬһ¸öÕ¾µãÏ£¬ÒòΪËüÊÇserverµÄÒ»¸ö·½·¨¡£ÁíÍ⣬ËûÄÜÌø¹ýµÇ¼±£»¤¡£Äã¿ÉÒÔд¸öС³ÌÐòÊÔÊÔ£ºÉè¼ÆÒ»¸öÓÉÒ³ÃæÒ»µ½Ò³Ãæ¶þµÄÌø×ª£¬µ«Òª½øÈëµ½Ò³Ãæ¶þÐèÒªµÇ¼£¬formÈÏÖ¤£¬µ«Èç¹ûÌø×ªÓï¾äʹÓÃtransferµÄ»°£¬ÄǾͲ»»áµ¯³öµÇÂ¼Ò³ÃæÁË¡£Õâ¸ö·½·¨µÄÖØ¶¨ÏòÇëÇóÊÇ·¢ÉúÔÚ·þÎñÆ÷¶Ë£¬ËùÒÔä¯ÀÀÆ÷µÄurlµØÖ·ÈÔÈ»±£ÁôµÄÊÇÔÒ³ÃæµÄµØÖ·£¡
3 sever.execute Õâ¸ö·½·¨Ö÷ÒªÊÇÓÃÔÚÒ³ÃæÉè¼ÆÉÏÃæ£¬¶øÇÒËû±ØÐëÊÇÌø×ªÍ¬Ò»Õ¾µãϵÄÒ³Ãæ¡£Õâ¸ö·½·¨ÊÇÐèÒª½«Ò»¸öÒ³ÃæµÄÊä³ö½á¹û²åÈëµ½ÁíÒ»¸öaspxÒ³ÃæµÄʱºòʹÓ㬴󲿷ÖÊÇÔÚ±í¸ñÖУ¬½«Ä³Ò»¸öÒ³ÃæÀàËÆÓÚǶÌ׵ķ½Ê½´æÔÚÓÚÁíÒ»Ò³Ãæ¡£
×ܽ᣺
µ±ÐèÒª°ÑÓû§Ìø×ªµ½Áíһ̨·þÎñÆ÷ÉϵÄÒ³ÃæµÄʱºò ʹÓÃredirect
µ±ÐèÒª°ÑÓû§Ìø×ªµ½·ÇaspxÒ³ÃæÊ±ºò£¬Èçhtml ʹÓÃredirect
ÐèÒª°Ñ²éѯ×Ö·û´®×÷ΪurlÒ»²¿·ÖµÄʱºò±£Áô´«¸ø·þÎñÆ÷µÄʱºò£¬ÒòΪÆäËû2ÖÖ·½·¨²»ÄÜ×öµ½2´Îpostback£¬°ÑÊý¾ÝÏÈ´ø»Ø·þÎñÆ÷ ʹÓÃredirect
ÐèÒªaspxÒ³Ãæ¼äµÄת»»£¨²»Éæ¼°µÇ¼£© ʹÓÃtransfer
µ±ÐèÒª°ÑaspxÒ³ÃæµÄÊä³ö½á¹û²åÈëµ½ÁíÒ»¸öaspxÒ³ÃæµÄʱºòʹÓà execute·½·¨¡£
µ±È»£¬Íü¼ÇÁË»¹ÓÐÒ»¸ö³¬Á´½Ó£¡µ±È»Õâ¸ö¾Í²»ÐèÒª½²Ì«¶àÁË¡£ËûÊÇÔÚµ³ÐèÒªÓû§À´¾ö¶¨Ê²Ã´Ê±ºòÌø×ªÒ³Ãæ£¬¾ÍʹÓó¬Á´½Ó¡£
˳±ãÌáһϣ¬ÈçºÎʹÓÃredirect·½·¨ÔÚ²éѯ×Ö·û´®ÖÐʹÓúº×Ö£¬ÒòΪ¾³£µÄÇé¿öÊdzöÏÖÂÒÂ룬ÔÒòÊÇurl²»Ö§³Öºº×Ö¡£Õâ¸öʱºòÐèҪת»»£º
string message =server.urlencode("»¶ÓÀ´µ½ÈüÅÜרÀ¸");
ÏÈת»»£¬ÔÚʹÓòéѯ×Ö·û´®
response.redirect("webform2.aspx?msg="+message);
asp.netʵÏÖ´ÓÒ»¸öÒ³ÃæÌø×ªµ½ÁíÒ»Ò³Ãæ·½·¨µÄ±È½Ï
ʵÏÖÒ³ÃæÌø×ªµÄ·½·¨ºÜ¶à£¬³ýÁË·þÎñÆ÷¿Ø¼þÊÇasp.net·â×°¹ýÍ⣬ÆäËüÔÚaspÖÐÒ²¾ÍÓÐÁË¡£
Õâô¶àʵÏÖ·½·¨ÖУ¬¶¼ÊÇʵÏÖͬÑùµÄ¹¦ÄÜ£¬ÎªÊ²Ã´»¹ÒªÖ§³ÖÈç´Ë¶àµÄ·½·¨ÄØ£¬ÎÒÃÇʵ¼ÊÓ¦ÓÃ
Öе½µ×Ó¦¸ÃÑ¡ÔñÄÄÒ»ÖÖ·½·¨ÄØ£¿Ò²ÐíÎÒÃÇ´ó¶àÊýÈ˶¼ÊÇÐèÒªÓÃÌø×ªÊ±£¬Ëæ±ãÏëµ½Ò»¸ö±ãÄÃÀ´Óã¬
´Ó²»È¥¿¼ÂÇËüÃ
Ïà¹ØÎĵµ£º
×î½üÔÚasp.net Óõ½µÄsqlserver´æ´¢¹ý³Ì·ÖÒ³ÖÐÏÔʾÊý¾ÝʱÓöµ½¹ØÓÚÅÅÐòÎÊÌâ¡£
ÍøÉϵÄһЩ·ÖÒ³´æ´¢¹ý³ÌÖ»Ö§³ÖÅÅÐòÁÐΪint ÀàÐÍ£¬¶ÔÓÚʵ¼Ê¿ª·¢Öкܶàʱºò¶¼ÐèÒª¶ÔDateTimeÀàÐÍ£¬varcharÀàÐͽøÐÐÅÅÐò¡£
ÏÂÃæ·ÖÏíһϿÉÒÔÖ§³ÖÈÎÒâÊý¾ÝÀàÐ͵ÄÁнøÐÐÅÅÐòµÄ´æ´¢¹ý³Ì¡£
Create PROCEDURE sp_viewByPage
@TblName var ......
using System;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Timers;
using System.Data;
using System.Data.SqlClient;
namespace SMS_joke
{
/// <summary>
/// Global µÄժҪ˵Ã÷¡£
/// </summary>
public class ......
Õû¸öSQLºÍAsp.net(vb.net)Ò»Æð´ò°üµÄÈ«¹ý³ÌдһÏ¡£
Ò».×¼±¸±ØÒªµÄÎļþ
1. SQL½Å±¾Îļþ£¬Éú³ÉÒÔºó°²×°¹ý³ÌÖÐÐèÒªµÄ±íºÍ´æ´¢¹ý³ÌµÈµÈ£»
Éú³ÉÖ®ºó£¬¾ÍÔÝʱ°ÑËüÃüÃûΪdb.sql(×¢Òâ´óСд)
2.LisenceFile.rtfµÄ°²×°Îļþ£¬ÒòΪÎÒµÄϵͳÊǸöÈ˵쬶øÇÒfreeµÄ£¬ËùÒÔ¾ÍûÓÐ×ö¡£Õâ¸öÒÔºóÒ²ÊÇÒªÓõ½µÄ¡£
¶þ.ÔÚ×Ô¼ºÏÖÓеÄÏîÄ¿Àïà ......
PRB£ºÔÚʹÓà Response.End¡¢Response.Redirect »ò Server.Transfer ʱ³öÏÖ ThreadAbortException
Ö¢×´
Èç¹ûʹÓà Response.End¡¢Response.Redirect »ò Server.Transfer ·½·¨£¬½«³öÏÖ ThreadAbortException Òì³£¡£Äú¿ÉÒÔʹÓà try-catch Óï¾ä²¶»ñ´ËÒì³£¡£
ÔÒò
Response.End ·½·¨ÖÕÖ¹Ò³µÄÖ´ÐУ¬²¢½«´ËÖ´ÐÐÇл»µ½Ó¦ÓóÌÐò ......
×ܽáasp.net¿ª·¢³£Óõķ½·¨Ò»
using System;
using System.Globalization;
using System.Text;
using System.Text.RegularExpressions;
using System.Collections;
using System.IO;
namespace MoneyWise
{
/// <summary>
/// utils µÄժҪ˵Ã÷¡£
/// </summary>
public class utils
{
pr ......