ADO.NET
-
How to Loop Through an Excel Spreadsheet in a .NET Application
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…
-
Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly
I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time: In simplifying your task of putting the Workbook and Worksheets together and I can’t stress enough how much time this will…
-
VB.NET Basic Database Query Examples
Here is my compilation of example code for a variety of database operations written in VB.NET These range from: