Data Access Application Block
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 Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
Database db = DatabaseFactory.CreateDatabase("NorthWind");
// Database db = DatabaseFactory.CreateDatabase();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.GridView1.DataSource = GetDateSet("select top 10 * from dbo.Products").Tables[0];
this.GridView1.DataBind();
}
}
/// <summary>
/// Ö´Ðе¥ÌõSQL Óï¾ä
/// </summary>
/// <param name="sql">sql</param>
/// <returns>DataSet</returns>
private DataSet GetDateSet(string sql)
{
DataSet ds = db.ExecuteDataSet(CommandType.Text,sql);
return ds;
}
/// <summary>
/// Ö´Ðе¥ÌõSQL Óï¾ä——Ö»¶ÁÊý¾Ý
/// </summary>
/// <param name="sql">sql</param>
/// <returns>IDataReader</returns>
private IDataReader GetDataReader(string sql)
{
IDataReader idatareader = db.ExecuteReader(CommandType.Text,sql);
return idatareader;
}
/// <summary>
/// Ö´Ðе¥ÌõSQL Óï¾ä——»ñµÃÒ»ÁÐÊý¾Ý
/// </summary>
/// <param name="sql">sql</param>
/// <returns>int</returns>
private int GetSingleValue(string sql)
{
int value =(int)db.ExecuteScalar(CommandType.Text,sql);
return value;
}
/// <summary>
/// Ö´Ðд洢¹ý³Ì
/// </summary>
private void ExeProcNonPar()
Ïà¹ØÎĵµ£º
·¢²¼ÈÕÆÚ : 8/8/2003 | ¸üÐÂÈÕÆÚ : 6/7/2004
Martin Tracy
Visual Studio Team
Microsoft Corporation
ÊÊÓÃÓÚ£º Microsoft® ADO.NET
Microsoft® ASP.NET
Microsoft® Visual C#® .NET
Microsoft® Visual Studio® .NET
ÕªÒª£º±¾ÑÝÁ·ËµÃ÷ÁËÈçºÎʹÓüòµ¥µÄ Visual C#® ÄÚº¬´úÂë Web Ó¦ÓÃ³Ì ......
ÈÕÆÚ/ʱ¼ä
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1& ......
2008-04-10 09:45 //*******FactoryManage.cs using System;
using System.Reflection;
using System.Configuration;
using CoalTraffic.IDAL; namespace CoalTraffic.DALFactory
{
/// <summary>
/// ³éÏ󹤳§Ä£Ê½´´½¨DAL¡£
......
Îı¾ nvarchar(n)
±¸×¢ ntext
Êý×Ö(³¤ÕûÐÍ) int
Êý×Ö(ÕûÐÍ) smallint
Êý×Ö(µ¥¾«¶È) real
Êý×Ö(Ë«¾«¶È) float
Êý×Ö(×Ö½Ú) tinyint
»õ±Ò money
ÈÕÆÚ smalldatetime
²¼¶û bit
¸½£º×ª»»³ÉSQLµÄ½Å±¾¡£
ALTER TABLE tb ALTER COLUMN aa Byte Êý×Ö[×Ö½Ú]
ALTER TABLE tb ALTER COLUMN aa Long Êý×Ö[³¤ÕûÐÍ]
ALTER T ......
Java д Access
1. ÔÚ±¾µØÖÐÎļÆËã»úÉÏ£¬·¢ÏÖдÖÐÎĵ½accessÉÏ£¬³öÏÖÂÒÂë¡£¶ÁµÄʱºòÒ²ÊÇÂÒÂë¡£
2. ¶ÁµÄʱºò£¬²»ÄܶÁstring£¬ÏÈʹÓÃbyte¶Á³öÀ´£¬È»ºóÔÙ´´½¨GBK±àÂëµÄString.
3. ²Î¿¼¶Á£¬¿ÉÄÜдµÄʱºòÒ²ÊDZ ......