Populate SharePoint list data into InfoPath form

For application development using InfoPath form on SharePoint environment this is a common scenario for populating your SharePoint list data into the InfoPath form. These data may need to populate on a repeating control, drop down list box, text box etc and you may need to do some sort of calculation based on your business requirements.
To do this there are very few simple steps. First consider that your SharePoint server is in operation mode and you have created a custom list with some sample data. Now just follow the following steps:

1. Open your InfoPath form and create a blank template.
2. Form tools menu go to data connections and click the add button for creating a new data connection with external data source.
3. Select the first radio button (create a data connection to:) and "receive data" radio button. Click next.
4. Select "SharePoint library or list" radio button and click next.
5. Copy and paste your SharePoint site URL where your custom list exists and click next.
6. Now you can find out a list of list or library for the given SharePoint URL.
7. Select your custom SharePoint list and click next.
8. Now select the column name you want to populate on your InfoPath form and click next.
9. Click next if you do not want to store this list data for using on offline mode.
10. Now rename your data connection name and finish the wizard leaving the default checkbox value.

Just now you completed a data connection to receive data from your SharePoint list data into your InfoPath form. You need some more steps for populating your SharePoint list data into the InfoPath form. The steps are:

1. Insert a dropdown control in your InfoPath form.
2. Right click this dropdown list and go to "Drop-Down List Box Properties"
3. Form data tab go to list box entries section and select "Lookup Values Form an External Data Source" and from Data source drop down list select the data source name you just named at step 10.
4. Now from the Entries text box select "Select XPath" button and select the SharePoint list column you want to fill on form controls.
   

   
5. You have completed all necessary steps to fetch data from SharePoint list to InfoPath form. From file menu preview it in form view and see the changes. J