How Do You Connect a SharePoint Web Part to SQL Server

Posted on 2011-04-22
Medium Priority
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

Accepted Solution

kukdai earned 2000 total points
ID: 35450380
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

ID: 35450708
Great Help

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

864 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