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


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


Visual Studio 2010 - Upgrade from RTM to SP1


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


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