Newbie Questions

Re: Displaying information from SQL Server Database on a form

warrtalon — Fri, 09 Jan 2009 02:07:59 GMT

You shouldn't need a rule to tell it to query after opening. It should automatically query the DB and any other data connection automatically upon opening it. Did you not check that box on your data connection maybe? I don't use IP2003, so it's possible that it's just different.

Re: Displaying information from SQL Server Database on a form

Ychhoker — Thu, 08 Jan 2009 23:31:29 GMT

Thanks a lot for replying. I got it done. I created a form and then opened Tools-->Forms Options-->Open and Save. I added a rule to query database.

Thanks a lot again.

Re: Displaying information from SQL Server Database on a form

warrtalon — Thu, 08 Jan 2009 22:52:58 GMT

Submitting the data from the form to the DB is much more difficult than just displaying data in the from from a DB. What happens when you try it? You create the form using the Database template and tie the main data source to the DB connection. You then either just show the entire data set by dragging from the data source pane to the canvas, or you can create local form data fields and tie the DB elements to certain local fields for display.

Displaying information from SQL Server Database on a form

Ychhoker — Thu, 08 Jan 2009 20:44:10 GMT

Hi All,

I am new to Infopath (spent last 2 days to create few forms) and struggling to create a new form where i can display all the information from a SQL Server Database. I have already created a submit form where user can enter information and save it in database. My objective it to create a form which when opened by any user displays all the information, in tabular format, from SQL Server Database. I will keep trying my hands on it, but if you can guide me in right direction that would be great.

Infopath: 2003

SQL Server: 2005

Thanks a lot in advance :)