?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>
/// DB 的摘要說明
/// </summary>
public class DB
{
	public DB()
	{
    //
    // TODO: 在此處添加構造函數邏輯
    //		
	}

    #region   返回數據在內存中的緩存填充
    /// <summary>
    /// 返回數據在內存中的緩存填充
    /// </summary>
    /// <param name="sSql"></param>
    /// <returns></returns>
    public static System.Data.DataSet createConnection(string sSql)
    {
        OleDbConnection con = mycon();
        con.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(sSql, con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        con.Close();
        return ds;
    }
    #endregion

    #region 鏈接字符串
    /// <summary>
    /// Access鏈接字符串
    /// </summary>
    /// <returns></returns>
    public static OleDbConnection mycon()
    {
        String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="; connectionString += @"D:\Acc\Bin\Accdata.mdb";
        //OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Accdata.mdb");
        OleDbConnection con = new OleDbConnection(connectionString);
        return con;
    }

    #endregion

    #region  執行Sql語句
    /// <summary>
    /// 執行Sql語句
    /// </summary>
    /// <param name="sSql">SQL語句</param>
    /// <returns></returns>
    public static void SqlDo(string com)
    {
            OleDbConnection con = mycon();
            con.Open();
            OleDbCommand comm = new OleDbCommand(com, con);
            comm.ExecuteNonQuery();
            comm.Dispose();
            con.Close();        
    }
    #endregion

    #region  將字符串轉換為Double型并返回
    /// <summary>
    /// 將字符串轉換為Double型并返回
    /// </summary>
    /// <param name="str">要轉換字符串</param>
    /// <returns></returns>
    public static double val(string str)
    {
        str = str.Trim();
        if (isdata(str) && str != "-" && str != ".")
            return Convert.ToDouble(str);
        else
            return 0;
    }
    #endregion

    #region  返回字符串是否為數字
    /// <summary>
    /// 返回字符串是否為數字
    /// </summary>
    /// <param name="str">要檢測字符串</param>
    /// <returns></returns>
    public static bool isdata(string str)
    {
        if (str == string.Empty) return false;

        foreach (char sc in str.Trim().ToCharArray())
        {
            if (!char.IsDigit(sc) && sc != '.' && sc != '-')//sc!="."
                return false;
        }
        return true;
    }
    #endregion

}