在Infopath中读取SQL数据 [英] Reading SQL Data in Infopath

问题描述

I have a SQL table that a has approximately 50 (+-) rows.  The table has a column  named RecordSeries which is the primary key.  The remainder of the data in the row is info about the RecordSeries; Number, Description and Retention Period.

以InfoPath表单(在下面复制)   表格上显示4个字段:

In an InfoPath form (copy below)   there are 4 fields displayed on the form:

记录系列(下拉列表)    -ddlRecordSeries

Record Series (drop down list)    -- ddlRecordSeries

数字(文本框)   -txtNumber

Number (text box)    -- txtNumber

描述(文本框)   -txtDescription

Description (text box)    -- txtDescription

保留期限(文本框)   -  txtRetentionPeriod

Retention Period (text box)   --  txtRetentionPeriod

我想要的是唱片系列"下拉列表，包含表中的所有记录系列.用户将选择记录系列，然后按获取".按钮显示编号，描述和保留期限.

What I want is the Record Series drop down list  to contain all Record Series in the table.  The user will select the Record Series and press the "Get it" button to display the number, description and retention period.

在记录系列"下拉列表中，我有一个定义数据库和表的数据源.具有要使用的数据.由于在记录系列"字段中完全填充了记录系列"字段，因此该部分工作正常.要选择的数据. 我已经尝试过几次以获取编号，说明和保留期限，但是没有任何效果.我得到的是表中第一条记录的编号，描述和保留期.

In the record series drop down list I have a data source that defines the database and table  that has  the data to be used.  This part works fine as the Record Series field is fully populated with  data to select from.   I have tried several time to get the number, description and retention period but nothing works.  What I do get is the number, description and retention period for the first record in the table.

推荐答案

NSIISLC，您应该能够以与获取唱片系列相同的方式进行操作.尝试时会发生什么/不会发生什么?也许您需要过滤数据?

Hi NSIISLC- you should be able to do that the same way you're getting the record series. What happens/doesn't happen when you try? Maybe you need to filter the data?

这篇关于在Infopath中读取SQL数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！