dim dtNow
dtNow = date()
dim newDate
newDate = year(dtNow) & "-" & right("0" & month(dtNow),2) & "-" & right("0" & day(dtNow),2)
Õâ¸ö×Ô¶¯½«2010-4-20 ת»¯Îª 2010-04-20
http://w.sogou.com/question/99319695.html ......
ÔÚ ¼ÆËã»ú¹ÜÀí->InterNetÐÅÏ¢·þÎñ -> ĬÈÏÍøÕ¾ -> ÓÒ¼ü -> н¨ -> ÐéÄâĿ¼ £¨±ðÃû£ºÏ൱ÓÚÎļþ¼Ð£©-> Ñ¡ÔñÔ´ÎļþµÄ·¾¶£¬Ð½¨Íê³É
ÓÒ¼üµã»÷¸Õ¸Õн¨µÄÐéÄâĿ¼£º
ÐéÄâĿ¼£º¹´Ñ¡ ¶ÁÈ¡¡£Ö´ÐÐȨÏÞ£º´¿½Å±¾¡£ºóÀ´ÓÖÓöµ½ÁËÕâÑùµÄ´íÎó£º ÔÚ
Ó¦ÓóÌÐò¼¶±ðÖ®ÍâʹÓÃ×¢²áΪ allowDefinition='MachineToApplication' µÄ½ÚÊÇ´íÎóµÄ¡£ ¸ù¾ÝÍøÉϲ鵽µÄ×ÊÁÏ£¬ÔÚÕâÀïÓÐÒ»¸ö Ó¦ÓóÌÐòÃû£¬µã»÷ ´´½¨£¬ÎÊÌâ¾Í½â¾öÁË¡£
Îĵµ£ºÆôÓÃĬÈÏÄÚÈÝÎĵµ¡£ÕâÀïÖ»ÐèÒª·ÅµÚÒ»¸öÒª·ÃÎ浀 .aspx Ò³Ãæ¾Í¿ÉÒÔÁË¡£
asp.net £ºÑ¡Ôñ asp.net °æ±¾£¬ÎÒÑ¡µÄÊÇ£º2.0
ÒÔÉϵÄÉèÖÃÍêºó£¬ÓÖÅöµ½ÁËÁíÒ»¸ö´íÎó£º
Óû§ 'NT
AUTHORITY\NETWORK SERVICE' µÇ¼ʧ°Ü¡£
ÕâÀïµÄ½â¾ö·½·¨£¬²Î¿¼±ðÈ˵ģº
µÚÒ»²½£º°Ñ'NT AUTHORITY\NETWORK SERVICE' Ìí¼Óµ½Administrator×éÖÐ
ÎҵĵçÄÔ-->ÓÒ¼ü-->¹ÜÀí-->±¾µØÓû§ºÍ×é
Ñ¡Ôñ“×é”-->Ë«»÷Administrators-->µ¥»÷“Ìí¼Ó”-->µ¥»÷“¸ß¼¶”-->µ¥»÷“Á¢¼´²é
ÕÒ”-->ÔÚÏÂÃæµÄÁбíÖÐÑ¡ÔñNetwork ServiceÓû§-->Á½´Îµ¥»÷“È·¶¨”-->¼ÓÈë¡£
µÚ¶þ²½ ÔÚÆóÒµ¹ÜÀíÆ÷Ö ......
ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
......
objConnection.Open();
objConnection.Close();
......
--------------------------------------------------------------------------------
½âÊÍ:
¡¡Á¬½ÓAccessÊý¾Ý¿âÐèÒªµ¼Èë¶îÍâµÄÃüÃû¿Õ¼ä,ËùÒÔÓÐÁË×îÇ°ÃæµÄÁ½ÌõusingÃüÁî,ÕâÊDZز»¿ÉÉÙµÄ!
¡¡strConnectionÕâ¸ö±äÁ¿Àï´æ·ÅµÄÊÇÁ¬½ÓÊý¾Ý¿âËùÐèÒªµÄÁ¬½Ó×Ö·û´®,ËûÖ¸¶¨ÁËҪʹÓõÄÊý¾ÝÌṩÕߺÍҪʹÓõÄÊý¾ÝÔ´.
¡¡"Provider=Microsoft.Jet.OleDb.4.0;"ÊÇÖ¸Êý¾ÝÌṩÕß,ÕâÀïʹÓõÄÊÇMicrosoft JetÒýÇæ,Ò²¾ÍÊÇAccessÖеÄÊý¾ÝÒýÇæ,asp.net¾ÍÊÇ¿¿Õâ¸öºÍAccessµÄÊý¾Ý¿âÁ¬½ÓµÄ.
¡¡"Data Source=C:\BegASPNET\Northwind.mdb"ÊÇÖ¸Ã÷Êý¾ÝÔ´µÄλÖÃ,ËûµÄ±ê×¼ÐÎʽÊÇ"D ......
ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
......
objConnection.Open();
objConnection.Close();
......
--------------------------------------------------------------------------------
½âÊÍ:
¡¡Á¬½ÓAccessÊý¾Ý¿âÐèÒªµ¼Èë¶îÍâµÄÃüÃû¿Õ¼ä,ËùÒÔÓÐÁË×îÇ°ÃæµÄÁ½ÌõusingÃüÁî,ÕâÊDZز»¿ÉÉÙµÄ!
¡¡strConnectionÕâ¸ö±äÁ¿Àï´æ·ÅµÄÊÇÁ¬½ÓÊý¾Ý¿âËùÐèÒªµÄÁ¬½Ó×Ö·û´®,ËûÖ¸¶¨ÁËҪʹÓõÄÊý¾ÝÌṩÕߺÍҪʹÓõÄÊý¾ÝÔ´.
¡¡"Provider=Microsoft.Jet.OleDb.4.0;"ÊÇÖ¸Êý¾ÝÌṩÕß,ÕâÀïʹÓõÄÊÇMicrosoft JetÒýÇæ,Ò²¾ÍÊÇAccessÖеÄÊý¾ÝÒýÇæ,asp.net¾ÍÊÇ¿¿Õâ¸öºÍAccessµÄÊý¾Ý¿âÁ¬½ÓµÄ.
¡¡"Data Source=C:\BegASPNET\Northwind.mdb"ÊÇÖ¸Ã÷Êý¾ÝÔ´µÄλÖÃ,ËûµÄ±ê×¼ÐÎʽÊÇ"D ......
ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
......
objConnection.Open();
objConnection.Close();
......
--------------------------------------------------------------------------------
½âÊÍ:
¡¡Á¬½ÓAccessÊý¾Ý¿âÐèÒªµ¼Èë¶îÍâµÄÃüÃû¿Õ¼ä,ËùÒÔÓÐÁË×îÇ°ÃæµÄÁ½ÌõusingÃüÁî,ÕâÊDZز»¿ÉÉÙµÄ!
¡¡strConnectionÕâ¸ö±äÁ¿Àï´æ·ÅµÄÊÇÁ¬½ÓÊý¾Ý¿âËùÐèÒªµÄÁ¬½Ó×Ö·û´®,ËûÖ¸¶¨ÁËҪʹÓõÄÊý¾ÝÌṩÕߺÍҪʹÓõÄÊý¾ÝÔ´.
¡¡"Provider=Microsoft.Jet.OleDb.4.0;"ÊÇÖ¸Êý¾ÝÌṩÕß,ÕâÀïʹÓõÄÊÇMicrosoft JetÒýÇæ,Ò²¾ÍÊÇAccessÖеÄÊý¾ÝÒýÇæ,asp.net¾ÍÊÇ¿¿Õâ¸öºÍAccessµÄÊý¾Ý¿âÁ¬½ÓµÄ.
¡¡"Data Source=C:\BegASPNET\Northwind.mdb"ÊÇÖ¸Ã÷Êý¾ÝÔ´µÄλÖÃ,ËûµÄ±ê×¼ÐÎʽÊÇ"D ......
asaxÎļþ£º
¡¡¡¡<%@ Control Language="c#" AutoEventWireup="false" Codebehind="counter.ascx.cs" Inherits="JiAnWeb.counter" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
¡¡¡¡<LINK href="css.css" rel="stylesheet">
¡¡¡¡<FONT face="ËÎÌå">
¡¡¡¡<TABLE id="table_counter" cellSpacing="0" cellPadding="0" width="750" align="center" border="0"
¡¡¡¡runat="server">
¡¡¡¡<TR>
¡¡¡¡<TD style="HEIGHT: 23px" align="center" valign=middle><IMG height="1" alt="" src="pic\rightblueback.gif" width="700"></TD>
¡¡¡¡</TR>
¡¡¡¡<TR>
¡¡¡¡<TD align=center valign=middle></TD>
¡¡¡¡</TR>
¡¡¡¡</TABLE>
¡¡¡¡</FONT>
¡¡¡¡£££££££££££££££££££
¡¡¡¡.csÎļþ£º
¡¡¡¡namespace JiAnWeb
¡¡¡¡{
¡¡¡¡using System;
¡¡¡¡using System.Data;
¡¡¡¡using System.Drawing;
¡¡¡¡using System.Web;
¡¡¡¡using System.Web.UI.WebControls;
¡¡¡¡using System.Web.UI.HtmlControls;
¡¡¡¡
¡¡¡¡/// <summary>
¡¡¡¡/ ......
asaxÎļþ£º
¡¡¡¡<%@ Control Language="c#" AutoEventWireup="false" Codebehind="counter.ascx.cs" Inherits="JiAnWeb.counter" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
¡¡¡¡<LINK href="css.css" rel="stylesheet">
¡¡¡¡<FONT face="ËÎÌå">
¡¡¡¡<TABLE id="table_counter" cellSpacing="0" cellPadding="0" width="750" align="center" border="0"
¡¡¡¡runat="server">
¡¡¡¡<TR>
¡¡¡¡<TD style="HEIGHT: 23px" align="center" valign=middle><IMG height="1" alt="" src="pic\rightblueback.gif" width="700"></TD>
¡¡¡¡</TR>
¡¡¡¡<TR>
¡¡¡¡<TD align=center valign=middle></TD>
¡¡¡¡</TR>
¡¡¡¡</TABLE>
¡¡¡¡</FONT>
¡¡¡¡£££££££££££££££££££
¡¡¡¡.csÎļþ£º
¡¡¡¡namespace JiAnWeb
¡¡¡¡{
¡¡¡¡using System;
¡¡¡¡using System.Data;
¡¡¡¡using System.Drawing;
¡¡¡¡using System.Web;
¡¡¡¡using System.Web.UI.WebControls;
¡¡¡¡using System.Web.UI.HtmlControls;
¡¡¡¡
¡¡¡¡/// <summary>
¡¡¡¡/ ......
aspxÒ³´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="DataBind.aspx.cs" Inherits="DataBind" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
">
<html xmlns="http://www.w3.org/1999/xhtml
"
>
<head runat="server">
<title>ÎÞ±êÌâÒ³</title>
</head>
<body>
<form id="form1" runat="server">
<div>
µ±Ç°µÄϵͳʱ¼äÊÇ£º<%# GetSystemTime()%><br />
Óû§Ãû£º<%# UserName%><br />
²©¿ÍµØÖ·£º<%# BlogUrl%>
</div>
</form>
</body>
</html>
¶ÔÓ¦µÄ´úÂëÒþ²ØÒ³´úÂ룺
using System;
using System.Data;
using System.Configuration;
using ......
aspxÒ³´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="DataBind.aspx.cs" Inherits="DataBind" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
">
<html xmlns="http://www.w3.org/1999/xhtml
"
>
<head runat="server">
<title>ÎÞ±êÌâÒ³</title>
</head>
<body>
<form id="form1" runat="server">
<div>
µ±Ç°µÄϵͳʱ¼äÊÇ£º<%# GetSystemTime()%><br />
Óû§Ãû£º<%# UserName%><br />
²©¿ÍµØÖ·£º<%# BlogUrl%>
</div>
</form>
</body>
</html>
¶ÔÓ¦µÄ´úÂëÒþ²ØÒ³´úÂ룺
using System;
using System.Data;
using System.Configuration;
using ......
1. ÔÚASP.NETÖÐרÓÃÊôÐÔ£º
»ñÈ¡·þÎñÆ÷µçÄÔÃû£ºPage.Server.ManchineName
»ñÈ¡Óû§ÐÅÏ¢£ºPage.User
»ñÈ¡¿Í»§¶ËµçÄÔÃû£ºPage.Request.UserHostName
»ñÈ¡¿Í»§¶ËµçÄÔIP£ºPage.Request.UserHostAddress
2. ÔÚÍøÂç±à³ÌÖеÄͨÓ÷½·¨£º
»ñÈ¡µ±Ç°µçÄÔÃû£ºstatic System.Net.Dns.GetHostName()
¸ù¾ÝµçÄÔÃûÈ¡³öÈ«²¿IPµØÖ·£ºstatic System.Net.Dns.Resolve(µçÄÔÃû).AddressList
Ò²¿É¸ù¾ÝIPµØÖ·È¡³öµçÄÔÃû£ºstatic System.Net.Dns.Resolve(IPµØÖ·).HostName
3. ϵͳ»·¾³ÀàµÄͨÓÃÊôÐÔ£º
µ±Ç°µçÄÔÃû£ºstatic System.Environment.MachineName
µ±Ç°µçÄÔËùÊôÍøÓò£ºstatic System.Environment.UserDomainName
µ±Ç°µçÄÔÓû§£ºstatic System.Environment.UserName
ÎÄÕ³ö´¦£º·ÉÅµÍø(www.firnow.com):http://dev.firnow.com/course/4_webprogram/asp.net/asp_netshl/2008318/105007.html ......