Imports Microsoft.SharePoint.Client Imports Microsoft.SharePoint Imports System.Security Imports System.Net Public Class Form4 Dim siteUrl As String = "https://example.sharepoint.com/site/SiteExample/" Dim context As New ClientContext(siteUrl) Dim web As Web Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Try Dim userNameSP As String = TextBox1.Text Dim password As String = TextBox2.Text Dim secureString As SecureString = New NetworkCredential("", password).SecurePassword Dim cred = New SharePointOnlineCredentials(userNameSP, secureString) Dim clientContext As New ClientContext(siteUrl) clientContext.Credentials = cred Dim web As Web = clientContext.Web Dim oWebsite As Web = clientContext.Web Dim collList As ListCollection = oWebsite.Lists Dim oList As List = collList.GetByTitle("Example Test") clientContext.Load(oList) clientContext.ExecuteQuery() Dim query As CamlQuery = CamlQuery.CreateAllItemsQuery() query.ViewXml = "<View Scope='RecursiveAll'><Query><ViewFields><FieldRef Name='Category/></ViewFields></Query></View>" Dim AllItems As ListItemCollection = oList.GetItems(query) clientContext.Load(AllItems) clientContext.ExecuteQuery() If AllItems.Count > 0 Then ... Do Something end if Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub End Class
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)