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
Ïà¹ØÎĵµ£º
ÒÑÖªÓÐÒ»¸öXMLÎļþ£¨bookstore.xml£©ÈçÏ£º
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price> ......
±¾ÎĽéÉÜASP.NET Web GardenÄ£ÐÍ£¬Web GardenÄ£ÐÍ¿ÉÒÔͨ¹ý machine.config ÎļþÖÐµÄ ²¿·Ö½øÐÐÅäÖá£
Web GardenÄ£ÐÍ
Web GardenÄ£ÐÍ¿ÉÒÔͨ¹ý machine.config ÎļþÖÐµÄ <processModel> ²¿·Ö½øÐÐÅäÖá£Çë×¢Ò⣬<processModel> ²¿·ÖÊÇΨһ²»ÄÜ·ÅÔÚÓ¦ÓóÌÐòÌØ¶¨µÄ web.config ÎļþÖеÄÅäÖò¿·Ö¡£Õâ¾ÍÊÇ˵£¬Web ......
²»¹ÜʹÓÃÄÄÖÖµ×²ãÆ½Ì¨£¬¿É¿¿ÐÔºÍÐÔÄܶ¼ÊǶÔËùÓÐ Web Ó¦ÓóÌÐòµÄÖ÷ÒªÒªÇ󣬾¡¹Ü´ÓijÖÖÒâÒåÉϽ²£¬ÕâÁ½¸öÒªÇóÊÇÏ໥ì¶ÜµÄ¡£ÀýÈ磬Ҫ¹¹½¨¸ü¿É¿¿¡¢¸ü½¡×³µÄÓ¦ÓóÌÐò£¬¿ÉÄÜÐèÒª½« Web ·þÎñÆ÷Óë¾ßÌåµÄÓ¦ÓóÌÐò·ÖÀ룬ʹӦÓóÌÐòÔÚ½ø³ÌÍ⹤×÷¡£µ«ÊÇ£¬Èç¹ûÔÚ²»Í¬ÓÚ Web ·þÎñÆ÷½ø³ÌµÄÄÚ´æ»·¾³Öй¤×÷£¬Ó¦ÓóÌÐò½«±äÂý¡£Òò´Ë£¬ÐèÒª²ÉÈ¡º ......
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 ......