How do I connect a SharePoint web part to a SQL Server database?
Asked
Active
Viewed 4,404 times
0
-
The question is a little bit too generic. Could you please elaborate a little bit on what you are trying to do? – Magnus Johansson Jun 04 '09 at 09:23
-
This might help: http://stackoverflow.com/questions/1003633/wss-3-0-list-populated-from-sql-query – Alex Angas Jun 18 '09 at 09:41
1 Answers
1
The simpliest way would be to simply have a SQL query in your web part to a database of your choosing. Done. Remember, web parts are Web Controls running in an asp.net http context. You can have anything there.
There are other middle men available like the Data Viewer Web Part, BDC, SQL Reporting Services for SP 2007 and much more. Good luck.
Marc
- 1,178
- 1
- 18
- 31