Requirements
- Microsoft SharePoint 2007/2010 with
- Administrative privileges to deploy Web Parts at the server and in SharePoint
- .NET SDK, you need gacutil to deploy the binaries (http://blogs.iis.net/davcox/archive/2009/07/14/where-is-gacutil-exe.aspx)
Installation
- Download and extract the binaries from the Bendsoft website www.bendsoft.com
- Open a command prompt and deploy the dll's
- Deploy the CamelotListSQLCommander.dll in the GAC (gacutil -i CamelotListSQLCommander.dll)
- Restart iis (iisreset).
- Register the webpart in the web.config file of your SharePoint site
- Open the file, usually located in C:\inetpub\wwwroot\wss\VirtualDirectories\xx
- Add a new <SafeControl tag between the <SafeControls>...</SafeControls> (see below)
<SafeControl Assembly="CamelotListSQLCommander, Version=1.2.0.0, Culture=neutral, PublicKeyToken=80ae564bc7585dd6" Namespace="CamelotListSQLCommander" TypeName="*" Safe="True" AllowRemoteDesigner="True" />
- Deploy the Web Part in SharePoint
- In SharePoint navigate to the Site Settings (/_layouts/settings.aspx) and click "Web parts" in the Galleries section
- In SharePoint 2007 click New, in SharePoint 2010 click the Documents tab > New document
- Find the Camelot Web Part in the list, select the checkbox and click the "Populate Gallery" button.
- Set up the Web Part
- Add the Web Part to a list. Go to a list and click "Edit Page" at "Site Actions", click the Add a Web Part button
- When added edit the web part and set up everything in the ConnectionString section.
- Save and close
ConnectionString Settings In SharePoint
Edit the web partÂ
Set up the ConnectionString section with your details