Building a calendar with Sharepoint 2010 with data from an SQL Query

Posted on 2012-09-20
Last Modified: 2013-11-09
From what I know about Sharepoint 2010, a calendar is simply a Sharepoint List displayed in a calendar form.

Based on this, I am trying to build a Sharepoint Foundation 2010 calendar that is populated (dynamically) from a SQL query that I have done using SQL Business Intelligence Development Studio.

The query uses two variables (beginning date and ending date) that produces a two column report that contains dates and event names between the two dates. I want to use this query result to populate the Sharepoint 2010 calendar and embed it in a Web page. I would like for someone to be able to run the query to show events for the current month.

OTHER INFO: Sharepoint Foundation 2010 is installed on Server A and SQL is installed on Server B. Both are all installed and working. My intent is to use the SQL server as a Report Server for Sharepoint. I just learned that I have to install Sharepoint Foundation on both A and B in order for A to use B as a report server.

Can this be done? If so, does anyone have any guidance on how to do this?
Question by:Blackhawk_Church
    1 Comment
    LVL 9

    Accepted Solution

    you should do it programatically. i would suggest you to create a calendar list in SharePoint first with the field names a you want.
    now write a actions or a button, which can be a user control, a web part with a button, a link in the context menu what ever prefer.
    in the click event of that button write your code that will read the values from sql server and insert a new element in the calendar if not exists.
    do this for all the elements present in your sql server once completed redirect the current page to the calendar list page.
    this way every time a user clicks on the button he should get the calendar he wants to see picking the information from the server.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (…
    Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now