在 Sharepoint 中显示 SQL 查询结果
我为我的公司支持 Rational Clearquest，并被要求在 Sharepoint 中显示一些数据。
我可以毫无问题地在 Clearquest 中查询数据（使用 Toad），但不知道如何在 Sharepoint 中显示它。
我正在查询的数据包含日期，理想情况下我希望能够将其显示在共享点日历中，但目前可以使用列表格式。
有人可以提供建议，甚至从哪里开始吗？
谢谢，
乔
I support Rational clearquest for my company and have been asked to show some of the data in Sharepoint.
I can query the data in Clearquest no problem (Using Toad) but have no idea about how to go displaying it in Sharepoint.
The data I'm querying contains dates and ideally I'd like to be able display it in a sharepoint calendar but list format would do for the moment.
Can anybody offer advice on even where to start?
Thanks,
Joe
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
虽然您可以采用 Ben 建议的简单方法，但有很多选项可以为您提供“帮助”，特别是如果您只是显示数据。
您首先应该查看 SharePoint 数据视图 Web 部件 (DVWP)。这里有一个详细的演练这里 以及 劳拉·罗杰斯
非常相似，但如果您讨厌 SharePoint 设计器，则有 照明工具数据查看器 Web 部件
如果您使用 MOSS，则可以使用业务数据目录 (BDC) - 在 SharePoint 网站上显示业务数据
还有其他不需要 MOSS 的第三方选项，例如 Layer2 的业务数据列表连接器 (BDLC)
如果您有技术资源，您可以（扩展 Ben 建议的方法）编写自己的 可重用 SQL 数据查看器 Web 部件< /a>
Whilst you could do the bare bones approach suggested by Ben there are lots of options that will give you a 'leg up' especially if you are just displaying data.
Your first look should be at SharePoints Data View Web Part (DVWP). There is a length walkthrough here and some great tutorials by Laura Rogers
Very similar but if you hate SharePoint designer there is Lighting Tools Data Viewer Web Part
If you are using MOSS you could use the Business Data Catalog (BDC) - Display business data on a SharePoint site
There are other 3rd party options too that don't require MOSS such as Layer2's Business Data List Connector (BDLC)
If you have technical resource you could (expanding on approach suggested by Ben) write your own Reusable SQL Data Viewer Web Part
您必须开发一个共享点“功能”，例如 Web 部件。然后，您可以显示从数据库检索数据并根据需要显示它。您基本上将开发一个 ASP.NET 组件/应用程序，但共享点对您施加了某些限制。您可以阅读基本步骤
You would have to develop a sharepoint "feature" such as a webpart. You could then display retrieve the data from the db and display it however you want. You would basically be developing a asp.net component/application but with certain restrictions that sharepoint forces on you. You can read the basic steps here