简单的数据库用户界面
我有一个简单的 SQL Server 数据库，用于转换。 基本上是一个具有两列以上的表，其中一个值映射到另一个值。 然后，我们使用这些表来查找匹配值并选择该行上的其他值。
这些值变化很大，我们现在需要一个接口供业务用户自行更新这些值。 我不想想花时间构建新的东西，我宁愿使用用户习惯的东西和界面 - 例如 Excel 或 SharePoint 中的某些东西。
您是否解决过类似的问题以及在该场景中轻松获胜的想法是什么？
I have a simple SQL Server database that we use for conversions. Basically a table with two mor more columns where one value maps to another. We then have processes that use these tables to find matching values and select other values on that row.
These values change a lot and we now need a interface for the business users to update the values themselves. I don't want to spend time building something new, I rather use and interface that the uses are used to - for example Excel or something in SharePoint.
Have you solved something similar and what your idea for a easy win in the scenario?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
您可以轻松从 Excel 创建连接，让他们使用他们首选的更新工具;-)
编辑：显然，上面的链接无法将更改更新回 SQL Server（自动）。
在寻找解决方案时，出现了这个SO问题..看来你必须做一些手工工作...
在这里我找到了一个更好的链接，其中包含您的演练正在尝试做。 华泰
You can easily create a connection from Excel to let them use their preferred tool to do the updates ;-)
Edit: Apparently, the above link doesn't make it possible to update the changes back to SQL Server (automatically).
While searching for a solution this SO question came up... It seems you have to do some manual work...
Here I found an even better link with a walkthrough for what you're trying to do. HTH
您可以将 SQL Server 表映射到 Access“表”（我忘记了此“表”类型的确切 Access 术语。）
结果将是您的用户可以使用 Access 工具（包括网格）来更改表上的数据。实际服务器。
请记住在 SQL Server 上创建仅具有执行有效任务所需的最低权限的用户名。 例如，用户是否需要对行进行插入或删除功能？ 还是只是更新能力？
拉里
You can map the SQL Server table into an Access "table" (I forget the exact Access term for this "table" type.)
Result will be that your users can use the Access tools, including the grid, to change the data on the actual server.
Remember to create user names on the SQL Server that only have the minimum permissions needed to do the valid tasks. Eg do the users need insert or delete ability on the rows? Or just update ability?
Larry
您可以使用 ASP.Net 动态数据脚手架，或者如果您有 MOSS 2007，则可以使用业务数据目录拥有一些可实现回写功能的现成 Web 部件的企业。
You could either use ASP.Net Dynamic Data scaffolding or use the Business Data Catalog if you have MOSS 2007 Enterprise with some off-the-shelf web parts which enable write-back capability.
我认为就这个目的而言，Acces 比 Excel 更好，因为您可以更轻松地创建代码来真正限制可以用作可接受值的内容。
另一种可能性是基于 Web 的表单（或应用程序，具体取决于其复杂程度），您可以根据您的了解，使用 .net 或其他某种语言创建该表单。 只要他们有网址并且表单相当简单，您的用户就不会遇到任何问题。 使其仅在内部网上可用，而不能在外部世界上使用，并且需要用户名和密码，并且它与其他可用的可能性一样安全。 这样做的一个真正的优点是，当变更时间到来时，您可以轻松地部署变更。 一个缺点是它的初始设置比 Access 表单更复杂。
I think Acces is better than Excel for this purpose as you can create the code to really limit what they can use as acceptable values much more easily.
Another possiblility is a web-based form (or application depending on how complex this is) that you create in .net or some other language depending on what you know. As long as they have the web address and the form is fairly straightforward, your users will have no trouble with this. Make it available only on the intranet and not to the outside world and require usernames and passwords and it is as secure as the other possibilites being floated around. One real advantage of this is that when change time comes around you can easliy deply changes. One disadvantage is it is more complex to originally set up than an Access form.