Examples

Development in Visual Studio

To be able to query information from your SharePoint environment in Visual Studio, simply add a reference to the Camelot .NET Connector assembly. The code is very similar to what you would write with any other ADO.NET driver, such as the Connector/NET driver for the MySQL database. Because the connector uses standard SQL syntax to execute commands, developers typically don't need much prior experience of building SharePoint applications.

 

Using the connector with SAP Crystal Reports

Camelot .NET Connector can be used to generate ADO.NET (XML) data sources that can be selected in SAP Crystal Reports when designing reports. In Visual Studio 2010, reports can also be created using Crystal Reports IDE provided by SAP. Reports can then be displayed in your application providing up-to-date data from your SharePoint server using the connector.

 

Developing SharePoint Web Parts

Camelot .NET Connector can easily be used in SharePoint development such as in web parts to simplify access to data in lists and views. By doing so, developers can focus on building powerful SharePoint tools and utilities. The example below shows a web part that connects to a list called "MyWebPart List" and prints the ID and Title columns.

Simple WebPart

Public Class MyWebPart
Inherits Microsoft.SharePoint.WebPartPages.WebPart
 
  Protected Overrides Sub CreateChildControls()
 
    MyBase.CreateChildControls()
 
    Try
      Dim conn As New Camelot.SharePointConnector.Data.SharePointConnection("Server =localhost;Authentication=Default;")
 
      Dim adapter As New Camelot.SharePointConnector.Data.SharePointDataAdapter("SELECT ID, Title FROM `MyWebPart List`", conn)
 
      Dim dtMyWebPartList As New DataTable()
      adapter.Fill(dtMyWebPartList)
 
      For Each row As DataRow In dtMyWebPartList.Rows
        Me.Controls.Add(New System.Web.UI.LiteralControl(row.Item("ID").ToString & ": " & row.Item("Title").ToString & "<br />"))
      Next
    Catch ex As Exception
      Me.Controls.Add(New System.Web.UI.LiteralControl(ex.Message))
    End Try
  End Sub
End Class

See our free and opensource Web Parts at the Web Part section on the download page.

 

Build rich external applications

Camelot .NET Connector can be used to build very rich and powerful applications that really extends the boundaries of your SharePoint interface. This example shows the Camelot Query Browser implementation. This web application is a great tool for experimenting with SQL commands and to learn how to use the connector in code.

Visa     MasterCard