.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”

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

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, ASP.NET, Programming, SharePoint, Software, Technology, VB.NET, Web Development, WebForms

Read a SharePoint Document Library’s Row Details in .NET

SharePoint Documents List
SharePoint Documents List

In this example you’ll see the basics of programmatically connecting .NET code (a simple WebForm) from your local machine to read a Documents list hosted on a SharePoint server. Specifically, in this example I am using Visual Studio 2017 and am connecting to a SharePoint 2016 site on the local network. Continue reading “Read a SharePoint Document Library’s Row Details in .NET”