Tags » Visual Studio 2010

C# Read Excel file with worksheets

using System.Data;
using System.Data.OleDb;

private void readExcel () {

OleDbConnection conn = new System.Data.OleDb.OleDbConnection((“provider=Microsoft.ACE.OLEDB.12.0; ” + (“data source=C:\\Projects\\Driver Reports.xlsx; ” + “Extended Properties=’Excel 12.0;HDR=Yes;IMEX=1;’;”)));

// Select the data from Sheet1 of the workbook. 92 more words

Visual Studio 2010

Example of Setting up a Blank Windows Service in Visual Studio 2017

When you are creating a new Windows Service Application in NET, you can’t simply generate the project and then click F5 to debug in Visual Studio. 1,350 more words

Programming

Add an assembly into .wsp package

I have a project that needs to use Microsoft Exchange WebServices (Microsoft.Exchange.WebServices.dll). After I deployed the solution into SharePoint 2016, sometimes I receive the following error: 93 more words

SharePoint 2010

Get the Total Number of Documents in a SharePoint Site Collection Library and its Sub Folders using .NET

One thing that you often need and that is quite annoying to get in a default SharePoint installation is the total number of files in a document library and all of its sub-folders… 701 more words

Programming

Visual Studio 2010 - Upgrade from RTM to SP1

Background

Just as yourself, got a lot to do, but occasionally get pulled back in.

SQL Server 2008-R2 Upgrade

My manager has signed us up to upgrade all SQL Servers to the most recent version, 2016. 374 more words

Microsoft

Get all items from a list performance

Running on a list with 4,000 items. Option 1 is on average 1 second slower than Option 2.

Option 1:

using (SPSite currentSite = new SPSite(SPContext.Current.Site.ID)) 128 more words

SharePoint 2010