asp.netc#AccessͨÓÃÊý¾Ý·ÃÎÊÀà
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// DataAccess µÄժҪ˵Ã÷
/// </summary>
public class DataAccess
{
protected static OleDbConnection conn = new OleDbConnection();
protected static OleDbCommand comm = new OleDbCommand();
public DataAccess()
{
//init
}
private static void openConnection()
{
if (conn.State == ConnectionState.Closed)
{
conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source="+System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["myconn"]);//web.configÎļþÀïÉ趨¡£
comm.Connection = conn;
try
{
conn.Open();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
}//´ò¿ªÊý¾Ý¿â
&nbs
Ïà¹ØÎĵµ£º
±¾ÎĽéÉÜASP.NET Web GardenÄ£ÐÍ£¬Web GardenÄ£ÐÍ¿ÉÒÔͨ¹ý machine.config ÎļþÖÐµÄ ²¿·Ö½øÐÐÅäÖá£
Web GardenÄ£ÐÍ
Web GardenÄ£ÐÍ¿ÉÒÔͨ¹ý machine.config ÎļþÖÐµÄ <processModel> ²¿·Ö½øÐÐÅäÖá£Çë×¢Ò⣬<processModel> ²¿·ÖÊÇΨһ²»ÄÜ·ÅÔÚÓ¦ÓóÌÐòÌØ¶¨µÄ web.config ÎļþÖеÄÅäÖò¿·Ö¡£Õâ¾ÍÊÇ˵£¬Web ......
ÎÊ£ºÎªÊ²Ã´SessionÔÚÓÐЩ»úÆ÷ÉÏż¶û»á¶ªÊ§£¿
´ð£º¿ÉÄܺͻúÆ÷µÄ»·¾³ÓйØÏµ£¬±ÈÈ磺·À»ðǽ»òÕßɱ¶¾Èí¼þµÈ£¬³¢ÊԹرշÀ»ðǽ¡£
ÎÊ£ºÎªÊ²Ã´µ±µ÷ÓÃSession.Abandonʱ²¢Ã»Óм¤·¢Session_End·½·¨£¿
´ð£ºÊ×ÏÈSession_End·½·¨Ö»Ö§³ÖInProc£¨½ø³ÌÄڵģ©ÀàÐ͵ÄSession¡£Æä´ÎÒª¼¤·¢Session_End·½·¨£¬±ØÐë´æÔÚSession£¨¼´ÏµÍ³ÖÐÒÑ¾Ê¹Ó ......
1.Êý¾ÝÁ¬½Ó·½Ê½
ASP.NET±¾ÉíµÄÊý¾Ý·ÃÎÊADO.NET²»Ö§³Ö¶ÔÓÚMySqlµÄÁ¬½ÓºÍ²éѯ£¬µ«ÊÇMySQL¹ÙÍøÉϾùÌṩÁ˶àÖÖASP.NETÁ¬½Óµ½MySQLµÄ·½Ê½£º
£¨1£©ODBCÇý¶¯µÄ·ÃÎÊ·½Ê½£ºmysql-connector-odbc-5.1.5-win32.msi£¬ODBC
£¨2£©ADO.NET¶ÔÓÚMySQLµÄ·ÃÎÊ·½Ê½£ºmysql-connector-net-6.2.2.zip
¸öÈËÑ¡ÓõÄÊǵڶþÖÖ£¬¸Ð¾õ·½±ã£¬ºÍ.NET¶ÔS ......
ÐèÒªÒýÓõÄÀàÃû¿Õ¼ä
using System.Security.Cryptography;
using System.IO;
using System.text;
/// <summary>
/// ¼ÓÃÜ
// ......
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('¼ÓÈëÔÝ´æ¼Ü³É¹¦£¡');</script>");
asp.net¼òµ¥¼ÓÃÜ
//using System.Web.Security;
System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfig ......