使用 OLEDB Access 数据库的企业库

发布于 2024-09-11 05:25:37 字数 712 浏览 9 评论 0原文

我想使用 Microsoft 企业库数据应用程序块用于 MS Access 数据库（OLEDB 提供程序）

我想要使用企业库进行基于参数的 INSERT 功能（就像我们对具有基于参数的代码的 SQL 提供程序所做的那样 -database.params.Add("@EmpName ", this.EmpName);

我想要 MS Access 数据库连接有同样的东西。

有人可以告诉我我该怎么做吗？

提前谢谢。

这段代码可以工作吗？

SirDemon，谢谢你的解释..我知道与 SQL 的插入、更新和删除相关的一切。我希望它与 MS ACCESS 兼容。好吧，告诉我，下面的代码可以工作吗？

string query = "INSERT INTO DB (EmployeeID, Name) VALUES (@EmployeeID, @Name)

Database db = DatabaseFactory.CreateDatabase();

DbCommand sqlCommand = db.GetCommandFromText(query);

db.AddInParameter(sqlCommand, "@EmployeeID", this.EmployeeID);
db.AddInParameter(sqlCommand, "@Name", this.Name);

这个例子可以在 MS Access 数据库中运行吗？

原文

I want to use Microsoft Enterprise library Data Application Block for MS Access database (OLEDB provider)

I want parameter based INSERT functionality with enterprise library (Just like we do for SQL provider with parameter based code like - database.params.Add("@EmpName", this.EmpName);

I want the same thing for MS Access database connection.

Could anybody please let me know How could I do this?

Thanks in advance.

Will this code work?

SirDemon,
Thanks for explanation.. I know everything related to INSERT, Update and Delete for SQL. I want compatible it with MS ACCESS . Okay tell me, is below code will work ?

string query = "INSERT INTO DB (EmployeeID, Name) VALUES (@EmployeeID, @Name)

Database db = DatabaseFactory.CreateDatabase();

DbCommand sqlCommand = db.GetCommandFromText(query);

db.AddInParameter(sqlCommand, "@EmployeeID", this.EmployeeID);
db.AddInParameter(sqlCommand, "@Name", this.Name);

Will this example will work in MS Access database.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

往昔成烟 2024-09-18 05:25:37

您可以使用 OleDbCommand 设置参数和查询，就像在 SQL Provider 上使用 SqlCommand 一样。

OleDb 命令概述

OleDbCommand 类成员< /a>

使用您的示例：

string query = "INSERT INTO DB (EmployeeID, Name) VALUES (@EmployeeID, @Name)"

Database db = DatabaseFactory.CreateDatabase();

DbCommand command = db.db.GetSqlStringCommand(query);
db.AddInParameter(command, "@EmployeeID", this.EmployeeID);
db.AddInParameter(command, "@Name", this.Name);
db.ExecuteNonQuery(command);

应该可以。

You can use OleDbCommand to set your parameters and query, just as you would do with SqlCommand on SQL Provider.

OleDbCommand Overview

OleDbCommand Class Members

To use your example:

string query = "INSERT INTO DB (EmployeeID, Name) VALUES (@EmployeeID, @Name)"

Database db = DatabaseFactory.CreateDatabase();

DbCommand command = db.db.GetSqlStringCommand(query);
db.AddInParameter(command, "@EmployeeID", this.EmployeeID);
db.AddInParameter(command, "@Name", this.Name);
db.ExecuteNonQuery(command);

Should work.

回复收藏 0 原文

~没有更多了~