很多时候我们并不需要很多数据库的功能,虽然Sqlserver已经很简单了,但是Access更简单,而且更容易移植,只要你安装了office
下面是使用步骤:
新建Access数据库
在桌面右键-新建Microsoft Access数据库
新建表等
将新建的数据库复制到vs建的项目文件夹中,我放在了App_Data文件夹中
创建数据库查询辅助类
我新建了一个类DBHelper.cs
直接上代码
public class DBHelper
{
private OleDbConnection con = new OleDbConnection();
private OleDbCommand cmd = new OleDbCommand();
private OleDbDataAdapter oda = new OleDbDataAdapter();
private string LocPath = System.Web.Configuration.WebConfigurationManager.AppSettings["LocPath"];
/// <summary>
/// 查询
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public DataSet Get(string sql,string TableName)
{
DataSet ds = new DataSet();
con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=" + LocPath + "App_Data/abc.accdb";
con.Open();
cmd.Connection = con;
cmd.CommandText = sql;
oda = new OleDbDataAdapter(cmd);
oda.Fill(ds, TableName);
con.Dispose();
cmd.Dispose();
oda.Dispose();
return ds;
}
/// <summary>
/// 修改执行
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public int Set(string sql)
{
DataSet ds = new DataSet();
con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=" + LocPath + "App_Data/abc.accdb";
con.Open();
cmd.Connection = con;
cmd.CommandText = sql;
int ret = cmd.ExecuteNonQuery();
con.Dispose();
cmd.Dispose();
oda.Dispose();
return ret;
}
}
其中LocPath是在Web.config中配置的,方便移植
没了,就这些,备忘