Maybe this is a silly question but i am not getting any specific answers to it on google.
We want to develop custom code to display data from SQL into our SharePoint site page. It should look exactly like Listview webpart's view but pulls data from SQL not sharepoint.
I am desperately looking for any good example for this …actually any example would do to get me started.
any help is highly appreciated.
May 30, 2010
Or just use SharePoint Designer to make a Data View. Quicker and more flexible than C#.
1. In SPD, create a new data source pointing to your SQL – I assume the data will be security trimmed to the current user.
2. Create a new data view based on that data source
There's no need to heavily format the data in SPD if you create some decent views (stored procs) in SQL – keeps the processing close to the source data.
OR if there's isn't actually that much data, build an external content type in SPD to sync your SQL data with a SharePoint list – then you can just add the list to your page as a web part.
All without a line of C#. Best of luck with it.
Sharepint Data Connector can connect SharePoint list to database; Transfer business data between SharePoint list and External data, import external data to SharePoint list, or export SharePoint list to SQL, Oracle, or MySQL
Most Users Ever Online: 91
Currently Browsing this Page:
Guest Posters: 1113
Administrators: Learning SharePoint (212)