?? dbclass.cs
字號:
using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
using System.IO;
using System.Runtime.InteropServices;
namespace UpdateProduce
{
/// <summary>
/// DBClass 的摘要說明
/// </summary>
public class DBClass
{
public DBClass()
{
//
// TODO: 在此處添加構造函數(shù)邏輯
//
}
private OleDbConnection conn;
#region 數(shù)據(jù)庫連接
/// <summary>
///獲得數(shù)據(jù)庫連接
/// </summary>
/// <returns>SqlConnection對象</returns>
public OleDbConnection GetConn()
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/3d/data.mdb;" );
return conn;
}
#endregion
#region 數(shù)據(jù)集
/// <summary>
/// 數(shù)據(jù)集
/// </summary>
/// <param name="mysql">Sql語句</param>
/// <param name="name">表名稱</param>
/// <param name="option_flag">配置標識符</param>
/// <returns></returns>
public DataSet MyDBSet(string mysql, string name)
{
using (OleDbConnection con = this.GetConn())
{
try
{
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(mysql, con);
DataSet ds = new DataSet();
da.Fill(ds, name);
return (ds);
}
catch
{
return (null);
}
}
}
#endregion
#region 刪除數(shù)據(jù)
/// <summary>
/// 刪除數(shù)據(jù)
/// </summary>
/// <param name="tablename">表名</param>
/// <param name="term">條件</param>
/// <returns></returns>
public bool delete(string tablename, string term)
{
string sql = "delete " + tablename + " where " + term;
using (OleDbConnection con = this.GetConn())
{
OleDbCommand com = new OleDbCommand(sql, con);
try
{
con.Open();
com.ExecuteNonQuery();
com.Connection.Close();
return true;
}
catch
{
com.Connection.Close();
return false;
}
}
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -