How Do You Connect a SharePoint Web Part to SQL Server

Posted on 2011-04-22
Last Modified: 2012-06-22
How do you connect a SharePoint Web part to MS SQL Server 2008 using a SQL connection string?  Also, I would like to query a table from the server and insert the results into a Visual Studio 2010 Data Grid.


Question by:danielolorenz
    LVL 9

    Accepted Solution

    There are Sharepoint 2.0 Web parts that are used to connect to report server and to load the data in sharepoint server from sql server 2008
    Check this

    Author Closing Comment

    Great Help

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now