CSV Import Preview in ASP.NET Core with Duplicate Checks
Add comment
A CSV upload shouldn't write anything to your database until the user has seen what's in the file. This tutorial shows how to build ...
Read tutorial
Browse articles
More programming tutorials
Upload Excel File to ASP.NET Core from Angular using EPPlus (.NET 10)
Short answer: to upload an Excel file from Angular to ASP.NET Core, send the .xlsx file as FormData in a POST request, accept i...
Read tutorial
Stream Large CSV Exports in ASP.NET Core with EF Core
Exporting a few hundred records to CSV is straightforward. Exporting hundreds of thousands or millions is different: if you build a L...
Read tutorial
XML to JSON Converter Online – Free, Runs in Your Browser
This free XML to JSON converter runs in your browser. Paste XML or choose a local XML file, pick your output options, and convert it to form...
Read tutorial
SQL Server STUFF() Function With Example
Short answer: the STUFF function in SQL Server deletes a number of characters from a string, starting at a position you choose, and then i...
Read tutorial
What's New in .NET 11? C# 15 Features, Runtime & APIs
Short answer: .NET 11 introduces C# 15 union types and closed hierarchies, collection-expression arguments, extension indexers, labeled bre...
Read tutorial
Rename Column If Exists in PostgreSQL (Safe DO Block)
PostgreSQL has no column-level IF EXISTS option for RENAME COLUMN . To rename a column only if it exists in PostgreSQL, check the system ca...
Read tutorial
Get Distinct Records from a DataTable in C# Using LINQ
To get distinct records from a DataTable in C#, use LINQ to DataSet. When rows must be identical in every column, call Distinct(DataRowComp...
Read tutorial
OpenAI Codex CLI Tutorial for C#: Build a .NET 10 API
This OpenAI Codex CLI tutorial shows OpenAI Codex for C# developers in practice: how an AI coding agent can inspect a repository, implement ...
Read tutorial
Claude Code vs GitHub Copilot for ASP.NET Core Developers
If you write C# for a living, the question is no longer whether to try an AI coding tool. The real decision is which workflow fits the way y...
Read tutorial
Export DataTable to CSV in C# Without a Library
To export a DataTable to CSV in C#, write the column names as a header, escape each field, and save the result with an explicit encoding. T...
Read tutorial
Read CSV File in ASP.NET Core & Web Forms (C#, VB.NET)
To read a CSV file in ASP.NET, accept the upload, parse it with a real CSV parser, validate each record, and show the rows in a tab...
Read tutorial
Merge Two or More PDF Files in C# Using iTextSharp
How to merge PDF files in C# Version scope: This example uses iTextSharp (iText 5), a legacy library. Its APIs differ from current ...
Read tutorial
How to Extract Tables from a PDF to Excel with Python (Camelot vs. pypdf)
Copying a table out of a PDF and pasting it into Excel is slow, and it's easy to shift a column or drop a row without noticing. If ...
Read tutorial
Secure JWT Authentication with HttpOnly Refresh Tokens in ASP.NET Core Web API
The short answer: Don't store JSON Web Tokens (JWTs) in localStorage , because any JavaScript running on your page can read them. In AS...
Read tutorial
Angular Signals vs. RxJS: Where Each One Belongs in Real-World Enterprise Apps
The short answer: Use Angular Signals for synchronous state that a component owns and shows in its template, such as counters, toggles...
Read tutorial
Upgrade to .NET 10 from .NET 8/9: Common Build Errors, Breaking Changes, and How to Fix Them
The short answer: To upgrade to .NET 10 from .NET 8 or 9, install the .NET 10 SDK, change your target framework moniker (TFM) to net...
Read tutorial
Migrate Roles to Policy-Based Authorization in ASP.NET Core
Many ASP.NET Core projects start the same way. Someone adds [Authorize(Roles = "Admin")] to a controller, it works, and the team ...
Read tutorial
C# Records vs Classes vs Structs: Which Should You Use?
C# classes, structs and records differ in assignment, equality and mutability. Start with the reader task and the semantics your type needs....
Read tutorial
ASP.NET Core Dependency Injection Interview Questions (30)
Introduction If you're preparing for a .NET developer interview, dependency injection questions will come up — not as a formality,...
Read tutorial