December 16, 2012

// // Leave a Comment

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)
Create a database and create table in SQL server. I have create a sample employee table



2)
Entered the sample values to the SQL table



3)
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





4)
Select the source as database and click next




5)
In the data connection wizard click on Select Database.





6)      In Select data source click on New Source.



7)
In Data Connection Wizard Select the Microsoft SQL server and click next




8)
Mention the database Server details and click next



9)

Select the database name and click then select the table inside database..
Click next






10)
Finish the data connection wizard.



Read the remaining post in Part two....!

0 comments:

Post a Comment