Latest guide
SQL Server
SQL Server STUFF() Function With Example
1 comment
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
Practical guides for everyday development
Explore step-by-step tutorials, working examples, and fixes for C#, ASP.NET Core, SQL, and web development.
Latest tutorials
12 tutorials
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