Installation

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

  1. Download and extract the binaries from the Bendsoft website www.bendsoft.com
  2. Open a command prompt and deploy the dll's
    1. Deploy the CamelotListSQLCommander.dll in the GAC (gacutil -i CamelotListSQLCommander.dll)
    2. Restart iis (iisreset).
  3. Register the webpart in the web.config file of your SharePoint site
    1. Open the file, usually located in C:\inetpub\wwwroot\wss\VirtualDirectories\xx
    2. 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" />
  4. Deploy the Web Part in SharePoint
    1. In SharePoint navigate to the Site Settings (/_layouts/settings.aspx) and click "Web parts" in the Galleries section
    2. In SharePoint 2007 click New, in SharePoint 2010 click the Documents tab > New document
    3. Find the Camelot Web Part in the list, select the checkbox and click the "Populate Gallery" button.
  5. Set up the Web Part
    1. 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
    2. When added edit the web part and set up everything in the ConnectionString section.
    3. Save and close

ConnectionString Settings In SharePoint

Edit the web part 
SP List SQL Commander Set Up 1.png
Set up the ConnectionString section with your details
SP List SQL Commander Set Up 2.png
Visa     MasterCard