【代码】操作access

//连接字符串
public OleDbConnection CONN
{
get { return new OleDbConnection("Provider=Microsoft.jet.Oledb.4.0;data source="+Server.MapPath("~/app_data/db.mdb")); }
}

//添加
protected void submitBtn_Click(object sender, EventArgs e)
{
using (OleDbConnection conn = CONN)
{
conn.Open();
OleDbCommand command = new OleDbCommand("insert into [msgBoard]([uname],[associate],[content],[ip],[time],[faces],[ok])values("
+ "@uname,@associate,@content,@ip,@time,@faces,false)", conn);

OleDbParameter op = new OleDbParameter("@uname", OleDbType.VarChar);
op.Value = unames.Text;
command.Parameters.Add(op);

op = new OleDbParameter("@associate", OleDbType.VarChar);
op.Value = common.safeText(associate.Text);
command.Parameters.Add(op);

op = new OleDbParameter("@content", common.safeText(Content.Text));
command.Parameters.Add(op);

op = new OleDbParameter("@ip", OleDbType.VarChar);
op.Value = Request.UserHostAddress;
command.Parameters.Add(op);

op = new OleDbParameter("@time", OleDbType.DBDate);
op.Value = DateTime.Now;
command.Parameters.Add(op);

op = new OleDbParameter("@faces", OleDbType.VarChar);
op.Value = com.common.safeText(Request.Form["faces"]);
command.Parameters.Add(op);

command.ExecuteNonQuery();
Response.Write("<script language='javascript'>alert('留言成功！等待审核中。。');</script>");
}
items.DataBind();

}
}

 // 获取雇员信息
public List<EmployeeModel> GetEmployeesInfo()
{
List<EmployeeModel> returnedValue = new List<EmployeeModel>();
OleDbCommand Cmd = new OleDbCommand();
SQLExcute("SELECT * FROM Employee", Cmd);
OleDbDataAdapter EmployeeAdapter = new OleDbDataAdapter();
EmployeeAdapter.SelectCommand = Cmd;
DataSet EmployeeDataSet = new DataSet();
EmployeeAdapter.Fill(EmployeeDataSet);

foreach (DataRow dr in EmployeeDataSet.Tables[0].Rows)
{
EmployeeModel tmp = new EmployeeModel();
tmp.ID = Convert.ToInt32(dr[0]);
tmp.Name = Convert.ToString(dr[1]);
tmp.Age = Convert.ToInt32(dr[2]);
returnedValue.Add(tmp);
}
return returnedValue;
}

 // 添加雇员信息
public void Insert(List<EmployeeModel> employee)
{
employee.ForEach(x =>
{
string CmdText = "INSERT INTO Employee(Name,Age) VALUES('" + x.Name + "'," + x.Age.ToString() + ")";
SQLExcute(CmdText);
});
}

 // 更新雇员信息
public void Update(List<EmployeeModel> employee)
{
employee.ForEach(x =>
{
string CmdText = "UPDATE Employee SET Name='" + x.Name + "',Age=" + x.Age.ToString();
CmdText += " WHERE ID=" + x.ID.ToString();
SQLExcute(CmdText);
});
}

// 删除雇员信息
public void Delete(List<EmployeeModel> employee)
{
employee.ForEach(x =>
{
string CmdText = "DELETE FROM Employee WHERE ID=" + x.ID.ToString();
SQLExcute(CmdText);
});
}

// 执行SQL命令文本，重载1
private void SQLExcute(string SQLCmd)
{
string ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("Employees.mdb;");
OleDbConnection Conn = new OleDbConnection(ConnectionString);
Conn.Open();
OleDbCommand Cmd = new OleDbCommand();
Cmd.Connection = Conn;
Cmd.CommandTimeout = 15;
Cmd.CommandType = CommandType.Text;
Cmd.CommandText = SQLCmd;
Cmd.ExecuteNonQuery();
Conn.Close();
}

// 执行SQL命令文本，重载2
private void SQLExcute(string SQLCmd, OleDbCommand Cmd)
{
string ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("Employees.mdb;");
OleDbConnection Conn = new OleDbConnection(ConnectionString);
Conn.Open();
Cmd.Connection = Conn;
Cmd.CommandTimeout = 15;
Cmd.CommandType = CommandType.Text;
Cmd.CommandText = SQLCmd;
Cmd.ExecuteNonQuery();
Conn.Close();
}

}
}