.Net, ADO.NET, ASP.NET, C#, Data Sources, Database, Excel, Excel 2003, Excel 2007, Excel 2010, Programming, Software, VB.NET

How to Loop Through an Excel Spreadsheet in a .NET Application

Import data from MS Excel into your .NET code

MS Excel is a great tool that a lot of employees at a company are very familiar with using. It helps structure and organize data in a way that is very intuitive to users without the users needing to be especially technical. So it should come as no surprise that sometimes you will want to write code to interface with data from Excel. Continue reading “How to Loop Through an Excel Spreadsheet in a .NET Application”

ASP.NET, CSS3, HTML, HTML5, JavaScript, Programming, VB.NET, WebForms

Javascript and Bootstrap CSS: Showing a Save Screen that Locks Page Elements

The goal of this example is to make all elements on and HTML form un-selectable while something like a Save/Load/long database lookup is happening. What we’ll do is superimpose a div over an HTML form, and have that div show opaque lines over the form as well as a clear area that says Loading or Saving.

We’ll make the page look like the image to the left, so that it is clear to the user that the form they were working on is temporarily disabled. Continue reading “Javascript and Bootstrap CSS: Showing a Save Screen that Locks Page Elements”

.Net, Data Sources, MS Exchange, MS Office, MS Outlook, Outlook, Outlook 2010, Programming, Software, VB.NET, Visual Studio, VSTO

Programatically Connecting to MS Exchange Using EWS

You can do a lot with your code when you write an application that communicates with your Exchange server. But getting the setup to work for you in Visual Studio isn’t always as intuitive as it should be. Here are the steps I went through getting my project in Visual Studio set up and connecting to MS Exchange.
Continue reading “Programatically Connecting to MS Exchange Using EWS”