Display SQL table in InfoPath form - Part One
To display SQL tables in read only format inside an browser enabled infopath form , follow the below steps.
The Article is divided into 2 parts of posts.
1) Part One
2) Part Two
Create a database and create table in SQL server. I have create a sample employee table
Entered the sample values to the SQL table
Now backend work is done. We need to design the infopath form. Open the Infopath designer
Go to Data → Data Connections → Add new Connection → Check on receive data and click next
Select the source as database and click next
In the data connection wizard click on Select Database.
6) In Select data source click on New Source.
In Data Connection Wizard Select the Microsoft SQL server and click next
Mention the database Server details and click next
Select the database name and click then select the table inside database..
Finish the data connection wizard.
Read the remaining post in Part two....!