ËäÈ»Õâ¸ö¶«Î÷ºÜ»ù±¾£¬µ«ÊÇ×Ô¼ºÓÐʱºò»¹ÊǺܻìÂÒ£¬ËùÒÔ½ñÌì¾ÍССµÄÕûÀíÁËÏ£¬Ïȸø´ó¼Ò´øÀ´µÄÊÇÒ³ÃæµÄÌø×ªÎÊÌâ¡£
ÒÔÏÂÊÇËÄÖÖ ´ò¿ªÐÂÒ³ÃæµÄ·½·¨.
1. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
Response.Redirect("Webform6.aspx?id=1");
2. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
nServer.Transfer("Webform6.aspx?id=1",true);
3. ´ò¿ªÐÂÒ³Ãæ,ÔÒ³Ãæ±£Áô,µ«ÊÇÁ½¸öÒ³Ãæ¶¼¿ÉÒÔ²Ù×÷.
nResponse.Write("<script>window.open('Webform6.aspx?id=1','_blank','');</script>");
4. ´ò¿ªÐÂÒ³Ãæ,ÔÒ³Ãæ±£Áô,µ«Ö»ÓÐ×ÓÒ³Ãæ¿ÉÒÔ²Ù×÷.Ö»ÓйرÕÁË×ÓÒ³Ãæ,¸¸Ò³Ò³²ÅÄܲÙ×÷. ½ÓÏÂÀ´ÊÇ´øÀ´µÄ²»Í¬Ò³Ãæ¼ä´«ÖµµÄÎÊÌâ
1. Server.TransferÖ»Äܹ»×ªÌøµ½±¾µØÐéÄâĿ¼ָ¶¨µÄÒ³Ãæ£¬¶øResponse.RedirectÔò¿ÉÒÔÌøµ½ÆäËüÐéÄâĿ¼ָ¶¨µÄÒ³Ãæ,Ê®·ÖÁé »î£»
2. Server.Transfer¿ÉÒÔ½«Ò³Ãæ²ÎÊý·½±ã´«µÝµ½Ö¸¶¨Ò³Ã棻ʹÓÃÒ»¸ö״̬±ÈÈ磺
Server.Transfer(“WebForm2.aspx”, True)£¬
ÏÖ´æµÄÇëÇó×Ö·û´®ºÍËùÓеÄFormÀïµÄ±äÁ¿½«±»±£³Ö²¢Ìá½»µ½ÄãµÄÄ¿±êÒ³¡£´«µÝµÄÖµÖ»ÄÜÔÚPAGELOADº¯ÊýÀïµÚÒ»´Î½øÀ´Ê±¶Á ³ö.
Àý£ºWebForm1.aspx ÓÐÒ»¸öÎı¾¿òÃûΪ TextBox1£¬ÄãÀûÓà preserveForm Ϊ True ´«µ ......
ǰһ¶Îʱ¼ä×öÁËÄ£ÄâHttpÇëÇó£¬ÄÇôÎÒÃÇÓ¦¸ÃÔõô×ö¿ÉÒÔ×èÖ¹Óû§Ä£ÄâHttpÇëÇóÁË£¬ÔÚÕâÀïÍÆ¼öÒ»¸ö·½·¨£º¾ÍÊÇ·ÃÎÊʱ¼ä²îºÍ·ÃÎÊ´ÎÊý¡£ÎÒÃǰÑÊý¾Ý·ÃÎʵÄIP´æ·Åµ½Êý¾Ý¿â£¬ÒÔ±ãÎÒÃÇÒÔºó²é¿´¡£
Ê×ÏȽ¨Á¢Êý¾Ý±íºÍ´æ´¢¹ý³Ì
CREATE TABLE [dbo].[IPAccess](
[IP] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Times] [bigint] NULL,
[State] [bit] NULL,
[LastDataTime] [datetime] NULL,
CONSTRAINT [PK_IPAccess] PRIMARY KEY CLUSTERED
(
[IP] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE PROC GetIpState
(
@IP VARCHAR(50) ,
@TimeCount INT ,
@State BIT OUTPUT
)
AS
BEGIN
DECLARE @count BIGINT
SELECT @count = COUNT(0)
& ......
ÔÚÒ³Ãæ¼äÌø×ª,»áÉæ¼°µ½ÖµºÍÊý¾ÝµÄ´«µÝÎÊÌâ.ÌØÓñ¾ÎĽ«ÎÒÖªµÀµÄһЩ·½·¨¹éÄÉÒ»ÏÂ.
1.´ø²ÎÊý´«µÝ
Óŵã:ʹÓ÷½±ã
ȱµã:°²È«ÐÔµÍ,Êʺϴ«µÝ¼òµ¥ÀàÐ͵ĶÔÏó,±ÈÈçÊý×Ö.×Ö·û.µ«¶Ô¶ÔÏó.Êý×éµÈ²»ºÏÊÊ´«µÝ.
Ó¦ÓÃ:
a.°²È«ÐÔ²»¸ß,Ó¦¶Ô·½Ê½:¶Ô´«µÝµÄÖµ½øÐмÓÃÜ.
b.´«µÝ¼òµ¥ÀàÐ͵ĶÔÏó.Ó¦¶Ô·½Ê½:ÔÚ´«µÝҳͨ¹ý¼òµ¥ÀàÐͶÔÏó¸ø³ö±êʶ,ÔÚ±»´«µÝҳͨ¹ý±êʶ»ñÈ¡¸´ÔӵĶÔÏó.
°¸Àý:
URL¼ÓÃÜÀà
URL±àÂë½âÂëÀà
using System;
using System.Collections.Generic;
using System.Text.RegularExpressions;
using System.Text;
using System.Web;
/**//// <summary>
///Url±àÂë½âÂëÀà
/// </summary>
public class UrlEncrpt
{
static System.Text.Encoding encoding = System.Text.Encoding.UTF8;
public UrlEncrpt()
{
//
//TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
&nb ......
дÁËÒ»¸ö´´½¨ÐéÄâĿ¼µÄ WebService ³ÌÐò£¬ÔÚ²âÊÔÔËÐÐʱ¿ÉÒԳɹ¦´´½¨£¬µ«ÆäËü³ÌÐòµ÷ÓÃʱ£¬ÌáʾûÓÐȨÏÞ´´½¨¡£
²éÁËһЩ×ÊÁÏ£¬ÔÚweb.configÀïÃæµÄ<system.web>ºó¼ÓÉÏÅäÖãº
<identity impersonate="true" userName="²Ù×÷ϵͳÓû§Ãû" password="Óû§¶ÔÓ¦µÄÃÜÂë" />
ÎÊÌâ½â¾ö¡£Ìش˼Ǽ£¬È¨×÷±¸Íü¡£ ......
×î½ü×ö¸öÏîÄ¿£¬ÐèÒªµ¼³öexcel£¬ÒªÖ÷´Ó±íÒ»Æðµ¼³öµÄ£¬¾Í´óÖÂдÁËÒ»¸ö·½·¨£¬¿ÉÄܸñʽ·½Ã滹ÊÇ»á½øÐÐÐ޸ģ¬ÏÈÌù³öÀ´·½±ãÒÔºó²é¿´
ÏîÄ¿ÒýÓÃ΢ÈíexcelµÄcomµÄdll¼´¿É
/// <summary>
/// ¹¦ÄÜ£ºµ¼³öÎļþ£¨Í¨¹ýÊý¾ÝÔ´µ¼³ö,¿ÉÖ÷´Ó±íµ¼³ö£©
/// </summary>
/// <param name="strTitle">ÎļþÃû×Ö</param>
/// <param name="mainDT">Ö÷±íÊý¾ÝÔ´</param>
/// <param name="dtParams">´Ó±íÊý¾ÝÔ´¼¯ºÏ</param>
public static void Export(string strTitle, System.Data.DataTable mainDT, params System.Data.DataTable[] dtParams)
{
GC.Collect();
Application oApp = new Application();
Workbooks oBooks = oApp.Workbooks;
Workbook oBook = oBooks.Add(true);
Worksheet oSheet = (Worksheet)oBook.ActiveSheet;
int _rowIndex = 4;//ÐÐË÷Òý
int _cellIndex = 1;//ÁÐË÷Òý
int _maxCellIndex = 1;//×î´óÁÐË÷Òý
int _mainRowIndex = 4;//Ö ......
ÏîÄ¿Öо³£»áÓõ½°ÑexcelµÄÎļþÄÚÈݵ¼Èëµ½Êý¾Ý¿âÖеÄ,¸Õ¸Õ»¨Á˵ãʱ¼ä,×öÁ˸öÀý×Ó,»ù±¾ÉÏÄÜʵÏÖµ¼ÈëExcelºóÏÔʾµÄ¹¦ÄܰÉ,µ¼ÈëµÄexcelÎļþµÃÊÇxls,¼´ÊÇ2003µÄ.
´úÂë˼·ÈçÏÂ:Òª¶ÁÈ¡µÄexcelÎļþ±ØµÃµÃÊÇÔÚ±¾µØÓ²ÅÌ,ËùÒÔÒ»°ãÀ´Ëµ¶¼ÊÇÈÃÔ¶³ÌÓû§Ñ¡Ôñ×Ô¼ºÓ²ÅÌÉϵÄExcelÎļþ,È»ºó°ÑÓû§Ñ¡ÔñµÄÎļþÉÏ´«µ½±¾µØ·þÎñÆ÷ÉÏ,ÔÙÔÚ±¾µØ·þÎñÆ÷ÉϽøÐвÙ×÷.ÎҰѽçÃæºóÖôúÂëÖØÒª²¿·ÖÌù³öÀ´,´ó¼Ò×Ô¼ºÂýÂý¿´°É,¶¼ÓÐ×¢ÊÍÁË.
C#´úÂë
// ÉÏ´«°´Å¥
protected void btnUp_Click(object sender, EventArgs e)
{
bool b = Upload(fuExcel); // ÉÏ´«excelÎļþ
if (!b)
{
return;
&nb ......