Populate repeating table from sql server table - InfoPath Dev
in

InfoPath Dev

Populate repeating table from sql server table

Last post 11-09-2009 11:14 AM by dngo4579. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-09-2009 10:58 AM

    Populate repeating table from sql server table

    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!

  • 11-09-2009 11:09 AM In reply to

    Re: Populate repeating table from sql server table

    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.

  • 11-09-2009 11:14 AM In reply to

    Re: Populate repeating table from sql server table

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

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.