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.

Harold

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

3. Tweak the XSLT to transform how the data is presented. You can mostly do this in design mode, but some HTML/CSS/Javascript tweaks may need edit mode.

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.