可以将来自外部源的信息记录到SP列表中. [英] Can one get record information from an external source into a SP list.

问题描述

您好，我在寻找一种方法来查找外部数据库Access 2007中的记录并使用查询数据填充列表的NewForm中的字段时遇到了问题，如何从SQLDataSouce获取值传递给参数?
我会按要求修改.

我需要使用来自共享点站点的用户输入对Access 2007数据库中的表进行简单查找.用户将输入一个UID，然后单击提交"按钮.查询将创建一个从Sharepoint到数据库的连接，并在表中查询记录.在数据库中找到记录后，我需要使用记录集中的信息在共享点站点的列表中创建一个新记录(项目)，但我想为用户提供一种在保存之前编辑数据的方法.列表中的项目.我现在的问题是我无法将输入的UID值传递给查询，也无法将记录传递给SP表单.如果我将UID硬编码到查询中，则会得到一条记录，但是无法用信息填充表单.

有没有人做过这样的事情，可以建议我将记录信息传递到列表的newform.aspx中需要做什么?
(是的，我确实创建了一个自定义表单，并且可以将信息从另一个列表传递到字段.)

Hi, I am having problems finding a way to look up a record in a external database, Access 2007, and using the query data to populate fields in a list''s NewForm, How do I get the values from a SQLDataSouce to pass through to parameters?
I''ll Revise as ask.

I need to do a simple lookup of a table in an Access 2007 database, using user input from a sharepoint site. The user would enter a UID and click a submit button. A query would create a connect to the database from Sharepoint, and query the table for a record. Once a record is found in the database, I need to created a new record (item) in a list in my sharepoint site, useing the information from the recordset, but I want to give the users a way to edit the data before saving the item to the list. My problem at this point is I can not get the entered UID value passed to the query, nor can I get record passed to the SP Form. If I hard code the UID into the query, I get a record, but then I can not populate the form with the information.

Has anyone done something like this that could advise me as to what I need to do to pass the record information into the list''s newform.aspx
(yes I did create a custom form, and can pass information to the fields from another list.)

推荐答案

外部列表(也称为虚拟列表)是一个很好的开始观点.它们是在SharePoint 2010中引入的.

http://msdn.microsoft.com/en-us/library/ee558778(office .14).aspx


http://channel9.msdn.com /posts/kmcgrath/通过使用业务数据在SharePoint中创建一个外部列表/

External lists (also called virtual lists) are a good starting point. They were introduced in SharePoint 2010.

http://msdn.microsoft.com/en-us/library/ee558778(office.14).aspx


http://channel9.msdn.com/posts/kmcgrath/Creating-an-External-List-in-SharePoint-by-Using-Business-Data/

这篇关于可以将来自外部源的信息记录到SP列表中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！