I hope I can get some tips here. I have some fields in a SharePoint form that I would like to pre populate from a table in SQL server tables.

So for example if I select a value in a dropdown field in sharepoint form I would like this to go to a table in SQL and get some data rows which I will then use to fill in some text in my texboxes etc...

Any tips will be appreciated.

1 Answer 1


This is a pretty good guide.

You can specify which columns to show, specify custom queries, order, filter, join...

Furthermore, you could also use the SSRS integration package to display it in a more BI-friendly manner... but if all you want is to expose SQL through a SharePoint list, the link above will do.

Hope that helps!

  • Manish as I said I want to populate texboxes, dropdown from sql server table. Hope this makes sense
    – naijacoder
    Commented Jul 3, 2015 at 7:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.