StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>In addition to Frédéric Hamidi excellent answer.</p> <p>This is most likely what you are looking for <a href="http://www.bendsoft.com/net-sharepoint-connector/" rel="nofollow">http://www.bendsoft.com/net-sharepoint-connector/</a>. It connects through the SharePoint API so you can use it for both internal and external development of SharePoint. Foremost you don't need to learn CAML and use SQL instead.</p> <p>Example </p> <p>Insert some data</p> <pre><code>public void SharePointConnectionExample1() { using (SharePointConnection connection = new SharePointConnection(@" Server=mysharepointserver.com; Database=mysite/subsite User=spuser; Password=******; Authentication=Ntlm; TimeOut=10; StrictMode=True; RecursiveMode=RecursiveAll; DefaultLimit=1000; CacheTimeout=5")) { connection.Open(); using (SharePointCommand command = new SharePointCommand("UPDATE `mytable` SET `mycolumn` = 'hello world'", connection)) { command.ExecuteNonQuery(); } } } </code></pre> <p>Or to select list data to a DataTable</p> <pre><code>string query = "SELECT * FROM list"; conn = new SharePointConnection(connectionString); SharePointDataAdapter adapter = new SharePointDataAdapter(query, conn); DataTable dt = new DataTable(); adapter.Fill(dt); </code></pre> <p>Or using a helper method to fill a DataGrid</p> <pre><code>string query = "Select * from mylist.viewname"; DataGrid dataGrid = new DataGrid(); dataGrid.DataSource = Camelot.SharePointConnector.Data.Helper.ExecuteDataTable(query, connectionString); dataGrid.DataBind(); Controls.Add(dataGrid); </code></pre> <p>Take my word for it, this turn SharePoint development into a lot of fun!</p> <p>Cheers</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload