»ñÈ¡ÕæÊµIPºÍ´úÀíIP (asp.net C#)
³ÌÐò´úÂë
public static string GetRealIP()
{
string ip;
try
{
HttpRequest request = HttpContext.Current.Request;
if (request.ServerVariables["HTTP_VIA"] != null)
{
ip = request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString().Split(',')[0].Trim();
}
else
{
ip = request.UserHostAddress;
}
}
catch (Exception e)
{
throw e;
}
return ip;
}
»ñÈ¡´úÀíIP
³ÌÐò´úÂë
public static string GetViaIP()
{
string viaIp = null;
try
{
HttpRequest request = HttpContext.Current.Request;
if (request.ServerVariables["HTTP_VIA"] != null)
{
viaIp = request.UserHostAddress;
}
}
catch (Exception e)
{
throw e;
}
return viaIp;
}
Ïà¹ØÎĵµ£º
ÔÚweb configÖÐ ×÷ÈçÏÂÅäÖãº
<connectionStrings>
<add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó ......
¸ßЧʹÓÃʹÓÃSQL»º´æÒÀÀµ
ASP.NET FrameworkÐÂÔöµÄÒ»¸ö·Ç³£Ç¿´óµÄ¹¦ÄÜÊÇSQL»º´æÒÀÀµ¡£¸Ã¹¦ÄÜÔÊÐíµ×²ãÊý¾Ý¿âÖеÄÊý¾ÝÐÞ¸Äʱ£¬×Ô¶¯µØÖØÐÂÔØÈ뻺´æµÄÊý¾Ý¡£
ÔÚʹÓþø¶Ô»º´æ¹ýÆÚ²ßÂÔ»òÕßµ¯ÐÔ»º´æ¹ýÆÚ²ßÂÔʱÓÐÒ»¸öȨºâ£¬¶ÔÓÚÐÔÄܺͳ¾ÉÊý¾ÝµÄȨºâ¡£ÀýÈ磬Èç¹ûÔÚÄÚ´æÖлº´æÊý¾Ý20Ã룬ÔòÕâ20ÃëÄÚÏÔʾµÄÊý¾Ý¿ÉÄÜÊǹ ......
ʹÓÃDataRelationÀà´´½¨¹ØÏµ²¢ÀûÓø¸/×Ó¹ØÏµ¶ÁÈ¡Êý¾ÝʾÀý
void Page_Load(object sender, System.EventArgs e)
{
// Á¬½Ó×Ö·û´®ºÍ SQL Óï¾ä
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
......
Àý×Ó£º
using system.web.caching
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
void Page_Load(Object Src, EventArgs E) {
DataView Source;
// Retrieve the DataView obj ......
1. Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕÊ ......