?? db.cs
字號:
?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
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -