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
Ïà¹ØÎĵµ£º
1.asp.netºô½Ðjs
Response.Write("<script language=javascript>");
&n ......
ÒÑÖªÓÐÒ»¸ö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Ó¦ÓõÄÒ»ÖÖȫз½Ê½¡£±¾ÊéµÚl¡¢2Õ½éÉÜÁËASP.NETµÄһЩ»ù±¾¸ÅÄîºÍ»ù±¾Óï·¨¡£ÆäÓàÕ½ÚÖ÷ÒªÊǶԸ÷ÖÖʾÀý½øÐÐÏêϸ·ÖÎö¡£½éÉÜÁ˸÷ÖÖASP.NETµÄ½â¾ö·½°¸£¬°üÀ¨´´½¨»¥¶¯Ê½ÄÚÁªÍøÓ¦ÓóÌÐò¡¢´´½¨ÌåÓýÕ¾µã¡¢´´½¨ÈËÁ¦×ÊÔ´Ó¦Óᢴ´½¨ÔÚÏßÅÄÂôÕ¾µãµÈ¡£Í¨¹ýÕâЩʵÓõĽâ¾ö·½°¸µÄѧϰ£¬¶ÁÕß¼ÈÄܵõ½ºÜ¶àʵÓõĴúÂë£¬Ó ......
²»¹ÜʹÓÃÄÄÖÖµ×²ãÆ½Ì¨£¬¿É¿¿ÐÔºÍÐÔÄܶ¼ÊǶÔËùÓÐ Web Ó¦ÓóÌÐòµÄÖ÷ÒªÒªÇ󣬾¡¹Ü´ÓijÖÖÒâÒåÉϽ²£¬ÕâÁ½¸öÒªÇóÊÇÏ໥ì¶ÜµÄ¡£ÀýÈ磬Ҫ¹¹½¨¸ü¿É¿¿¡¢¸ü½¡×³µÄÓ¦ÓóÌÐò£¬¿ÉÄÜÐèÒª½« Web ·þÎñÆ÷Óë¾ßÌåµÄÓ¦ÓóÌÐò·ÖÀ룬ʹӦÓóÌÐòÔÚ½ø³ÌÍ⹤×÷¡£µ«ÊÇ£¬Èç¹ûÔÚ²»Í¬ÓÚ Web ·þÎñÆ÷½ø³ÌµÄÄÚ´æ»·¾³Öй¤×÷£¬Ó¦ÓóÌÐò½«±äÂý¡£Òò´Ë£¬ÐèÒª²ÉÈ¡º ......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
S ......