General

Re: Populate repeating table from sql server table

dngo4579 — Mon, 09 Nov 2009 19:14:09 GMT

I did not know you can do that... wow thank you so much.

Re: Populate repeating table from sql server table

warrtalon — Mon, 09 Nov 2009 19:09:33 GMT

Sure, create the data connection to recieve data from SQL (a web service would be preferred). Then, in Design mode, open the data source pane on the right, change to the SQL data connection, drill down to the repeating group that contains the nodes, drag that repeating group to the canvas, and let it create a repeating table. This will create a repeating table that shows all columns auto-formatted to a fairly small size so that it all fits on the screen. If you preview the form, it should show all the data from SQL in the repeating table.

Populate repeating table from sql server table

dngo4579 — Mon, 09 Nov 2009 18:58:24 GMT

I am trying to populate a repeating table based on values from a sql server table. Sort of like a datagrid or something. Basically I would like to show the users a table from sql server on an infopath form. If the sql server table has 30 rows and 15 columns, i would like that displayed in a table in infopath. Is this possible?

If code is required, C# please! Thanks!