在ACCESS2007里,点击“创建”-->“查询设计”,如图2.1所示:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|db.mdb;Persist Security Info=False
出现的选择表不用理会,直接关闭。然后切换视图到SQL视图,如图2.2所示:
图2.2 进入SQL视图
如图2.3所示。不过ACCESS不支持多语句,很遗憾。
图2.3 编写SQL
当然,编写完后记得保存,这儿存为UP_Insert_Member。
三、在代码中进行调用
在这儿直接使用微软的企业库了,调用代码如下:
Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetStoredProcCommand("UP_Insert_Member");
db.AddInParameter(cmd, "MopID", DbType.String, this.tbMopID.Text);
db.AddInParameter(cmd, "IsJoinGroup", DbType.Boolean, this.chkIsJoinGroup.Checked);
db.AddInParameter(cmd, "GroupNumber", DbType.Int32, this.ddlGroupNumber.SelectedValue);
db.AddInParameter(cmd, "SendMoper", DbType.String, this.txtSendMoper.Text);
this.Label1.Text = string.Format("添加了{0}条数据", db.ExecuteNonQuery(cmd));
四、使用事务
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
DbTransaction tran = conn.BeginTransaction();
DbCommand cmd = db.GetSqlStringCommand("delete from Member");
this.Label1.Text = string.Format("删除了{0}条数据", db.ExecuteNonQuery(cmd, tran));
tran.Rollback();
BindData();
}