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
Ïà¹ØÎĵµ£º
ÓкܾÃÒ»¶Îʱ¼äÎÒµÄBLOGÉÏûÓгöÏÖAJAXÏà¹ØÑ¶Ï¢ÁË£¬Ö÷Òªµ±È»ÊÇÒòΪ¾ø´ó²¿·ÖµÄÖØÐͼ·Åµ½ÁËSilverlightÉíÉÏ(¿ÉÔ¤ÆÚµÄδÀ´Ó¦¸ÃÒ²»áÊÇÈç´Ë)¡£
µ«ÓÉÓÚ¹¤×÷ÉϵÄÐèÒª£¬×î½ü»¹ÊÇ»ØÍ·¿´ÁËһϼ´½«ÍƳöµÄASP.NET Ajax Library...£¬Ë³±ãÕÒÁËÒ»ÏÂÍøÂçÉϵÄѶϢ£¬¿´Õâ¸öÌ¬ÊÆÎÒ²ÂÏëÓ¦¸Ã²»ÉÙASP.NET¿ª·¢ÈËÔ±ºöÂÔµôÁËÕâ¸öÆäʵÒѾbet ......
½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......
²»¹ÜʹÓÃÄÄÖÖµ×²ãÆ½Ì¨£¬¿É¿¿ÐÔºÍÐÔÄܶ¼ÊǶÔËùÓÐ Web Ó¦ÓóÌÐòµÄÖ÷ÒªÒªÇ󣬾¡¹Ü´ÓijÖÖÒâÒåÉϽ²£¬ÕâÁ½¸öÒªÇóÊÇÏ໥ì¶ÜµÄ¡£ÀýÈ磬Ҫ¹¹½¨¸ü¿É¿¿¡¢¸ü½¡×³µÄÓ¦ÓóÌÐò£¬¿ÉÄÜÐèÒª½« Web ·þÎñÆ÷Óë¾ßÌåµÄÓ¦ÓóÌÐò·ÖÀ룬ʹӦÓóÌÐòÔÚ½ø³ÌÍ⹤×÷¡£µ«ÊÇ£¬Èç¹ûÔÚ²»Í¬ÓÚ Web ·þÎñÆ÷½ø³ÌµÄÄÚ´æ»·¾³Öй¤×÷£¬Ó¦ÓóÌÐò½«±äÂý¡£Òò´Ë£¬ÐèÒª²ÉÈ¡º ......
ÐèÒªÒýÓõÄÀàÃû¿Õ¼ä
using System.Security.Cryptography;
using System.IO;
using System.text;
/// <summary>
/// ¼ÓÃÜ
// ......