dataentity.cs

一个ASP.NET操作Excel文档的类,CSharp实现

/***********************************************************
 * Product Name: ExcelQuicker
 * Copyright (c)2005, Eunge
 * Author: Eunge
 * Web Site: www.eudev.net
 * Mail/MSN: [e-mail]
 * ********************************************************/
using System;
using System.Web;
using System.Data;
using System.Data.OleDb;

namespace ExcelHelperTest
{
	/// <summary>
	/// DataEntity.
	/// </summary>
	public class DataEntity
	{
		private static string ConnectionString
		{
			get
			{
				string strDBPath = HttpRuntime.AppDomainAppPath + "DataBase\\DB.mdb";
				string strDBConnectionParameter = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=\"" + strDBPath + "\";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=\"Microsoft.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
				return strDBConnectionParameter;
			}
		}


		private static OleDbConnection Connection
		{
			get
			{
				OleDbConnection objOleDbConnection = new OleDbConnection(ConnectionString);
				return objOleDbConnection;
			}
		}

		private static DataSet GetDataSet(string sql)
		{
			OleDbDataAdapter objOleDbDataAdapter = new OleDbDataAdapter(sql, DataEntity.Connection);
			DataSet dst = new DataSet();
			objOleDbDataAdapter.Fill(dst);
			return dst;
		}

		public static DataTable GetProducts()
		{
			string strSQL = "SELECT 产品ID,产品名称,单位数量,单价,库存量 FROM Products";
			DataTable dt = DataEntity.GetDataSet(strSQL).Tables[0];
			return dt.Copy();
		}


		
	}
}