Hi,

I would like to create InfoPath form which will retrieve data from SharePoint 2010 list then at the bottom a SUBMITT button which will submit the data to SQL table.

Retrieve data should be in rows /column format.

Companyid      CompanyName                EmailAddress

111                  ABC Company                   xxx@xx.com

112                  CDB Company                   yyy@yy.com

Any help will be appreciated

I would argue that this is a recipe for data inconsistencies (differences, duplicates, etc). Handling data synchronization is not an easy task, and many implementations are buggy.

I'd strongly evaluate the possibility of using BCS to store the data in SQL directly.

What is BCS stands for?.

Problem is I cannot give user's access to submit data directly to SQL table that's why I created SharePoint list where they can submit the requests.

My job is to retrieve the data from SharePoint list using InfoPath , than submit it to SQL table

Hello,

>What is BCS stands for?.

Business Connectivity Services. Where you can get/set data from sharepoint to SQL. Please read below MSDn for more info.

http://msdn.microsoft.com/en-us/magazine/ee819133.aspx

About infopath, you have to write custom web service to submit list data from infopath to SQL. By default you can only fetch data from SQL by creating a database connection. Here is one similar thread for your re:

http://www.infopathdev.com/forums/p/20984/72698.aspx

Hope it could help

Submitting Data:

http://jaliyaudagedara.blogspot.in/2011/03/submitting-data-to-sharepoint-2010-list.html

Retreving:

http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?ID=129

http://www.sharepointninja.com/Blog/Lists/Posts/Post.aspx?ID=13